Search results

I've never created a form where query criteria can be entered. I want to be able to sort records by 7 different fields. Fields are analyst, system, issue, department, user, start date, and end date. I'd like to have a form where the user can enter criteria for any combination of fields: ie...

I have a combo box that gets its values from a query. The query only shows those records whose yes/no field[ClosedIssue] value is equal to no. This works, but where the description should show up in the combo box, I get the ID number associated with that description from its original...

I have a report that has a few fields that are set by combo box selections(choices are from other tables) in my main form. When I open the report, I get the ID associated with the names. Now, I know that I need to have the number stored in the main table, and not the name...but how can I set...

I have a combo box in a form, along with 3 bound text boxes. When the form opens, it opens to a new record so that the form open without any data in the fields. When it opens, I'd like to disable the 3 text fields until a selection is made in the combo box. I think the code should look...

I have a combo box in my main form that gets its list of physician names from tblPhysician. When the physician is chosen and the record saved, it saves the PhysicianID to my main table, tblOncReg. When I delete a physician, any record that had that name chosen continues to have that name in...

I've got a form that contains a combo box. When a selection is made from the combo box, the rest of the fields automatically populate with the data associated with the selection. This works fine, but when the form first opens, there are values already in the text fields before I make a...

I have a button, that when clicked, should go through every record in a table(tblEmployee), and set [PassChange] to Yes(-1). I'm not sure how to specify to run through till it reaches the end of the file, but I think the rest should look something like this: Dim RecIndex As Integer RecIndex...

If I have an unbound text box and a checkbox in the same form, what code can I apply to the text box so that as soon as a character is entered, the checkbox is disabled? On what action would I apply this code?

Hey guys Instead of typing it over again, you can view my issue in this thread I posted in the "Forms" room: http://www.access-programmers.co.uk/forums/showthread.php?t=125180 Is there a way to use VBA code to open Access with ONLY the default form and NOTHING else? I'm talking no toolbars...

So with the help of many of you on this site, I was able to build my first Access database. Thank you all. Now that I'm all done, I have one final thing to figure out. I have incorporated user authentication into the database for a minimal level of security. Everything finally works like it...

I have an unbound textbox in a form that accepts a password. When submitted, I want length of the password to be evaluated. If the number of characters is equal to 8, then the process should proceed. If it's less or more than 8, then a message box will pop up saying the length is incorrect...

What should I set the input mask to if I want to create an unbound text box to only accept exactly 8 alphanumeric characters.?

I have a table that has a field, [Pchange], with a "Yes/No" value. If this field is "Yes", then when a user tries to log into the DB, they are prompted to change their password. If it's "No", then the main form opens. What is the VBA syntax to reference this field? The first "If" statement...

I have a table, tblEmp, which holds fields [USERNAME], and [PASSWORD]. I also have a form, frmAuthenticate, with 2 unbound text boxes...one for the username and one for password. What I want to happen is that when I input a username and associated password, the name entered will be matched up...

As I'm sure many of you know, Access '07 no longer supports user level security. My question to you all is, how do you secure your DB's in '07? I just built a DB that stores patient data, and it needs to have some type of user authentication to gain access to it. I know I can assign a general...

I have a table in my DB, tblWeightUpdate, which stores patient weight history. When a patient comes in for a treatment, their current weight[Weight] is taken and input through my main form along with the date[CurrDate] it was taken. These entries are linked to patients in my main table...

I have a form called frmListing. In this form I have 2 buttons: View and Delete. There's also a subform that shows all records from my main table[tblOncReg] and displays only the 4 most important identifying fields. When I click a record in the subform(table), I want to then be able to click...

What setting controls whether a form is always on top of other windows that are open? When I click to view a report from a form I created, the report opens in the background and I have to close or minimize the form to view the report. I don't always want it on top.

I have a form[OncRegMain] that contains a subform[WeightDate]. The subform enters a weight[Weight] and date[DateTaken] to track patient weight gain/loss. The way I have it is that when the main form[OncRegMain] is opened to view a patient, the Weight and Date fields in the subform are...

I have 2 questions. The first is regarding splitting a database into 2 files, one for tables, and one for forms and queries. I have a database whose data will be accessed from about 4 computers, and almost never will this data be accessed concurrently. In that kind of situation, is it easier...