Threads Replies Last Post 26 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26   how can i tell by code witch control has the focus? how can i tell by code witch control has the focus? thanks ... 3 5/31/2007 12:30:40 PM È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ ÒôÀÖºÐ4.8Ôª£»ÒôÏ첨1.8Ôª£»²»µ¹ÎÌ3.8Ôª£»ÔÓÎïͲ5.8Ôª¡­¡­ ¸ü¶àÐÅÏ¢Çë¼ûÍøÕ¾:www.jl-sm.com ... 1 5/31/2007 3:28:40 AM È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ ÒôÀÖºÐ4.8Ôª£»ÒôÏ첨1.8Ôª£»²»µ¹ÎÌ3.8Ôª£»ÔÓÎïͲ5.8Ôª¡­¡­ ¸ü¶àÐÅÏ¢Çë¼ûÍøÕ¾:www.jl-sm.com ... 1 5/31/2007 3:28:31 AM frgrth sghsfhsthtatan tysr atytrsyus tys tyhsty ... 1 5/31/2007 2:46:22 AM Appending Records. Subform Providing Parameters. I have a form called "frmSearchByTRS". On that form there is a SubForm called "sbf". The SubForm can hold many combinations of Township, Range Section Data. I have created code (AssembleTRS) to look at the parameters selected on the SubForm record, create an Append query and append the records to a table I will call "tblTempTRS". This is an example of a wrapper function I am lookin... 2 5/31/2007 1:18:16 AM Copy Data From an ACCESS form to a WORD Template I have a Front-End ACCESS db (linked to (3) Tables on a Back-End SQL Server). I have a series of Queries that manipulate the data and populate an ACCESS Form. This Form has the following features: 1. A Main Form, with several pages (Tabs) which display data from one (OverallData) Table a. One of these pages (Tabs) contains a Sub-Form which displays data from another (SpecificDat... 14 5/30/2007 6:58:12 PM Directing/Specifying a Print Request/Location I'm pretty sure this is possible, but I'm lost in trying to figure it out .... I have (2) pieces of code which work individually -- I need to modify/incorporate the two so that they print data into the same WORD template Here's my code: ================ (This sub prints the data on an ACCESS form) Private Sub Command83_Click() On Error GoTo Err_Command83_Click Dim stDocName ... 10 5/27/2007 1:43:28 AM transfer to syte the username and the password when cliking the path hyperlink i have a form that stores path to sytes (as hyperlink), username and password is there is a way to transfer to syte the username and the password when cliking the path hyperlink to submit automaticly? thanks ... 2 5/26/2007 8:26:36 PM Hide Access application window Here's a question that came up indirectly in another NG, and I didn't think you could do it, but I thought I'd ask around: if for some reason you wanted your Access application to look like a stand-alone app, could you hide the Access application window and JUST leave your own forms visible? Even if you (obviously) can't make them truly independent windows, could you fake it? Rob... 19 5/25/2007 5:31:03 PM Access 2003 : Numbering alarms by PermitNo so that after 365 days of the last number 1, the count returns to 1 Hi everybody ! In February I had an answer to the question in objet. See the codes below : UpdateNoAlarmeIncendie and GetNoAlarmeIncendie. What I need to find now, is a way to keep some alarms out of the numbering system. I added a yes/no field to identify these alarms : AlarmeFondee I tried to create a new variable : Dim varAlarmeFondee As Variant And these codes : varAlarmeFon... 14 5/25/2007 1:35:04 PM Loop Until Max Records = 0 I have an Access database which takes records in one table and copies them in multiple lines according to a number in a field. ex. Table 1 - Raw Data Bob Smith - 3 Sue Smith - 2 Table 2 - Results Bob Smith Bob Smith Bob Smith Sue Smith Sue Smith I have a macro which works with two pieces of code: Part 1 INSERT INTO tblDeallocateRound1 (Acct, FirstName, LastName) SELECT *... 5 5/24/2007 10:31:41 PM Module Help Updating Tables I want to take the following module, and have the info added to a table when the user opens the database, and removes the user from the table when it's closed. I have to maintain this database and need to be able to see who's in it at the time. It's practically used 23 hours a day. Any suggestions? Thanks. ------------------------------------------------------------ Function fGetUserName()... 3 5/24/2007 3:02:38 PM add automatically the references How can I add automatically the re ferences? Thnaks JCP ... 2 5/24/2007 2:58:28 PM Inserting data from an ACCESS form into a bookmark in WORD I have the following code (which opens a NEW Word document and prints the data from my ACCESS form) -- I need code that will open a specified WORD template and insert the ACCESS data into a specific bookmark. I'm sure this is a simple process, but I'm somewhat frazzled (at this point) and have settled on this option over several previous suggestions. Here's the code I need to modify: ... 3 5/24/2007 12:26:18 PM Calculations different in Access and Excel My client has a spreadsheet where he enters 3 values and it calculates several additional values on the same row using some complicated calculations. Each row of data he enters also uses the prior rows data in it's calculations (except the first row, of course). I am trying to incorporate this functionality into an Access application they are using for other things. I have recreated the... 9 5/24/2007 7:45:42 AM Module Help Updating Tables I want to take the following module, and have the info added to a table when the user opens the database, and removes the user from the table when it's closed. I have to maintain this database and need to be able to see who's in it at the time. It's practically used 23 hours a day. Any suggestions? Thanks. ------------------------------------------------------------ Function fGetUserName()... 1 5/22/2007 3:26:02 PM Loop Hello all i have a table that has to be created dynamically and so far the code below works fine except when i have 2 of the same type of record. So for instance what comes from tblplots is this Compartment Stand MarkingUnit PlotNum Species DBH Cut/Leave 108 111 B 2 318 34 1 108 111 B ... 2 5/21/2007 9:57:21 PM F.name field is this possible in a report txt1.value = rs1!F.name where rs1.dbf = txt6.value here is the whole thing Dim f As Field Set DB = CurrentDb() Set rs1 = DB.OpenRecordset("Select * from tblStand") Do While Not rs1.EOF For Each f In rs1.Fields If f.Name <> "DBH" And f.Name <> "Flag" Then txtSpc1.Value = f.Name txt1.value = rs1!F.name where rs1.dbf = txt6.value ... 2 5/21/2007 9:08:49 PM How to run code every night at midnight We want to run code every night at midnight in our access program. What is the simplest way to do this? ... 5 5/21/2007 1:25:06 PM Sending variables to a Function via a form...can it be done? I have the following function in a module that is working fine: Public Function Net(GrossAvailable, OpIndex) Dim Operations As Double Select Case OpIndex Case 1 Operations = 215 Net = GrossAvailable - Operations Case 2 Operations = 430 Net = [GrossAvailable] - [Operations] Case 3 Operatio... 5 5/20/2007 4:50:04 PM Another newbie question... compile error. I'm still trying valiantly to work my way through a basic programming book. I wanted to replace the Access error message for a field I'm requiring entry for with a custom message. I entered the following code: Private Sub Form_Error(DataErr As Integer, Response As Integer) 'If error occurs because user neglected to enter Contact Type, display a custom error message. Const conErrFie... 2 5/20/2007 1:32:46 PM Access freezing up when working in VBA I'm a total newbie to VBA, so be gentle with me - it's my first time. I'm working through a book called Microsoft Access 2000 Visual Basic for Applications Fundamentals. Sometimes the author has you enter code incorrectly to learn about proper syntax and to see how to go about fixing a problem when it occurs. The problem is, whenever I have entered something wrong & the dreaded yellow hi... 3 5/19/2007 9:44:28 AM Null value won't pass into function Hi All, I have started tearing my hair out over this problem! I am pulling some data from a table and passing it as variables into a function in Access. One of the variables I'm passing through can be Null, so to avoid trying to pass a Null value to a function as a string (which I gather Access wouldn't like) I created an IIF function inside the parameters so if the value was null, it pa... 11 5/18/2007 12:51:02 PM import contacts from public folders in outlook exchange ? how can i import contacts from public folders in outlook exchange ? thanks ... 2 5/18/2007 1:06:24 AM Printing multiple pdf files I have an Access database for distributing Sales Statements. It generates them as Report Snapshots, emails some, faxes some and prints the remainder to be posted. Because not all Customers are able to read Snapshots, I would prefer to change to Portable Document files. I have managed to get PDFCreator to generate the files and Outlook to email those that can be emailed, but I am havin... 5 5/16/2007 10:14:56 PM 26 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26