Search results
-
U
Change Environment String
Hello :-) I'm trying to change an environment-string through VBA in Access. It doesn't even have to be perminant, just so that the module runs correctly I need to have it change the PATH statement. I know I have used ENVIRON to get the current string, but it doesn't appear I can use it to...- usachrisk
- Thread
- Replies: 3
- Forum: Modules & VBA
-
U
How to Pass Variable to Query
Hello Everyone - I have a Query that queries a table to return the results where a certain ID is met. I'd like to have a listbox populate with the results of the query run through VBA. The Query is setup to prompt for the ID#, then return the results. I can run the Query in VBA, but it will...- usachrisk
- Thread
- Replies: 4
- Forum: Modules & VBA
-
U
Lotus Domino Object Help
Hello - I'm currently using the Lotus Domino Object Reference in MS Access 2000 to pull in records from a Lotus Notes Database, however the NOTES.INI file resides on a network drive where I am employed, so it can only find the INI if a make a copy of it and place it in c:\notes\. Is there a...- usachrisk
- Thread
- Replies: 0
- Forum: Modules & VBA
-
U
Count on Table Relationship
Hello - I'ved used SELECT COUNT(*) FROM <table> as <Field> in the past to get the count of records in a table, but I need something a little more detailed for a specific DB I'm working on. My Setup is that I have two tables. One has account numbers, and one has a list of Employees associated... -
U
Unable to Select Item from Combo Box
Hello, I have a table in my database that I'm having an issue with. Basically, there are two tables that relate to each other as follows: I have a table called AccountNumbers with the following fields: CostCenter - Text(6) Vendor1Acct - Text(11) Vendor2Acct - Text(11) Flag - Text(255) and I... -
U
Referencing Column Number in Query
Hi - I have a query this is using two tables. Each table has a field called "CostCenter" - so I have table1.costcenter and table2.costcenter. Table1.CostCenter has 3 columns in it. I'm trying to build a query that will display on those CostCenter fields that do not match. I have it now to a... -
U
DateDiff in Table itself?
Hello, I know how to use the DateDiff function in a form so that I could find out the differences between two dates, but is this at all possible directly in the table? I.E. for simplicity sake, let's say I have four fields in one example table: ID (autonumber) Start Date (Date/Time) End Date...