I have a main form (frmMain) with the dimensions of
Height = 9990
Width = 13980
However, this form can be moved anywhere widhtin the Access container.
When I click a CommandButton, I w...
Hello Experts,
I am coding in VBA for MS Access. I have few message boxes that pops up in my application. However it seems the message boxes aren't that informative since they all look alik...
I created a Main form with tabs. I dragged a different existing form onto each tab. The tab turned black each time as I dragged the subform onto each one. Then, I chose the fields to link the ...
Hello Experts,
I am relatively new to Access 2003. I have created a continuous form that uses text boxes and combo boxes to filter data based on Model Type, Customer Name and Date. I have a...
I have a form that I have a text field on . When I type something in the text field and click on a command button to open up a report I want that field to pass to a field onthe report.
In t...
How do I modify the attached code snippet to set a field's format and input mask?
Hi,
I studied other member's questions that were similar but it's not happening for me.
I have a form (frmSlotRequest) that includes an option group (Slot Status) with three options (1-Appro...
I am working with IIF statements and value criteria:
CPI e .95 but d 1.10 = green CPI<.95 but > .90 or >1.10 but d 1.20 = yellow CPId.90 or > 1.20 = red
Here is my IIF statement f...
Hi, I am using Access 2003 and I am trying to complete a form that tracks employees expenses in our offices. The name of the form is called Expense . What I would like to do is when an offi...
I have a main form with a subform. They are not related / linked.
I want to add a record to the main form from the subform
Hello,
Is it possible to use '&' within a label's caption? If I wanted to display 'You & I', I currently get the output 'You _ I'.
How do I get the ampersand to show up?
I have 1 mainform with 1 subform datasheet view. The subform datasource will change based on the option selected on the Mainform. I would like to display a field that will equal total of Hou...
Hello Experts,
I created a textbox on a Form and typed in =Date(). I did this because I need to ensure that the date of data entry is captured. Yesterday, I created a Report, based on this F...
I have created a data collection form with the Access 2007 email wizard (InfoPath) but need to modify the form to include combo boxes. I want to send this form to users around the world who wi...
I have attached my sample database. I have a subform located on a tab of a main form. When the A# is updated, the data within the controls on the subform disappears until you advance to the ne...
I am totally baffled by a peculiarity in Access 2007 that I cannot figure out.
I have a form with a tab control. On one of the tabs I am dragging another form, thus creating a sub-form. H...
On my form the contents of cboProductTypeID are dependent on the contents of cboProductID.
If the user opens a set of records and tries to filter or sort by cboProductTypeID an error messag...
Hello,
I have a continuous form. Each record is a transaction. The customers name is recorded on each transaction. I would like to slightly modify code that I've used from Allen Browne's we...
I have a continuous form (DSAED) that displays high level info about donors, including donor id which is a key field. This continous form is populated by the results of a parameter query. ...
I would like to enter an extensive defaut value in the default values property containing VBcrlf.
like:
Header1: VBcrlf
A. text ...VBcrlf
B. text ...VBcrlf
Header2: VBcrlf...
I have a form I use to add a record (fEL_Add) . After I have completed entering the text for the new record I have a button I click (DONE) to close the add form and go back to my main form (f...
I understand that MS ACCESS is designed so that if one leaves a subform to main form under any action, that the subform will requery itself and place the cursor on the first field of the first...
Hi Experts,
I'm designing a MS Access 2007 Form and I'd I'm having some trouble. The controls all seem to be locked in position or something. Almost like icons on a desktop when Auto Arra...
I wrote this code for adding a new record. but at this point
rst!BankID = Me.TxtBankCode
it gos to err-label.
The Bank Id is primary key(smallint).
How could I pas this?
I set up a budget related database. The form for the RFAs seems to have a glitch that I have never had happen before in the other databases I have created. When you go into the form, you ent...
