Hello Experts,
I am in the process of building my first Access dbase and I am struggling to get this form thing right.
I have a parent table linked to a child table creating a one to many ...
I am using access 2007 I have a form that pulls out records based on specified info. The form will be used to update the data in the table. I have 2 question. I want to know how the limit the ...
Hello Experts!!!
I have a Form, on the Form, I have a check box (ItemsReceived). When the box is checked, I want a Label & Text box to pop up (Label20, DateItemsReceived).
How do I set th...
There is a from control that is similar to the common dialog that allows selection of a folder and file.
I need to use this on an Access form to select a file for downloading.
What is the...
Hi, I'm trying to print a form I created in access so I can use it as a guide for a report and I don't really want to toggle between the form and report. Is there a way to print out a form ju...
I found that little QuestionMark What's This button. (only avialable when minimize/maximize is disabled...)
Does anyone have an example of how to use this along with the HelpContextID prop...
Hi All!
I have a code to find record from a query and display it in a form.
Me.Filter = "WorkOrderNo = '" & txtWON & "'"
Me.FilterOn = True
This code worked fine before I changed my ...
I have a form that contains several combo boxes used to filter a subform that has been based upon a query, which up until a few moments ago seemed to work fine, however it will now only work f...
This can't get much simpler, but I have tried all the variations of referring to a subform from a main, but nothing works. I keep getting the error message the database can't find the field '...
Hi,
I enclose a copy of my project please open frmPatientVisit I need to add List1, List2, List3, List4, List5, List6 and put the total in the LstTotal.
Thanks,
Hello
I have created a form from a table and would like to start my browser and go to a web page (ex: www.google.com) by clicking on a picture.
Everything works well when I insert the pictur...
Please see related question pointer below if needed. I have the following code for behavior that happens when clicking on an incomplete and inactive task.
I'd like to see the same behavior...
ok so I have a field on a form that is a calculated value, this calculation is called LOPARiskReductionScore. so no I created another textbox and in control source i put =[LOPARiskReductionSco...
I have a continuous form with a label on it that i would like to call a form using the ondlick. However, because it is a label and not a command button which ever button (label I click it open...
Afternoon,
Im doing some access VB programming and was wondering if anyone knows of a quick way to allow an text box only to be editable is the preceeding question was answered yes? Im ne...
I am working on a large project where we want a better way of browsing records than the standard record selectors used in VBA. What we want, is a combobox at the top of the form that lists all...
Hello,
if I input a textbox in time (short) format 08:00
another textbox in time (short) format 05:00
can I have another textbox that calculates the hours from it and displays 9
thank you
Hello Experts,
I am creating a brand new database and my very first form.
It is a very basic form with only 2 fields displaying. For some reason the I can not get the page header to disp...
This appears to be almost correct but there are still some anomalies that I have noticed in the behavior of the form. I will outline what IS working first. The original file as well as the ...
I am in a sub form. When a particular combo-box value is selected, I want to put a number in another text field in the form, for the current row.
However, when I do this in the _Change eve...
I have a function set up on my form to ensure all fields have been entered. If the field is left empty an error message pops up.
I have a field called email and another called reenterEma...
Hi everybody
This is my first question in expert exchange, and I hope that it will be answered quickly
In MS Access 2007, I have a form in table view which has a control with a source that l...
I have an Access tab control on a form. Each tab needs to be wired into a different table.
How do I approach this? I have the forms "Record Source" property set to the table for the fi...
I have two table country and state in Ms -Access 2003
country has CountryID and Country Primary Key CountryID
State has CountryID , StateID and State Primary Key StateID
in the Form I ma...
Hello Experts,
I have an Access dbase consisting of 2 forms.
Project and
Project Extended
The Project form has a cmdButton that opens the Project Extended form which pulls the ProjectID cr...
