My database consists of multiple forms. I am wondering if it's possible to password protect one of the forms in my database (and not the whole database). How do I do this?
I have a form field in which I enter codes that are a combination of letters and numbers. The codes vary in length and sometimes don't include any letters. How can I use VBA to force the letters in the field to be capitalized, even though there are not always letters in that field?
How can I program Access to pop up an error message box upon LostFocus if an inappropriate value has been entered into certain field? For example, if [ApptType](my field) of [tbleAppointments](my form) = "IPD" then I want an error message to pop up with wording of my choice, but if...
When creating a query, how can I search for more than two values at a time? I am wanting to search for three different values in the same field in one query.
I work in a medical office and use Access to keep track of patient information. My main form is called Patient Info and containts two combo boxes, a name look-up and a chart-number look-up. This form contains detailed patient information. On this form I also have an "Appointment"...
I have two printers I frequently use at my work office. My default printer which is connected to my PC, and a network laser printer. Is there any way I can set up Access to always use the network printer when I print without changing my default printer?
Is it possible to have a combo box that pulls up information from a record, but instead of pulling up information for each field in the form, it leaves certain fields (which I have specified) blank?
I am unfamiliar with VBA but need a simple script for my Access form. If my field "C_Type" = "04," then I would like the text in my "Name" field to be striked through (if possible), or red in colour instead of black. Could someone tell me how to write this...
I have an AutoNumber field in one of my forms. I added a number of records to the form, which I later deleted because I wanted to start over. When I tried making a new record after deleting all previous records, the AutoNumber started at 5 instead of back at 1. Is there any way I can reset...
I work in an outpatient clinic and have an Access form in which I enter extensive patient information. All patients have a hospital chart # which is my primary key. Ideally I would like to have a button on my form which when pressed, would pull up a subform containing all of the appointments...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.