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...
Hello,
I have a subform with a query recordsource that I am now trying to allow the user to select multiple choices from combo boxes. Currently, it filters on only one combo box and disable...
Hello,
How can one create a form with 6 tabs, each one with different information, but have the remaining tabs tied to the first tab by a user selection of one field that is populated on ev...
I feel really dumb about this but I had an issue solved for me that I now cannot duplicate. Someone had solved my problem of not being able to search form a form (frm_ComputerName4) in a field...
Working in Access 2003 .. I have a database that has a custom global menu bar that is displayed fine, available for any form that I open. But I also want a menu bar that will attach to a sing...
I'm teaching myself how to use recordsets
A form, frmRecordset has a single command button, cmdRecordset, and a text field, txtName
This form uses a table, tblProspect, as its Record Sourc...
I have a code I have used to filter multiple things in my database. I am now trying to filter a check box. My table is set up as a yes/no check box and my form I'm putting a check box.
Ba...
I have continues MS ACCESS form that displays multiple records with each unique ID from table PROJECTS. I have created a button that I call SELECT ALL, and I want to run a VBA code or SQL to p...
Rick_Rickards has stated that he needs to examine code in more detail to better determine what still needs to be cleaned up before attempting to gain scaleability for the form. I have made th...
Hello,
I cannot get hours and minutes to output from datediff("h",me.txt1,me.txt2)
I can output hours with "h" - minutes with "n"
But cannot get both- have tried dividing minutes -
I jus...
I have a table called productTbl with severel fields including an item# field, memo (descriptive) field and an updated (date ) field. Every day I import an updated productTbl from our website...
I am, once again, finding a hard time seeking a solution by using internet searches :) so i will be very happy if someone has the answer here!
I have a simple form in access 2003, the user ...
I own a recruitign business, and built a database to manage clients and candidates. I have a tabbed front end. We are a networked environment, and all users are at Access 2003 SP2.
I ha...
HOW DO I INSERT AN IMAGE IN FORM ON MICROSOFT ACCESS
Hello,
I have a subform that is filtered by combo boxes on the main form. This works fine. The subform is based on a query that returns a table.
I now am trying to reset the subform to o...
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...
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 created a database in Access 2007 to allow our group to collect information on what software resides on the Dev, Prod and Test servers. I would like to create a form to email to the differe...
I'm trying to close the database after so much time in idle due to the amount of users wanting on the database. Here is a code I pulled from the Microsoft office website but there are some ad...
Hi all.
I have an access2003 form, the end user enters a value in a text box, I want to be able to search a query or table to see if what the end user entered is in the query or table. If i...
According to the attached XPS document of my table report, Which form building method would best enable me to link child fieds (with multiple records) to my master field.
I'm driving a semi...
I have an application that was orginally designed in Access 2000 and have updated so that it runs under Access 2007 (.ACCDB). But, when I create the .ACCDE for production it doesn't run. The f...
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...
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...
Hello Experts,
I've been working really hard on my first Access database.
Everything looked really good, until a few minutes ago. I just realized that my
combo box selections are not be...
