I have a form with the following fields:
firstName
lastName
address1
leadcity
state
zip
email
reenterEmail
carsHousehold
driversHousehold
ownHome (drop down box, with a yes/no opt...
I am attaching a word document with screen shots of the errors that I am getting. I had created a form and put code into Visual Basic to change the form's .Visible property to True and False. ...
Greetings,
I have a client who is using a form I created that can't see the items in a drop down box. Normally when you select the item in the drop down box and event is triggered that fills...
Hello,
I have a form within my database, that has four sun forms. On one fo these subforms i have some fields and are not showing up on the form, however when looking at the subform in Desi...
Hello experts,
I have a form containing a subform which based on a temporary table (Temp Data Input1). When the form is opened, I need the Patient ID numbers (from Patient Demographics tab...
Hi Experts,
I want to make sure the user enters the correct data in a number field (they can enter any whole number between 1 and 100) and below is what I have. Getting a compile error. Th...
I have a primary key of Employee Number and Password and a form with two text boxes one for Employee Number and another for Password.
On an Access form I want to write some code that checks...
Hello,
I have a problem which is driving me nuts.
I have a simple pupup form with a continuous subform on it.
I add records on the subform.
I also validate the details entered. i.e. in ...
Hello Experts,
I have a Project Form(based on a Project table) that with a button control on it that opens another form. The second form(let's call it ProjectExtended form) has a one to on...
Hi,
I'd like to send access report by email.
I found in network code:
Private Sub Command128_Click()
DoCmd.SendObject _
acSendReport, _
"Letter", _
acFormatRTF, _
"tes...
I have a form with a TabControl that has several tabs on it.
When I change a value on Tab1, I want to change a contol value on a different tab, Tab2. I have to do this in VBA because there...
Hello,
I have an Access form with three checkboxes and multiple combo boxes. I am adding a reset button to 'clear' the form. All the code works fine until I attempt to set the value of the ...
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...
How can I autosave value in strFileName in a Pdffolder which is also in another folder named GrpReports
such as the file is stored in:
GrpReports\Pdffolder\strFileName
such that it look...
I have created 4 forms titled: Form1, Form2, Form3, Form4.
within the Form_Load Procedure of each form. I have placed the following line of code:
FormLoad.Stds_Form ("FormName")
This li...
I have the following fields defined in a table:
test date - date/time
Month - char - 50
Year - Number - Long Integer
Test date is entered by the users. After this field is updated, I want ...
Hi
I have a table which, for this purpose, is accesses via a form. The form has a combo box for the surname (cboSurname), which is used to search the table for a matching entry. I've atta...
Hello, I have been using something similar to this:
Function GetDateOut(dDate As Date, Span As Integer) As Date
Dim j As Integer, i As Integer, dtStart
dtStart = dDate
For j = 1 To Span
...
In my table, I have the following fields:
A# - can have multiple Treatment #s
Treatment Number - has 1 associated Hospital
Hospital - can have multiple Types of Treatment
I need to be ab...
Hello Experts,
I've done the following:
1. Created a textbox
2. Selected "properties" and went to the "All" tab.
3. Under the DEFAULT VALUE option, I wrote =Now()
When I go into form ...
I have some functionality that I've just added to my database with help from EE. I am displaying a picture that is referenced by a text box in a manner similar to the NW database. I have an ...
On a form in Access
I have a txtbox [DateOut]
right now I have it display result of ([DateIn]+[number])
Now I need it to not count weekends ( saturdays and sundays)
example DateIn: August ...
Hello - I have a four page form with each page on a tab control. When this form is opened, the tabs which show the page names are pushed off the screen. I have to use the vertical scroll bar...
I am attaching a test database, which is a small version of what I am wanting to do. Upon opening the Demographics form, I want the user to be able to click on the AHC report, which will promp...
Hi,
I have attached the document to this post. I converted it back to 2003 document. When you open it if you look at the ID field of the Form you see there are: ###(new)
I want it to eithe...
