Search results

A bit more information: If I type the value into the combo box, it finds the data that is not shown in the combo box drop-down list.

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 figured out how to make the change. Right-clicking on the group header bar and selecting "Sorting and Grouping" allowed me to modify the fields it was using to control grouping.

I am not talking about a field. The problem is with the "bar" that divides the sections of the report. The dividers and content on the report currently appear as follows: Report Header - some text and fields Page Header qDomainValuesAllLOBAuto.DomainID Header - text and fields for the...

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

Same problem with truncation I am experiencing the same problem. My VB code is: Dim InsertStatement As String InsertStatement = "INSERT INTO tCoverage (CompanyCd, ProvinceCd, " & _ "LOBCd, ProductID, CoverageCd, NBSStartDt, WIPVersion, " & _ "RWLStartDt, ScreenID...

I just figured out how to turn it off at the field level on the form. I simply have to set Allow AutoCorrect to No.

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

Peter, thanks for the code. It's a lot more sophisticated than what I ended up writing. I'll have to examine it carefully to see if I understand it. Here is the simple code I wrote which makes some assumptions about the format of the data, but seems to work very well: Dim currRow As...

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