Threads Replies Last Post 363 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  27  28  29  30  >>   Multi options This may be a duplicate - I have a strange error when posting... My Goal: A form has 1 command button, 2 list boxes and 1 combo box (and 2 text boxes for the start & stop dates). When the user clicks the command button the results are (DoCmd.SendObject acReport) but before that = 9 options based on the 2 list boxes and 1 combo box... Here is what I have but I would have no problem sta... 19 29.09.2006 22:05:09 Copy & Paste Problems Access 2000, 2nd Post Operating System: Windows 2000 Networking System Novell Access 2000 SP-3 Several months ago converted from A97 to A2K Several forms (source sql) we have include a button that will shift to the datasheet view for users. In some cases, users will use the data sheet view to copy all displayed records to the clipboard and then paste them into Excel (2K version). This process worked witho... 1 29.09.2006 21:18:04 Help with looping thru a query and printing word docs Hi all, I am hoping someone can help. I need to run some sql and have it use the results of that query to print out some documents. Here is the query: SELECT tblMyTable.Id, tblMyTable.Desc, tblMyTable.DocName FROM tblMyTable WHERE (((tblMyTable.Id)>5)); Results in this: 1 Desc1 Doc1.doc 2 Desc2 Doc2.doc 3 Desc3 Doc3.doc 4 Desc4 Doc4.doc ... 2 29.09.2006 20:59:47 DLookup referenced by a control In a form, I would like DLookup to return a value in a field referenced by another control such as that: =Dlookup("{field referenced by another control}","[Table]","{record in form}={record in table}") I hope this is easy to understand and does anyone know how to solve this issue? Thank you in advance.... 2 29.09.2006 20:50:01 Go To Next Record (Macro) I have designed a Form that when you enter an amount into a field and press enter a macro is executed to take you to the next record (On Exit Event Procedure). There is also an Exit button on the form. The existence of the Event Procedure prevents access to the Exit button. Is there any way around this? Thanks for any help ... 4 29.09.2006 20:11:27 Checking for opened form Hi How can I check in code if a form is currently open i.e. running? Thanks Regards ... 5 29.09.2006 18:51:01 Open Form with specific Dimensions I have a database we use at work to track multiple items. I have it set to maximze on the AutoExec macro so everything is maximized...obviously. I do this as I use a lot of screeen space for all the data fields we display. I would like to open a form through a command button and display specific data only, but I do not want to have this "popup" form be maximized, I would like to have ... 2 29.09.2006 18:49:03 Error 3021 when function is called from both form and subform I have the following code in a standard module: Public Function CurrentEvents(frm As Form) ' Inserts current record number and total number of records ' (strCurrent, strTotal, strOf are defined in Declarations ' section of this module) strCurrent = frm.CurrentRecord frm.RecordsetClone.MoveLast strTotal = frm.Recordset.RecordCount strOf = strCurrent & " of ... 7 29.09.2006 18:40:07 Updating fields with VBA code In a form I have a table field that I want to set programatically from the Current event depending on the state of a button that I use as a toggle. The code line goes like this: If <bla..bla> Then Me.approved.Value = 1 Else Me.approved.Value = 0 End If The 'approved' field is of datatype 'bit'. This starts some funny behavor in Access (2003). Either I get an e... 4 29.09.2006 18:10:03 Troubleshooting Logging module Hello everyone, I have the following code that is supposed to grab the Novell user ID, the date, and save it into a table as a logfile. Public Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function GetUserName() As String ' Returns the network login name Dim lngLen As Long, lngX As Long Dim strUserName As Strin... 3 29.09.2006 17:54:22 Go to a record based on a table field. Hello, I am trying to create a button that will take the user to the record they specify in a text box. The will know what the primary key, but not the record number. How can I retrieve the record number based on a tables primary key field? or if there is another way please let me know. regards, Brian ... 8 29.09.2006 17:39:01 Tool to Copy Multiple Files from Multiple Location to Specific Fol I want to create a tool for my team that will allow them to select various files from various locations (Browse) and then copy them to a single location. The tool can select/copy them all at once or individually (after the TO location is set). Can anyone give me suggestion(s) for this? Any help that you can provide is welcome. Thanks, in advance, for your help. G... 1 29.09.2006 17:26:02 Go to Hyperlink when combo box selection made? I have a table which lists manuals and web links (URLs) to them. I'd like to set up a combo box populated from this table and when a selection is made, go to the hyperlink to view the manual. How would I do this? I have used hyperlinks on buttons but never a combo box. Is it possible?... 2 29.09.2006 17:07:32 Question about optimistic locking: Error 3197 - how does it know? With optimistic locking as I understand it if: User1 opens a record and begins working / editing with it at 9:00 AM and then gets called away from his desk before he can update the new mailing address. User2 could open the same record at 9:05 AM and make changes to FirstName at 9:10 AM and save .update her changes. When User 1 returns to his desk at 9:25 AM he would go to .Update the ... 6 29.09.2006 16:49:28 Generate Age from Date of Birth I have designed a Form that when the Date of Birth is entered the age is automatically generated in Years and Part year EG: 21.4 (Dec)imal) What I would like is that the Age be generated in Years and Months EG: 21 Years 5 Months. Is there a way this can be done in access? Thanks for any help... 6 29.09.2006 16:17:35 Sub Form Data Order I have a sub form that has rows of data and I need it sorted in [Status Date] order. I have put the following statement into the sub form "FORM" proterties against "Record Source", however while it returns the data it's sorted as per the table. SELECT * FROM [SIP Status] ORDER BY [SIP Status].[Status Date] DESC; any ideas?... 3 29.09.2006 16:05:02 Using mysql UPDATE query with LIMIT Hi, I have to run an update query when a user deletes a record in a subform of another form. The query itself is: UPDATE crmcontactdetails SET primary = 1 WHERE crmcontactdetails.primaryFirmID= " & Me.primaryFirmID & " AND crmcontactdetails.type= '" & Me.type & "' LIMIT 1 Now it works without the LIMIT 1 in it, however i need it there as it will return multiple rows and i only want... 8 29.09.2006 15:58:05 Form showing incorrect record I am using Access 2002. My database (Substance Material Safety Data Sheets) contains 650 records which were imported from an Excel spreadsheet exported from Access 97. I use 1 form which is paged all transactions related to the database are via commnad buttons and all are working fine. My Problem is: I wish to print another form (Abridged Datasheet) which should be the current record bei... 3 29.09.2006 15:08:01 How Do you get totals for distinct records on a form Hello my name is AJ Johnson, i am making a form, that allows students to recieve discounts based on Hrs they've worked. the table looks like this ID Employee_UIN Pay period Hrs_Worked 1 67613523 8/26/2006 12 2 65632153 8/26/2006 13 3 36212362 8/26/2006 5 4 67613523 9/7/2006 ... 3 29.09.2006 14:55:24 error at access - repair my open database I'm trying to perform an action at access but it gives an error with the option to repair the open database and restart microsoft Access. This problem has started a few days ago. What can be causing it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1 ... 8 29.09.2006 14:50:48 Row Source of cbo Background info: For each building we service, there is a table with supplies available to that buiding. I have a form with a text box on the top of it where you enter which building you will be ordering supplies for. On this form there is a subform where you enter the products you'd like to get for that building. On that subform the product Number is a cbo box. I'd like to set th... 14 29.09.2006 14:49:02 DMax Hi all I have a small problem with Dmax I want to increment the Invoice Number depending on the invoice Series to the next number as follows : Invoice Series A , Invoice Number 1. Invoice Series No Series , Invoice Number 1 Now when I issue the next invoice eith Invoice Series A the Invoice Number is To be 2 and so on. For this purpose I use the following code after the Before Inse... 3 29.09.2006 14:25:01 Change the On Mouse Wheel event Rather than have the form change records when I use the mouse wheel, I'd like to have a listbox that's already been populated with values to just scroll up or down. I can't imagine this should be too hard but I'm too much of a newb to know how to do it. Many thanks.... 2 29.09.2006 14:18:02 Auto click on a field which updates to show status of order I have a database which logs customer orders. One of my forms is an Order Queue in which various dates and times are recorded to update the status of the order, (the form displays multiple orders in one liners), I have a 'Status' Field which shows the status of each call, i.e. Logged, Scheduled, Complete etc - The problem I have is that I can only update the field by clicking on it for... 3 29.09.2006 13:33:02 storing path only to database helo..i'm az...from kuala lumpur...i would like to ask a question about access...i have doing a project based on access...i have done it successfully but now the problem is size of the file...the limit for access is only 2gb...but the file that i have to put in that database is about 5gb..the type of file that i have to store is images(bitmap) about 38000 images...before this,i store all the ... 7 29.09.2006 11:27:41 363 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  27  28  29  30  >>