Search results

Hi, I have created a database for a client that is maximised and has all menus hidden etc. I want to create a button that launches the Back up Database Office Icon > Manage > Back up Database Anyone have any idea how I could code a button on a form to launch that? Thanks

Fantastic Bob, thanks a lot, I would have never been able to figure that out :)

Hi, I have a database and due to data protection reasons I need to clear the contents of a table when the database is closed down, is there a way of doing this? I have tried using me.undo in the form events etc to stop the data actually writting to the table however this causes problems so I...

Ooops apologies SOS. You even put it in capitals for me. I blame a long day :)

Thats the problem I was putting it in the on click event code. Thanks a lot :)

I can't sorry due to the sensitivity of some of the data

Can you not simply run a function? Do I have to declare it or something? In code I have seen they always seem to dim sone variables and use an IF statement before running a function.

The function is in a standard module named Module1

Private Sub Command233_Click() =PrintDoc() End Function asks me for a macro name

Hi, I am trying to call the following function in a code module from a command button on a form: Function PrintDoc() Dim WordObj As Object Set WordObj = CreateObject("Word.Application") WordObj.Documents.Open "C:\Project v0.1\PrintForm.docx" WordObj.PrintOut Background:=False...

Very true SOS, should have mentioned that. So in summary: Change the name of your textbox with the total hours worked for the day so it is not the same name as the control. I.e. change HoursWorked to txtHoursWorked as mentioned. Add a textbox and change the controlsource to...

You will need to put a Sum textbox in the report footer with the controlsource =([HoursWorked]) [HoursWorked] being the control name where your total hours for the day/shift are stored.

Hi vbaInet I am basically digitizing an application form. There are various reasons for doing this, however the resulting printed forms need to look exactly the same as the original paper based forms. There are 5 pages of A4 and with the limitation I cannot simply embed an image on the report...

No ideas anyone? If not, is there a way I can run 3 reports but get it to look as though I am only printing 1? i.e. only ask which printer to print to once?

Be sure to format the textbox as short time or it will show a strange working out of the subtraction.

I remember having problems with this in Excel. Will subtracting the times not work? I.e. Control Source of the textbox =[Start Time]-[End Time]

Hi all, As you may or may not know Access has a page height limitation of 55.87cm. My report needs to be printed onto 4, possibly 5 pages with a different background image (pages of an application form). Without me having to split these reports up and having to fire 2-3 reports to print an...

Sorry, found the answer I was looking for: http://www.dbforums.com/microsoft-access/1626624-link-between-textbox-combo-box.html

Hi, I have a simple database which has a combobox with the following query: SELECT PUPILS.[Pupil Name], PUPILS.Form FROM PUPILS; It's a simple query which has 2 fields. I need the user to be able to select a pupil from the combobox and display their form in a textbox. I have tried several...

Hi, I have a simple database which has a combobox with the following query: SELECT PUPILS.[Pupil Name], PUPILS.Form FROM PUPILS; It's a simple query which has 2 fields. I need the user to be able to select a pupil from the combobox and display their form in a textbox. I have tried several...