Search results

I have added code on one of my forms to use a different query for the RowSource based on the value of another field. There are three different queries and I know the combo box is picking up the correct query because I can see the different data. However, all three queries are returning 217 rows...

I initially designed my report with a query as the Record Source. Later I realized I could use the same report with different queries (different subsets of the same data) so I removed the Record Source from the Properties window and added some VB code to set it. The "divider" at the top of...

I already posted this as a response to another thread, but thought I should post it as a new one in case people don't follow threads... I need to construct a SQL statement to insert a row. The VB code used to construct the insert statement is very long (the actual insert statement will be much...

We need to enter the string INCL as a data value in one of our tables. When we try to exit the field, Access keeps changing it to INCLUDE. This occurs whether the value is entered via a form or directly in the table. I assume it is doing some type of autocorrect based on th spelling. There...

I have a form with a list box that allows multiple (extended) selections. When processing the selections, I save the data to an intersection table (B) which relates the keys of tables A and C: A --> B <-- C Does anyone know how to retrieve the data for the list box when the form is loaded...

I created a database to assist in analyzing the contents of an Excel spreadsheet (provided by a third-party contract). The format of the data in the spreadsheet is denormalized to look something like the following: Parent1ID Parent1Name Child1ID Child1Name Parent1ID Parent1Name Child2ID...

I have Office 2000 Developer installed on my workstation at work and need to create an executable to deploy to other workstations that do not have MS Access. I'm using Access 2000 and the few that have the runtime installed already have Access 97 runtime. When I execute the Package and...

I'm VERY new at using VBA although I have been programming for many years. I have a requirement that involves creating a new version of a record and setting the expiry date of the current version to one day less than the effective date of the new version. Regardless of what I try, the new...