Search results

Hello, I have the below macro i'm using to upload an excel file into a table in access. I want there to be a prompt before the upload happens to confirm the number of records that are being added... Also for the same code I want a way for there to be a prompt if the user tries to upload a...

Yeah that is what I did. I had all my fields indexed so I removed the indexes and created one index with the 3 columns. but it does not work. I'll try again.

Is there a way to create a query which would display only the first occurrence of duplicates entries based on a uniqueID, but would include a count of how many occurrences there are? I am using MS Access 2013. thanks,

Hmmm this does not really do the trick... it just keeps prompting me that I have duplicates..

I have an ID which is a regular AUTONUMBER, but I created a separate unique ID called "COMBO" in my table. You can see in the attachment the expression I used to create this unique ID per duplicate. The duplicates will share 3 fields in common, the expression combines these 3 fields. Note...

Is there a way to create a query which would display only the first occurrence of duplicates entries based on a uniqueID, but would include a count of how many occurrences there are? I am using MS Access 2013. thanks,

Hi Mark can I aggregate based on a unique ID?

Well the duplicates will interfere with the statistical reports that I will produce, they will also make it seem like there is more work to do than there actually is. I mean the user has to review each et of data only once and update the status as they go along, but because it reappears the next...

Hello, I've created a database where a user will upload a new excel datasheet daily. The user has to review the information and indicate within the record if they've dealt with the issue. once dealt with they change the status of the record. This datasheet comes from an external system. If...

WOW...how silly of me! thank you so much! have a great day

Hi Plog and Mark, I've tried that and I get a syntax error: Run-time error '3075': Syntax error in string in query expression "Status ='Review Pending' OR Status = 'In-progress". anything else?

Hi, I'm trying to run a very simple VBA linked to a form. What I need is for this VBA to open up a form with multiple criteria. I've found many forums with this information however, my filter is in the same column. Basically, my form is linked to a table where I have the column [Status]...