Hello Experts,
I've created a form on Access.
One of the potential problems is that the user can move the mouse wheel and accidently scroll
into another Record. I don't what to completely ...
There is a subform on another subform that always starts up positioned incorrectly (too high). This has the side effect of hiding the tabs of the subform.
I can use my middle mouse button to ...
I am writting an Update string using a access form. The string is posting fine until i get to any string variable. Then i get: Syntax error (missing operator) in query expression "variable n...
The preceeding related solution referenced in blue at the bottom of this post contains a response that took some playing around with. I erroneously accepted the solution before thouroughly ch...
Afternoon Experts,
I am fairly new to VB access forms coding. I wanted to know if their is a feature in design mode enforces that a question is answered or an example of code that enforces...
I am trying to figure out how to make the field turn yellow when tabbed into, white when tabbed out. If there's an error I would like the field to turn yellow and focus set to it.
Is there a way to change the size of the option button on a form?
I have a continuous for with several DLookup Text Boxes (which are terribly slow). Since these aren't part of the underlying query, is it at all possible to derive a SUM in a footer. I've re...
Greetings:
Currently I have the submit button disabled on a form if the user when to a new record. This works, but the problem is that the user may need to go back to the record to add inf...
Hi Experts,
I have a form with two fields that are percentage fields and when I put in 50, the output is 5000.00%. I had the table number field properties set to single (field size), percen...
(I am re-submitting this question because I had a brief response to my question yesterday which did not help and I added two comments but have heard nothing in response to those. I don't know...
I've got a form that's rather crowded. Each text box needs to receive a lot of text. To conserve space, i'd like to have the textbox expand (height only) when it receives the focus, then go ...
I give up.
I've tried forever to figure this out, it just sounds too simple to be a problem.
I have an old Access document that includes among other things a Form called F_Tap and a Tab...
MS Access 2003 -
I have a sales order form. In the form footer, I have a complete button that runs several queries, but has two different If Then statements that fire off before they are al...
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 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 ...
In a form with a number of input fields there are 3 fields that are required every time.
I'm using this:
If IsNull (Me.Field1.Value + Me.Field2.Value + Me.Field3.Value) Then
MsgBox "Bla...
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...
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 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...
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...
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...
