Search results

I am using a subform but i cannot get it to open only when the tick box is ticked, if i show it all the time it shows no records, I think i have donw something wrong when setting up the subform and its association to a table that is not the main datatable. Hope this makes sense

I currently have a form with a tick box on it, what i am trying to do is when the box is ticked, open up a list of a dozen or so supplimentry questions, some of which will require a box to be ticked and some of them will require a name to be entered. I have a seperate table available to store...

Would love to say there was a line Msgbox but there isnt ????

I currently run a macro which deletes a temp table using the delete object command. Users are then presented with a warning box that says "You are about to modify data etc" which I dont want them to see I just want the macro to run and make any modifications automatically. I have looked in the...

I am currently creating a daily Excel file with information for a 24 hr period. I am using the on click data txt_date1.Value = Date - 1 & " 06:00:00" txt_date2.Value = Date & " 06:00:00" which populates 2 hidden boxes, the system uses this info to pull the records from the main database. If i...

Thanks for the help im using the transfere spreadsheet option now which i store and then send out manually.

Im currently using sendobject, which as i say works but sends it in excel 95 which is no good

Great This copies my table to my C drive , but how do I automatically send(email) the object(table) in Excel 97 or higher format Thanks

Great This copies my table to my C drive , but how do I automatically send(email) the object(table) in Excel 97 or higher format Thanks

Great This copies my table to my C drive , but how do I automatically send(email) the object(table) in Excel 97 or higher format Thanks

The code i use (below) is linked to a button on my front page, what happens at the moment is the user is given a check to see if they really want to send a report. If they answer yes, it compiles an E-Mail and sends it automatically. As i said it sends it in excel 95 which is unreadable by...

Im stuck on a project that I have received help on before. I am trying to E-Mail a daily report created by a macro in Access 2000. It needs to go out as an excel spreadsheet, but in a format that can be opened in a Blackberry. The advise i was given was to use Transferdatabase. This is where i...

How then do i export it in an e mail automatically, as I said its probably very simple but then so am I.

Sorry forgot to say im using Access 2000. The report is sent via a macro in EXL format

I have recently created a database which exports a daily report in Excel. The problem I am having is that the reports are sent out in Excel 95 which cannot be opened by Blackberry. We used to create this report from an excel database and send it out but it went out in excel 97 format which was...