By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,336 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

VBA Help

P: 40
I have a database that a user will upload several excel sheets the database works except when i add new dates to the database.
When I created the code to import the Excel data, we added a column called ‘WeekImport’. I think this field might be able to be used as criteria in queries to only pull the data from a given import. The only tricky part would be to correlate the selected date range in the form with the proper recordset. I think it can be done, but I dont know the code to get the code right. There are built in functions in VBA to get the week number from a given date… it would then just be a matter of comparing the year and week number from the form with the WeekImport field in the table.
Jan 23 '19 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,055
Jeannier1975,

Exactly what is it that you are asking? It is very unclear what it is that you a retrying to do. If you could provide a few more details, and perhaps a few examples, that would be appreciated. Also, what have you tried so far? This may help us guide down a path toward a solution.

Thanks.
Jan 25 '19 #2

Post your reply

Sign in to post your reply or Sign up for a free account.