I have an unbound form with multiple tabs that contain listboxes. in the top of the unbound form, I have a combobox with clientID and name, once you select clientID, it filters all the list boxes to the data associated with the clientID. I want to add a tab with a field from the client_tbl. This...
Hi,
I have a query result that I would like to add a value in a new column in the query result. Example of the query result is
Name DOB Dept Division
But I want to add another field which is not in the table showing the word Domestic in each records without inserting it in the table. Is...
I am fine TheAceman1
Sorry for the silly question but when you say but ? in the tag property control, are you reffering to the smart tag in the data dab in design view...
I have a form that has about 30 fields. I want to make sure that 5 fields to be mandatory to enter information in.
Name, firstname,lastname,dob,badgeID, and deptID
Some are text fields and some are comboboxes.
the form name is Staff_frm
the form is bound to the tabel. I don't want to set the...
Hi All,
in the codes below, I would like to hyperlink the line from http: all the way to the end of the link. when I click send, it goes without this line being hyperlinked.
I am using this in send object.
Any suggestions.
Thanks
Mymessage = Mymessage & "1. Go to " & vbCrLf...
I hope I did not cause confusion. I am able to do this by writing the actual e-mail in the code in the following statement, but the problem the email is moe than 255 char. it is about 15 lines.so I thought it will be easier to attach the file with the message needed to be snet.
If intResponse...
Hi All,
I need help with attaching a file automatically to the email when using the send object. The document will be word or pdf.
Is there a way to automatically the file to be attached from a specific location? I am saving the file in H:/Admin/Welcome.Doc
If intResponse = vbYes Then...
Hi Tek Experts,
I am running a apend queries and wanted to add mesage box confirming the operation when the records are apended.
the following codes I used to apend the records:
DoCmd.Hourglass True
Turns off the Access warning messages
DoCmd.SetWarnings False...
Hi Experts,
I was wondering if it was possible to automaticly email a report to individuals based on ticket date?
each record will have one individual to send the report to. each report will have ticket date and e-mail address.
I have a query result in a report with e-mail address field and...
What I did is that I brought the field to the form and used the following codes. It works nicly but if the testdate field is blank, the msgbox should appear.
Dim oShell As Object
Dim iResponse As Integer
Set oShell = CreateObject("Wscript.Shell")
If Me.testdate= "" Then
If Me.servicedate>=...
I have a staff_table with field name testdate. Each staff must take this one test yearly to use him/her in any activity.
I have Activity_tbl that contain staffID, what I want is that if we select the staffID from combobox in the activity_tbl,then we enter the services date, a Dlookup looks the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.