| Thread | Last Post | Replies |
|
| stLinkCriteria | 30 Mar 2005 09:00 GMT | 1 |
Can someone explain how this works? stLinkCriteria = "([tablename].[fieldname])=" & "'" & Me![formfield] & "'" (is this correct for text fields?) My undertanding is that the me![formfield] is passed to the field
|
| Access97: Combo Box and FE/BE split | 30 Mar 2005 06:34 GMT | 2 |
I am trying to split my database into a front-end and a back-end. I could not find a way to keep my forms' Combo Box as a Table/Query, as the database has become remote and there is no way to make the Table/Query type Combo Box query that other database.
|
| DoCmd.TransferText acExportHTML | 30 Mar 2005 06:13 GMT | 7 |
When using this command above, is there a way to determine the font size of the final product? I'm exporting a query but need the font size of the information bigger like 24 font. So I've gotten this far but not sure what the template would be, like the coding. I tried to make a ...
|
| NewData var not passing during NotInList event | 30 Mar 2005 04:53 GMT | 3 |
I'm trying to use the NotInList event on my 'cultures' form to open an 'addNumber' form, use 'addNumber' to add a number to the underlying lookup table, then return to the main form. Here is my sticking point: DoCmd.OpenForm addNumber, acNormal, , , acFormAdd, acDialog, NewData
|
| Adding a file path to a form field using CommonDlg | 30 Mar 2005 03:33 GMT | 1 |
I'm and experienced developer new to Access programming. I created a form that has a text box field for a file path. I'm trying to get the filepath into the field using VBA and can't get it to work. (I want the user to be able to browse for the file - and then I'll grab the path ...
|
| Subform Problem | 30 Mar 2005 03:20 GMT | 1 |
I have a main form with a subform in it the main form contains a close command button. The trouble is that I can close the form without any data in the subform, so I want have an error message to say that the subform details must be entered before closing and then set the focus back ...
|
| insert a watermark to a excel spread sheet | 30 Mar 2005 03:05 GMT | 1 |
How can I use a copied bmp. picture to be used as a background (watermark) on a excel spreadsheet? Thanks. Gareth
|
| Error (2450) when changing a forms recordsource through code | 30 Mar 2005 02:17 GMT | 4 |
I have a form that displays a bunch of information to the user. On the form, I have two command buttons that fire off a series of actions. The last action in the click event of each of these buttons is to open a form, which contains a couple of subforms, the difference being the ...
|
| Determining current file size | 30 Mar 2005 01:17 GMT | 2 |
How do I determine from code the size of the current MS Access file?
|
| Set focus | 30 Mar 2005 00:35 GMT | 2 |
I seem to have so much trouble with set focus. Does it trouble anyone else? Maybe I dont understand what it does or maybe its the if /then I am using. I have a very simple pop up form. it has 2 enties and I want to be sure that there is data in those fields before I close the ...
|
| user defined type not defined error | 30 Mar 2005 00:21 GMT | 5 |
Ok so Ive now got this code that i have written It produces a "user defined type not defined" error and stops at the * *Private Sub Item_No_AfterUpdate() Dim db As DAO.Database
|
| Setting the datasheet view to view only. | 29 Mar 2005 23:59 GMT | 7 |
Can I set the Datasheet view of a form to read only? I want other users to be able to look at the datasheet view but not enter any data using this view. Is this possible? What would I need to enter in the code? Thanks.
|
| Make a button active only when user is on last record or form | 29 Mar 2005 22:16 GMT | 2 |
Is it possible to know when the user is on the last record of the form and only have a button active on that record and in active for all the other records? Thanks in advance
|
| open access VBA shell command without Netmeeting | 29 Mar 2005 22:03 GMT | 1 |
I want to open another instance of Access from VBA code in a running instance of Acccess, and I can do that, but how do I prevent Netmeeting from automatically running and asking the user for their Name, email address, password etc. and Then running Netmeeting?
|
| Option Group Control | 29 Mar 2005 21:55 GMT | 4 |
I have a form with a field called "DocType" which I created a options group to fill this field in on my table. When I click on a choice: "Letter of Credit", "New", "Renewal", only the value that was assigned by the option wizard shows in my table. For reporting purposes this will ...
|