Search results

hey guys this is working now.

hey guyz. i've made a query which asks for "fullname" and then takes the user to a form with records of patients with that name. on that form is a button which should take the user to the particular record. however when the user clicks on the button it takes them to the form and the very first...

hey guys how do i create a new module to close the application from the "exit application button on the switchboard" and not the Microsoft Access Window!? Also how do i get an error message of "Are you sure you want to quit"? can someone please explain without using too much technical terms as...

aahh right! thanks!

i deleted the "Exit application" button so the user can now exit from the switchboard and it seems fine. thanks anyway.

when i press the exit application button the error message comes up as "compile error expected end sub"

When I exit my database i get this error message. What is causing this? Private Sub Command80_Click() On Error GoTo Err_Command80_Click DoCmd.Quit Exit_Command80_Click: Exit Sub Err_Command80_Click: MsgBox Err.Description Resume Exit_Command80_Click

okay firstly thank you for your post! secondly, i'm really new to this stuff and i don't understand half of what you have said. :$

I want to link a user manual guide from the access database. so when the user clicks a word document opens up. what is the best way of doing this? also are there some standard ways of making user manuals, for instance standard formats etc? any help is much appreciated.

now THAT is what i call COOL!

hey thanks for your reply Chris. I tried that peice of code, but i wasn't too sure exactly where to place it. i'm pretty new to this whole thing. i've attached the database. any further advice on where i can attach this piece of code would be highly appreciated. thanks.

hey boblarson, your absolutely right there. but i'm a bit confused as to solving this problem. can you offer any further guidance?

Thanks for your reply. What I'm trying to create is a query form with all the fields from every table (apart from a few IDs) i think want to use this query as a report so the user can print it out. Is this the correct way of going about doing things?

when i ad a patient record it multiplies several times causing multiple records and multiple entries in the report pages which increases to 90 pages! anyone know what is going on!? where am i going wrong!?

bumped.... i want to alternate colours, red for female patients and blue for male patients for each time their sex is determined. i'd like the whole forms background colour to change. what is the best way of doing this using Access 2003. thanks a lot guys.

Thanks, here it is. The form is called "Full Form".

the tabs have been created. the subforms are positioned in exactly the same position on each screen but it is very jumpy when i alternate each tab.

How do you scan a document e.g a photo or a word document which is unique to one patient for example and save this in the database? for example for each patient i want to scan in a hand filled document of their 7 day diary. this document is only unique to them and i want to save this in their...

Some very nice advice here. Thank you ever so much guys. I have opted for subforms.

trying to make a tabbed form, but it will only allow one tables content on the form. how can i get multiple table fields on the different tabs? e.g emplyee work details (table 1) is on one tab and employee home details (table 2) is on a second tab. any help would be appreciated. thanks.