Search results

I have a list box with a query as its row source (screenshot attached). The query gets data from my Contracts table with information on a Consultant ID, Contract ID, and a Contract Status indicator. This effectively represents each contract with a specified status. What I'm trying to do is...

Is it possible to make a macro to automate this function? If so, how is this done??? I want to be able to have this function assigned to a button on my database. Thanks in advance for anyone's help/advice.

I want to make a button that will lead the user to another tab (which contains a subform). What is the code required for this? Thanks in advance!

Is it possible to password-protect a command button? In other words, is there a way to require a user to enter a password upon clicking a button, in order for that button to carry out its specified function? The obvious reason behind doing this would be to only allow only certain users to have...

I have a 'Services' subform that allows a user to enter payment information, but the amount entered is over a specified amount then a field's value in another data is supposed to change (in this case, the 'Contract Status' should change from its default 'Active' to 'Void'). I was able to get an...

I just wanted to know the VB code for changing the value of a field in one table from another. What I need to specifically do is implement code in an AfterUpdate to change the value of a field in another table if a certain threshold is exceeded (in this case, entering a dollar amount greater...

I have found an example of a search form that I really would like to replicate, but I'm have no idea how to implement it into my database. i have attached a stripped version of my database (only consists of a table) and the database with the search form i would like to implement. Basically, I...

need help setting combo box-based 'search form' - example attached Hi all: I currently have a database with a list of clients, and it is to be accessible to others to enter information on clients and to add new ones. However, I want to make it so that the user who wants to add a client can...

My database currently has a form with 2 subforms. The main form is the ConsultantList with a ConsultantID. This ConsultantID is carried over to a Contract subform when data is entered into the subform. This Contract subform also has a ContractID number that then carries over to a Services...

What is the best way to implement a search function into a switchboard? I need this search function to allow a user to check a database for specific names, so that they do not enter duplicates. Thanks in advance for all advice

I'm fairly new to Access (2000 is the version im using), and I'm not sure how to do several things within a form: 1) make cursor in a text box jump to the front (left) when clicked on 2) Lock (and grey out) a text box once data has been entered into another 3) assign a field to correspond with...