Search results

Yes, I realize that. I just didn't know how to modify it for this instance. I appreciate the assistance.

Yes, thank you very much.

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 understand what you're saying and see how the way the database is set up is causing problems but not sure I can split up the tables like this since its not the only one. There are about four with one that is referenced by 7 other fields, six in one table and one in another. This second table...

I didn't feel they were exactly the same since I was trying to do something different so I started a new thread. Anyway, here's the example dB: http://www.fignations.com/_storage/riggsd_db.zip

It may, but I can't get it to work with my database. The example has the id and data in two different fields, not in a lookup field. I'll have to upload an example database later this evening to my personal site since its larger than the allowed attachment size and I can't upload to my site...

Yeah, I think you do. The show checkbox isn't used for it. In the lookup combo box, it looks up the value from another table. The second table has a ID number field and a data field. In the lookup combo box, both columns from the second column are there, but the first column is set to 0" so...

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

No, that doesn't make a difference. What I'm thinking I may have to do is run the query and append it to a blank table, then use VBA to go through the six columns, get each lookup id, go to the appropriate lookup table, find that id, then get the real data and put it in the table to replace the...

The table was built manually with the fields set to Memo and then the data imported in, however, the Memo fields data wasn't imported but added using copy/paste.

Thanks, I've tried it and posted a question.

I'm trying to get this to work for me and it creates the new table, but it is blank. The query works fine until I add the POC table that contains the linked information. See attached image to see the relationships I need. I've had to blank out some of the information on the image. Here is the...

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

I haven't been able to find a way around this same problem. I have several memo fields in Access and they are all truncated at 255 characters when I export to Excel. What I end up having to do is copy the columns from Access, paste into MS Word, select the table in Word, copy, and paste into...

I've done that, but it still strips out the leading zeroes. I've even tried making my own input mask with the same result.

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

Thanks Wayne, but wouldn't Me.FileName = "Total_List_of_PPLs_" + Format(Date, "mm-dd-yy") & "02-11-04.xls" put "02-11-04" at the end of the filename? That is the date that needs to change daily.

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

I don't have spaces in the operators, the forum software added those when I posted the message.

Is it possible that it is seeing the equal sign as a calculated control expression? From the Access help file: Note Calculated control expressions are always preceded by an equal sign (=).