Search results

I have a series of drill-down combo boxes on a form, to keep from having to list hundreds of employees at once: 1) Dept_combo, (shows available department names) 2) TL_combo, (looks up team leaders in the selected Dept) 3) EmpName_combo, (looks up employees for the selected Dept/TL) 4)...

to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables." I did a search and it looks like date prompts cause this error sometimes. The message pops up when running from the...

I did some searching and found this function posted by someone in response to the exact same problem I'm now encountering. But how do I call this in my query? Function StripZeros(pstr As String) As String Dim n As Integer n = 1 Do While Mid(pstr, n, 1) = "0" n = n + 1 Loop...

I query against a table with 380K records and growing. There are approx 14 fields in the table, but I only retrieve 7 in my query. Does having those extra fields in there slow the query down, or does the query ignore them? Just trying to figure out ways to improve speed. Thanks.

I have a database with a table that contains 360,000 rows. I built a form with four boxes where a user can specify values to limit the result set. And instead of having a new window open with the results, I built a subform and placed it on the main form to display the results. Here is how it...

I have a form with 4 different search fields used to query a table and limit results: Policy#, SSN, Credit_Amt, Debit_Amt. Any matching rows based on the search criteria are returned in a subform. My problem is how to handle any fields where the user doesn't specify a search value. In my...

Trying to use an append query to append records from Table1 into Table2. They are identical in structure...even went so far as to copy Table1 structure, and paste as Table2, just to make sure there were no discrepancies. I am unable to run the append query. I get an "Invalid Argument" error...

1) There are some databases here at work that I can open in BOTH A97 and A2K. I thought A2K won't open in A97, and before you can open an A97 in A2K, you have to convert? At least that's been my experience thus far. Any idea what is happening and how I can determine which version these...

We are upgrading our Access 97 databases in our company since we were told that Microsoft is, or will soon no longer, support A97. I've migrated a few of our simpler databases already. Everything went without a hitch and all functionality was retained. Word spread and now other depts are...

There are some web forms where people can submit work requests to my team. The data is fed into Excel in .csv format. Each request adds a new row to the spreadsheet. Nothing ever drops off. I am having problems getting that data into my "final" Access tables without repeating the data with...

I have an Access 2000 database that tracks employee performance review dates. The employee table houses the employee name, employee id, their Group Leader, and Team Leader. Another table houses their employee id and performance review dates. The report shows employees, grouped by a...

Is it possible to select 1 MAX date from multiple date fields for a record? For example, on an employee record there are 10 date fields, each for a performance review date. Some employees may have date fields 1-3 with values, some with just 1, others 1-5, etc.....depending on how many...

I just discovered TreeView Controls after browsing through this site today...in a word, awesome! I've done alot of searching, and it seems that most of the discussion on TreeView is at a data level. What I am wondering is if a TreeView can be used as a database navigational pane...ie...

I go to open my Access 2000 database this morning and the contents: tables, queries, forms, reports, macros...all gone! The database file is still there, and when I go to view it's properties, I verified that it is the database that I created back in April and not somebody that overwrote my...

My main form has four command buttons that when clicked will make visible one of four subforms. I can switch freely about the subforms by clicking on each of the buttons. However, when I place the cursor in a subform(and thus give it Focus), and then attempt to select another button to open...

I have a form that allows a user to select from a variety of options and then generate a report. It consists of three option groups: 1) Select a Team: A B C 2) Select a Report: A B C 3) Input a Date Range: From (blank) to (blank) If you progress down the list and finish entering...

Database Background: I have a database that stores customer survey response data in three tables by Line of Business. The data that is entered includes survey date, ratings type questions(ex: 1-5, yes/no), and additional comments for each question. All the data that can be entered for a...

Aside from creating a Popup Form with custom formatting, is it possible to format a MsgBox using VBA? We have set up a number of message boxes, however some of the text is pretty short and we would like to center it within the message box. Also, some of the message boxes look too big for the...

Not sure if this is a Tables or Forms problem, so please excuse me. I am creating a database where users will be entering Survey data. The Survey dates are in the format: Month-Year (February 2005, December 2004) etc.... I would like to capture the dates in that format, but retain the...

When I converted my database from 2000 to 97, the size of the database shrunk from 3.9MB to 1.5MB. This worries me in that something didn't come over to 97. I checked the functionality and everything is working like it should. Is this normal for a 2000 to 97 conversion?