Unanswered: How do I check to see if a date, entered on a form, is already in the table
Hello and Thank you in advance.
I have a database that we use to pull data from an AIX machine everyday.
I can do it without making duplicates.
The users we have tried in the past, like to pull the same day 4 or 5 times.
That's the problem.
The data is sales data for cigarettes. Shows how many packs of each brand/type of cigarettes were purchased at each location for each day.
When you pull the same data 4 or 5 times that tends to through off the count.
The form has a date field called DateToPull.
I need to check to see if that date has already been pulled into the RAW table.
The date field in the RAW table is PSDate.
If the date is not in the table, then run the macros for pulling and processing the data.
If its not, then tell them to try again.
Generally each pull of data will create around 6-7k of records so there should always be something in there to check against.
I know what I want to do, but just have no clue on how to write it.
My coworker and I have spent to many hours searching and trying useless leads.
Now we need to get this done.
In a nutshell.
If [form1]![DateToPull] is not in [RAW]![PSDate] Then
do these access macros to pull and process the data
tell the user, the data has already been pulled for that day. try again.
It would be nice if it was that easy. lol
Then again if it was that easy the user(s) would never create dups.
Well... therein lies the problem...
I know what you are talking about but I have no clue on how to code it.
I've been busy with Monday and will take a look tomorrow and see what I can find on the forums.