I have a form that uses one query. This query pulls information from 5 other queries. One of the five queries (called Tool Reqd subquery) has three fields - two are primary keys and the thir...
I have a form called Funders and sub-form called Sectors with associated tables and relationships. The sub-form consists of 1 field, a combo-box. I want to use a command to add a new record....
I have a number of forms with unbound text boxes. A form has 18 text boxes lined up horizontally. Not all of the text boxes will have a value (sometimes 2 will have a value, sometimes 6, somet...
On 09/30/2008 I asked for this question I have taken a access 2003 database and moved it into access 2007. By doing this my requery button on my form does not work. What I am trying to do i...
Here is the add/subtract issue in frmAddTasks and tblShowEachActivation revisited.
The latest update is attached. The goal is to make add/subtract time function using the controls in frmAd...
OVERALL PURPOSE OF DATABASE:
To keep track of time spent on tasks during the course of a single day.
CURRENT OUTLINE:
Tasks are entered via frmAdd Task
The tblShowEachActivation keeps tr...
Clicking the command button in frmDateRangeSelect used to pull the frmGroupAndTotal. The query field names in qryCalcActiveDuration have changed and the data in the query now reflects a more ...
I have 2 textboxes: tbDisc and tbResult. Each one's on_exit event causes the other textbox to be updated accordingly (the first textbox contains the discount percentage and the 2nd contains th...
Hello Experts,
I have a form that contains many command button. I want to track what has been updated "today" so that if the form is closed and reopened it will reflect what has already bee...
I am adding a combo box to a form and would like it to automatically add all of the table field definitions as the list rather than the actual table in the data. It's a large table and would ...
I have a form showing up to 20 rows of data (records). The user has to check all rows for correct data with a paper document, created by someone from another office. The sequence of the rows a...
I am creating and if then statement in an Access for to have something show on a form if something is selected.
If me.checkbox1 = 0 Then
If me.checkbox1=0 then
Me.lable1.visible = Fal...
Hi Expert,
I have a text field called Begin Date, I want validate text user entered to make sure it is date before form submit, for example it should be 10/1/2008. How i can do it?
Thank...
This may be a little much so forgive me if it is. I will try to ask questions in small pieces and if any progress is made at all, I will accept the solution and post a follow-up.
This is m...
I have a textbox containing dates. The field contains numbers but it is text type data format.. This prohibits me from using it for date calculations. I have been trying to import the data int...
How can I obtain a single vertical scroll bar for entire form (screenshot and database attached)?
I have a Yes/No data type that I would like to display as a Yes No option or toggle on a form. Right now it displays as a drop down, but I would rather have the check either yes or no, but no...
Hi,
I have two tables:
tbl_factsheets
tbl_documetns
tbl_factsheets has description a path to standard Factsheets whch can be emailed to customers
tbl_documetns contains documents spec...
Let me start by saying a have very little knowledge when it comes to Access, so I'll try my best to describe my problem.
I am creating a 'kiosk' type of application. Here's the senerio:
...
Hello,
I am having some trouble auto incrementing my invoice number. I have the following code written so it will go to one table grab the invoice number out of the table and then updat...
Hi
I have a form and a subform, in the form i have to field COST, and in the subform i have many records, so i would like to assign to COST the sum of all the records cost in the subform.
Pr...
I have a basic understanding of access and database's in geneal. We have simple table with 4 fields (File#, Invoice amnt, date invoiced and who billed the file). We have two other fields (da...
Hello Experts,
I might be trying to do this all wrong, but I thought it would be simple. I need to create an XML file from a table in a ACCESS 2003 database.
I can do it by Right Clicking...
hello experts! is there any way to set the back color of a command button on an access form?? I can only find fore color under format... thanks!!
Hi Experts,
I need to get data from a table and format it according to some specifications into an excel document. What is the best way to achieve this? Can it be done after the export int...
