Recent content by jayz12

Hi Jim, Thanks for taking out the time to look at this. I ran the code in the debug window and it came up with this error message: Run-time error '62506': Data type mismatch in criteria expression What does this mean?

Would this have anthing to do with the field "code" being created in the query grid and not actually existing in a table. eg. The field Code in the query grid has been created...

my field name is code. I don't know why Tek-Tips converts it to that funny character.

Hi, I've created a spreadsheet that exports data to it from Access. If the spreadsheet is opened while trying to export, I'd like an error message to appear like "Please close [name of spreadsheet] before exporting data". Is there a code (when I click on a button)that will export...

I Don't know what happened overnight but now every time I export data to Excel I get Dr Watson appearing and the error message: An application erro has occurred... MSACCESS.exe An application error has Exception: access violation (0xc0000005), Address: 0x30188a36 Then the database shuts...

Hi, How do I find out what version of Jet Database Engine I am Running?

Just a correction to your post Ginger, If you want the number of days to be btwn 2 dates (not including the first day then substitute: DeltaDays = NumDays with DeltaDays = NumDays-1 For some reason MyDate = Format(StartDate, "Short Date") + 1 didn't work. Cheers, Jay

Ginger, Thanks a million for the code, it worked like a gem. And your detailed explanation was very easy to follow. I hope I can one day return the favor. Regards, Jay

Ginger My problem is how do I use this code in my form?. I'm creating a form where it displays the number of days in the field [NumofDays] btwn the date a record was entered [Dart1], to the current date Now(). But I want it to exclude weekends & Holidays. I created the table tblHolidays but...

I need to Calculate the number of days btwn the day an order was entered into the DDB[date1], to the day the report was run Now(). But I need it to exclude weekends. How do I display this number in my field[number] of a form?. I don't need to know the holidays. My apologies if this has been...

I know this may sound simple, but I've forgotten how to do this. I have a form which only displays the result of a query. No data entry is required here. So how do I remove the focus form all the records so I don't get a field highlighted in black when it is first opened?. Thanks in advanced, Jay

Hello the Experts, I've created a query that will pull up records btwn 2 dates. I then created a form[frm1] where I've inserted two unbound txt boxes, [date1] & [date2]. The query will refer to these fields eg.[forms]![frm1][date1] etc when i enter in the dates and hit a button, I want the...