Search results

I need to compare two tables and find the records that don't match. The first table is from a query run on the Access database and saved to a table. The second table is from a report extracted from an Oracle database then imported into a table in the Access database. I tried the unmatched query...

I know that in a form, I can tell a field to fill in the data from the second column of a lookup combo box, using table_name.field_name(1), but how do I use this in a query? By default the query extracts the first column which is the lookup id but I need it to select the second column which...

I have several fields that lookup the field value from other tables and it works fine as long as I'm in Access. However, when I export the table/query to Excel, those fields come into Excel with the lookupID instead of the value. I've been getting around this by selecting the entire query...

How do I force a leading zero to be shown in a text field? What I have are three combo boxes where the user selects the date, which populates a field, but our format requires that there be a leading zero in front of any single digit month or day number. Access strips out the leading zero when...

I have some VBA code that extracts data from my Access database, opens a new Excel workbook, adds column headers, and then puts the extracted data into the spreadsheet. As part of this process, I use a counter to move from row to row. I need to use the row count to select a range of cells to...

First of all, thanks for your assistance on my previous postings. It is greatly appreciated. Second, I have some queries that I copied from my current database to my new database. I changed the names of the fields, tables, and forms, but not the logic, etc. in the queries. The problem is that...

I've looked at this so long that I can't figure out where the errors are. It's probably something simple though. Would you folks please take a look at this and tell me where I went wrong please? I took a SQL Query and am trying to convert it to use in VBA instead. stDocName =...

I know that on a form I can refer to a specific column of a multi-column combo/list box and then use that information in a query, but how do I refer to a specific column of a lookup field that's in a table and use that in a query? TIA