Recent content by usachrisk

Hi Travis - Thanks for your reply, however I don't see how either command will help me. The reference I'm using searches only the folders in the PATH statement. Thanks Again, Christopher.

Are you trying to get a form text box to display the username of the person who logged into access? If this is the case, you can use: txtUserName = Application.UserName Where txtUserName is the name of the textbox. Christopher.

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...

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...

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...

Hi - Can you be a bit more specific? I've never heard of any type of grouping in a query and help doesn't do much for me either on "Totals Query" or Grouping in a Query. - Christopher.

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...

Hi Pat - I figured it out and you were 1/2 right -- costcenter was unique which was what was throwing me for loops -- but my damn BoundColumn was set to 2, which is Vendor1 which, although normally unique, was not in some cases because some of them were N/A. I'm not sure how BoundColumn got...

Hello - I have no relationships in my table and the only way that these two tables are connected is like I explained in that the PagersList table uses the accountnumbers table in a lookup on the CostCenter column. Christopher.

Hi GS1, If you create a module and put your subs and functions in there, you should be able to call them from any form in your access database without issue. Christopher.

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...

My SQL is as follows: SELECT PagerList.Employee, PagerList.PrimaryPagerNumber, PagerList.CostCenter, tblDirectory.CostCenter FROM PagerList INNER JOIN tblDirectory ON PagerList.Employee = tblDirectory.CustomerID WHERE ((Not (PagerList.CostCenter)=[tblDirectory.CostCenter])); The reason the...

Thanks Pat -- I have a relationship between the Employee Names (which match exactly) in the two tables I'm putting in the query.

Thanks for your reply. I think it'd be easiest if I put in eactly what I have (of relevence). Tables: AccountNumbers, PagerList and tblDirectory. AccountNumbers: Has Costcenter, AccountNumber, SecondAccountNumber fields. Pager List: Has a list of pagers, phone numbers, employees, etc. One of...

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...