Search results

An additional symptom: I thought i'd try importing all of my reports into a new, clean database. I created one, went to import them via Get External Data, and only a small portion are showing. So a vast majority of the reports arent even showing on the menu to import objects.

I've got several reports that contain subreports. Yesterday while some coworkers were exporting my reports to PDF using Adobe Professional, something went amiss with a handful of reports/subreports. I've got 3 reports/subreports that at some point during their exporting, seem to have been...

You guys seriously are awesome! I'm able to be so much more beneficial and productive at work. Learning stuff on this site has actually inspired me to start classes to learn even more about VBA applications. Thanks!

You have taught me two important lessons: 1- Proper variable naming is conducive to smarter debugging. 2- I need to wear my glasses when writing code because i was dim'ing CurrentDate as Date and handling it like a string :) Thanks for the help and patience, guys!

getting a type mismatch on CurrentDate = Format(Now(), "MMDDYYYY") hover and it shows 12:00:00 AM

When i make your suggested change I get an overflow error for this line: CurrentDate = Format(CurrentDate, "MMDDYYYY") when i hover over it it shows "08032010". As far as sorting, that wont ever happen with this particular process. Each table is only one field and is used in some append...

rstFile_Date("LastRunDate").Value = CurrentDate that's the culprit line according to debug. Basically i use two dates to timestamp different things. The FILE DATE(last run date) which is the CurrentDate, and EFFECTIVE DATE. The effective date is always the last business day the process was...

I've got an issue with date formatting that I cannot resolve. i have the following codes: Dim CurrentDate As String Dim rstDaily_Date As Object Dim rstFile_Date As Object Dim dbDatabase As Object CurrentDate = Date CurrentDate = Format(CurrentDate, "MMDDYYYY") Set dbDatabase = CurrentDb Set...

Thanks! I'll give this a shot and get back to you! Edit: Worked like a charm, thanks a bunch!!

Hey guys! First time poster, many time reader. I've got a function (Daily_Archive) that I need to run only once a day. I've decided the base fit for me is to have a table (Test_Date) contain the date the function was last run. What I need it to do, to avoid duplicating data within the Db...