I have a simple form (frmWFDSS) to enter data into a table (tblWFDSS_week). The form has a combo box called GrowerName and a text box called FarmNo. I want to have FarmNo lookup the GrowerNa...
Hi Experts,
I have a subform that contains children information which I want to allow for multiple entries of children of the parent which is tied to the main form by case number. When I t...
Is there a code in Access that after I check a box it turns the check box a color shade (after click) and where would I find the color codes as well? I remember doing this a few years ago wit...
I'm trying to set a form so that when it opens, it automatically displays the record that matches today's date (i have the table indexed so that there can only be one record per date...) i am ...
I am having a issue with a textbox in Access. I have read so much about using the NZ function to clear the #error I'm getting but I must be entering it incorrectly as I cannot get it to work. ...
Hi,
Mu query in SQL view:
SELECT faults.Description, Sum(Table1.Faults_QNT) AS [Sum Faults]
FROM ([All Data] INNER JOIN Table1 ON [All Data].MasterID = Table1.MasterID) INNER JOIN faults O...
This is a simple problem that I can not quite figure out. I have a form that shows records from three different Growing Areas. I would like to install a filter as a combo box with the three ...
Greetings,
I have a form that pulls the data from a table that is currently populated. The user has a combo box to pick a name. The name populates and so does all the other fields that ar...
Hi, I have a question which I'm hoping is a simple one. I created a large table with 20 fields. I wanted to make a nice form in which to enter/view my data. Rather than making one form with...
I have a database with only two tables. tblCards and tblPLCconfig, I have a created a form for tblCards with a combo box for the cardProName field which has its properties as follows,
Contro...
I have a subform showing a list of records and an associated number value (any # from 1-5). The goal is that the user can select a combo box (or another control) with #s 1-5 which would becom...
i need to open a microsoft office access 2003 form from a button created with vba code in microsoft word document
so basically click on button in word and it opens access and then displays ...
Hello experts,
I have a search form designed to search my database. What I want is a button to clear all contents entered in either one of the search text boxes or chosen from a combo list ...
Is it possible to trigger in event on a form from a created control.
Example
frmTest - on open creates textboxes txt1, txt2, txt3.....
how can I create an event for those textboxes if...
I have a form in which the user selects the client and date which is used in a filter to open the correct form. It has been working fine and then all of a sudden yesterday it started requesti...
FormA FormB
txtICN and cboKO >>>>OpenArgs>>>>>>>>>>txtICN and cboKO
...
I have a listbox in a Form -lbOrders which contains the list of orders in the database. The listbox displays only 10 fields from the database owing to the space limitation. I wish to have the ...
I have a combo box and one of the selection is other.
Is there a way to have a text box pop up so that they can enter additional text when other is selected?
Hello All:
I've been running into the following problem; I have a MainForm which has a Tab Control, in it, there is a SubForm which is based on a Query which in turn gets its data based on ...
Hello Experts,
I have two combo boxes on my form.
When I select an option on combo box 1, combo box 2 automatically provides the corresponding options.
Here's my problem.....
When I save a...
How do I open a form where the AppID = AppID
I hav a button on form Application Details and wnat to open the form Application where the two appID's equal eachother. I am a little rusty.
...
I'm launching a form from the AfterUpdate event of a combobox using "Access.DoCmd.OpenForm frmTest". The form that I'm launching contains a listbox that is successfully populated using a query...
I have a drop down box with five different listing, ex: CS, DW, HW, EEW, FMCS. When I click on one of these listing I want it to fill the box on on the form with the same name. I have 5 di...
Hi,
Just wondering... is it possible to have a text box in an Access form which accepts carriage returns?
eg... so can my Access text box look like this:
Thanks for any tips!!
The spell check shown in the attached screenshot and in the code pasted below, pops up on correct spelling of the word. How can I suppress this anxiety?
