Search results for query: *

I spent quite a bit of time yesterday finding a solution to a problem, and I did get it to work, but I feel sure there is a much easier way to accomplish it. I welcome any ideas on making this work better. I have a Union query that returns 48 rows (theoretically this number is consistent...

I am trying to find the "last saved date" from a group of files. One is an Excel file and the others are .txt files. I was able to find the correct date for the Excel file using BuiltInDocumentProperties after using GetObject, but GetObject is not working on the text files. Do I...

Hi, I recently converted a db from 97 to 2k. I have a combo box with the RowSource modified in the code as different option groups are changed. One of the statements returns a Short Date and another returns the Year using a DatePart function to find it. The combo box worked fine in 97, but...

I am creating a form for setting up a new account. The form is a tab control with 4 tabs. Tab 1 collects the name of each customer on the account. Tab 2 collects address and phone information for each of those customers. Tab 3 collects information regarding each piece of collateral on the...

I would like to add a feature to a form so that after the user enters a client's address or perhaps phone number, the client's Time Zone would display. I assume a lookup could occur based on ZIP code or Area Code, but I couldn't find anything in Help or a Keyword search that seemed to address...

I have been working with Access for 2 years. I started with simple querys and macros and I now write most everything in code. I have very little programming training. I have designed 3 databases for my department in the last 6 months and they all work functionally. However, I know they could...

Each user in the database is assigned an area of the country and a section of the alphabet and work files that match those criteria. The main table, tblData, has fields for Name and Branch. I have a seperate table, tblBranch that lists the state that branch is in, and a table, tblStates...