Search results

This could just be me being blind as a bat, but how or can you create a button in a form to open a table? The only way i can open a table atm from a form is Via a Hyperlink! Pls Help!! :confused:

i was using it in the Footer of the document, but not u said that i have tried it in the mian body of the document and it works. Yet again something so simple! Doh!!! Cheers Peeps :D

I have a report full of dates that items have been issued to members of staff. I need a calulation that can tell me how many items have been issued. I have tried: =Count([EarPlugs]) and =Sum([EarPlugs]) but i just get #Error Any ideas on what to do!?:rolleyes:

I tried =count([SafetyBoots]) and when i run the report i get #Error!!! Any ideas?

I have a table which holds Dates (in date format) on when PPE was given out to employees (Ear Plugs, Boots, Goggles etc...) and i need to make a report that can be printed out showing the total number of items issued (e.g Ear plugs in 2002) Is there a formula that can add dates up and give a...

I am making a form and would like to know if u can make a button, not look like a button? As when it is depreesed it turns a lighter colour and when its just normal is blends into the background. I.e Like the control buttons in Access 2000

just had a quick look at those two samples. i think that i could use part of them to send the file, Cheers

I have created a Simple form, which when someone phones in to work sick there details are entered into a form and then Emailed to the wages department. The button i created mails ALL the records in the table and i only want it to mail the current record to the Wages Department. This is my code...