Ok, I know this question has been posted before, but I need some help with this as the solution doesn't work on my problem.
Can anyone tell me what wrong with this code???
Private Sub cmdFil...
I need to combine frmDateSelect into the top of frmGroupAndTotal so that the only form is frmGroupAndTotal. I tried doing a copy and paste but the form did not update after pressing the butto...
I am running a simple select query (using two tables) and the query will not provide data results when I insert the following as criteria for the appointment date field [ApptDate]:
Betwee...
My question: Is there a way to exit MS Access 2007 from within a subform instead of a Main form?
We have an MS Access 2007 application which contains a main form and a subform. If a certain ...
I have a main form with 5 subforms.
It is a survey database
I have it set up so that depending on what type of service is being surveyed different questions come up which means the su...
I have an Access 2003 db. I have a main form and a subform. The subform does not have a link field to the main form. when I change a field in the main form there is a lsit box on the subform t...
Hello Experts,
There's (no doubt) an easy way to do this, but I can't seem to find the solution.
I have three text boxes on my Access Form.
Textbox#1 = My first textbox captures the num...
Question: In Access 2003/XP/2000/97, I'm trying to build an expression that will do the same as the following Excel formula with the result formatted as
=IF(TYPE(CODE(B11))=1,IF(F11=0,(E11-...
This is killing me! I have a form, the height of whose detail section I am trying to reduce. It is currently at 5.7 inches, I want to reduce to 5.25. In the detail section, there are 5 distinc...
Hi,
Using Access 2003. Have a combo box on a form looking up a PO# from a table and showing the matching info in a subform. The PO# will be listed in the table many times. The combo box i...
OK, this seems easy, but for the life of me I can't figure it out.
I have a number of controls on a form and a control on a form named "txtMyName"
I can set the value of this control by ...
Hi all.
I have message box that I want certain fields to appear in bold. These fields come from actual controls on my form.
When I apply the code below, it does not bold the 2 fields, bu...
I used the command button wizard to create a button that opens another form, filtering the data by "Project Name" but when I use the button, it shows all records in the form even though is say...
I have two forms, on a button click I want to open the second form and pass a field name. Enter data into the second form and use a button click to push that information back to the field nam...
In the footer section of a report i am showing statistics of the records, let's say the report is showing all the jobs done by technicians
Tech Account Field2 Field3........
Hi Experts,
I have come a long way with this program so far, but I am really stuck now. Here is the line of code that is throwing an error "method or data member not found"...
objroute.W...
How to get the value of access combo box from one form to another form?
I have a request from my user that I'm not sure how to accomodate
I have an access form that has some required fields. These are checked once the submit button is clicked and if the field ...
I "love" the toggle button in frmAddTasks that you see at the top of the form with the name "continuous". I have tried to rename it to "task detail" but can't always make it say that.
If...
I know this is a relatively easy question but it has been a while since I've done this
The attached access database has 1 table and 1 form
I thought I could use a listbox with hardcoded ...
I have a database called HEAZ
It currently holds 2 tables:
1.Customers:
ID
fName
lName
Org
Opt1a, Opt2a, Opt3a
Opt1b, Opt2b, Opt3b
Opt1c, Opt2c, Opt3c
Session1, Session2, Session3
...
I have a simple form with a List Box that displays about 300 names. I would like to be able to do a search/find on this list box to easily find keywords. Usually in Access you just the standar...
I have a simple bound form (Inventory or Vendor data) in an Access 2003 project (Server 2000 is backend). I'm trying to KISS and use all the built-in controls to manage records.
When I clic...
Hello:
I know how to write my access queries and create tables in access BUT I am TOTALLY new to using microsoft access forms. I normally use excel macros to do whatever I need to automate in...
I am building a form that will allow the end user to select specific selection criteria that will be used to run a query. The query results will ultimately be used in a report. How do I have e...
