I have a drop-down list in Access 2003 that pulls names from a table and I am trying to figure out how to make the names rotate each time one is selected. For example, iwhen the first name in ...
Hi Experts,
I have a form with several fields, some of the fields must have data entered, they absolutely cannot be left blank. I have a pop up box that tells the user they must enter the ...
I am in need of modifing VBA code that will update the criteria of query so when the report runs it pulls information based on the useres choices at that moment in time.
I modified a view t...
Hi
I would like to force the first character of a field on a form to upper case and then allow the rest to be optional. I know how to force to upper case and lower case, but I want to turn...
I have an Access 2003 form that has checkboxes on it.
I have a checkbox that selects all the checkboxes or deselects all the checkboxes
There is a combo box on the form that if I choose a...
Hello,
I have a problem which is driving me nuts.
I have a simple pupup form with a continuous subform on it.
I add records on the subform.
I also validate the details entered. i.e. in ...
Hello Experts,
I have a Project Form(based on a Project table) that with a button control on it that opens another form. The second form(let's call it ProjectExtended form) has a one to on...
I have a form with a TabControl that has several tabs on it.
When I change a value on Tab1, I want to change a contol value on a different tab, Tab2. I have to do this in VBA because there...
Hi,
I know this is simple, but when I open the mdb I want the form to automatically be displayed instead of having to double click on it in order to insert records into it. Please let me k...
I have a form with two combo boxes that pull information from two tables. All I am wanting to do is select an item in combo box 1 and select a value from combo box 2. Once selections are made,...
I noticed that if I put a filled in rectangle on a form and then put a textbox over the top of it, the textbox is the one on top.
However, if I put a textbox on the form and then a rectangl...
I have a form where I want to run some code whenever the mouse is clicked.
If they click on the form I want it to run or if they click on a control I want it to run. So long as the mouse i...
Hi,
I am Developing a New Database in Access 2003. I want to create a LOG for each user.
I want to know, when they last log in, what changes they made to what table or fieds, In general use...
I want the record deleted from the table tblJobIssues. The fields that need to match the table from the fields on the screen are Job# and IssueDefinitionID. (They have the same name on the tab...
I have trouble refering to the corresponding record's details in subform2 from a subform1. Both subforms are in an unbounded mainform. subform2 is in the Page1 of the Tab control page. Subfor...
I have a main form that has three columns that are used to display data in a subform. When I open up the form, the subform data is there and correct. If I make a change to one of the three c...
i have a database that allows the user to book tools in or out of the stores. To keep a check on the bookings and to ensure that a tool isnt booked out when it isnt available i need to check t...
I have an Access Database form that has a list of questions that are answered by a drop down box with a yes or no.
I want to count all the fields that say yes and the number of fields that sa...
I have a form with a series of basic option group selections and would like to be able to show the chosen option for each category in a report as the text value, rather than a number. Therefo...
I've reset a few tables in this app so new customer can enter their data. On some forms, where the data hasn't been established, when the form opens, nothing shows - all objects are invisible....
The field that is supposed to have a calculation in it only says #Name?
the calculation is as follows:
=IIf((1000*((10^-([tblPlan].[LOPA_TF]-[tblPlan].[LOPA_Gap_Before]-2))-(10^-([tblPlan].[...
I am not sure how to accomplish this but i have a drop down.
I want to prevent the user from being able to change the value if it is not null.
I do not want the sql update to occur.
I...
I have 2007 and can not figure out how to disable the feature of locking the fields. I dont know the name of what I am trying to describe and all I know is that I can not move fields around l...
I have a form that is built from a query. The form has a sub form. I have two values that appear for each record in the subform. Instead of asking the user to enter these two values into th...
I have a select box on a form that has an onchange even that gives me an error everytime i try to do it. when I choose something from the drop down list i get:
Compile error: Method or data m...
