| Thread | Last Post | Replies |
|
| If list box null | 19 Feb 2005 05:20 GMT | 1 |
Don't over think this, because I'm MORON.
>On a form I have a listbox and when that listbox returns no results I would like something eles to happen. |
| Wheel Mouse and code window | 19 Feb 2005 00:27 GMT | 5 |
Why doesn't the wheel, on my mouse, work in the Visual Basic window? To scroll, I have to use the slider. It is a pain. Have I missed a setting somewhere?
|
| msoFileDialogSaveAs | 18 Feb 2005 22:45 GMT | 5 |
I have AccessXP with ServicePack3 installed. I have referenced the Microsoft Office 10.0 Object Library. I can access the FileDialogOpen and FileDialogFilePicker but it refuses to let me access FileDialogSaveAs. Any help would be appreciated.
|
| Date string and Charater string syntax | 18 Feb 2005 22:09 GMT | 4 |
I need some help on setup up a syntax string for finding UserID and Log date and blank Time field. Here is my code Dim rs As DAO.Recordset
|
| Alarms | 18 Feb 2005 20:51 GMT | 3 |
I would like to create something in access so when certain dates expire that I have in a table or query I get some kind of notice. Is this possible? Thanks, Kelli
|
| Using Code to modify Code in MS Word | 18 Feb 2005 20:19 GMT | 1 |
Is it possible through ole automation to use code in Access to programatically modify lines in WORD code modules, similar to the Modules collection in Access? Thanks in advance!
|
| John Nurick [Microsoft Access MVP]-Static/Global usage | 18 Feb 2005 20:15 GMT | 1 |
1) I go out and read the data base name which will always include the facility number IE-060002 Kansas, 060003 New York, etc. 2) I concatenate that name and use only facility number to make my new table and append data to it IE-060002, 060003, etc.
|
| Add New SubRecord if one doesn't exist. | 18 Feb 2005 19:34 GMT | 4 |
Another basic question ... and my brain is fried... Please help. Two tables are linked by RecID (one to many with referential integrity added). The 1st table has RecID entered by AutoNumber upon the addition of new records. The 2nd table doesn't have the RecID (number field) ...
|
| Open Folder on Network via Command Button | 18 Feb 2005 19:13 GMT | 2 |
I have a form which displays a single record with a single field [SKU] at a time. On this form, I have a command button, which on a click, I would like for it to open a folder on our company's network. For example, if [SKU] = C100 on the current record, I would like to build ...
|
| looping through all items in a combobox | 18 Feb 2005 19:05 GMT | 3 |
Access 97 I have a combobox on a form. The row source for the combobox comes from a SQL statement that queries a table.
|
| read a Access table and processing record by record | 18 Feb 2005 18:37 GMT | 4 |
Can someone please provide a sample of how to read a Access table. I need to set one field based of the value of other fields. I would like to do this thru VBasic. Because I am going to have multiple test conditions.
|
| Need macro to stop if table is empty | 18 Feb 2005 18:11 GMT | 4 |
Hello, I have a query that makes a table of tickets not assigned to our technicians. If the table has tickets in it, I want the macro to launch a program, which I think I can do. The problem I have is if the table is empty
|
| truncation error | 18 Feb 2005 17:58 GMT | 7 |
I am writing a function in VBA to implement an algorithm that my company uses. This algorithm takes the input, multiplies the number by a certain factor (1.025 in this case), and then truncates the number to the tenth place. This process is repeated TableUp number of times. ...
|
| VBA Code - Records from linked tables and appending to unlinked table | 18 Feb 2005 17:51 GMT | 1 |
I am using the code below to search for records on all linked tables (Seven linked tables). The records are appended along with a ~tmp1&*? table created some how created by my code. Can someone tell me how to change the code to eliminate the extra table and streamline the code?
|
| Error: 'saveRecord' isn't available now | 18 Feb 2005 17:46 GMT | 8 |
Im getting an error on the save statement below. It actually saves the first 2 statments in the table using the 'QueryAddStatusNextDate'. But it does not add the 'QueryAddStatusReminderDate'. I don't know if it is because the QueryAddStatusReminderDate is a update query and ...
|