Search results for query: *

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?

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...