Search results

Thanks EMP. Your comment made me realise it was indeed the relationship issue that caused my problem and why. Instead of getting the target table MsdnID data from the temporary source file, I tried getting it from another permanent table that has the MsdnID field as it's primary key. Just so...

I've read other threads in this forum to do with key violations, but none of them help me with my particular problem. I import data from a text file into a temporary table in my Access database. I use a temporary table because the number of columns and titles in my text file do not match the...

Thanks pbaldy. That worked a treat. I've never done a query on a query, so that's a handy thing to know to do. I suspect I'll be using it a lot as Access is slightly retarded. Thanks

I have a query with some fields that are directly from tables and other fields that are calculated fields (no big deal here). Some of the calculated fields refer to table fields in their formulae and other calculated fields refer to calculated fields in their formulae (still no big whoop)...

Wow - 2 ideas This is great. Two ideas to try out. Thanks geralf and WayneRyan. I'll try both ideas and see which one fits in with the flow best. I was actually expecting someone to say "Nope - impossible", so having two ideas to play with is amazing. Access sucks.

resetting to null I have a form where the user sees the current value in a group of fields and they are allowed to change one or all of the values. There are two columns of data, one column has a locked set of fields (for reference purposes) showing the current value. The second column also...

simulate a click event In my Access application, I have a form that displays a list of records by an ID number. The "On Click" property points to a macro that runs when the user clicks on one of the record IDs. However, there are times when I want to automatically do the "click" so the user...