Search results for query: *

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...

Thank you TheAceMan1. I found the tag and worked nicely. You guys are Awesome!!

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...

I am using access 2007

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...

THANK YOU SOO MUCH. IT WORKED!!

I tried and gave me syntax error On query2

Hi All, I need to pull the top six provider who has the highest number of apppointments from each depts in the following statement: SELECT Query2.Depts, Query2.[Full Name], Query2.CountOfAppointment FROM Query2;

For 1000/3, it could show as 333.33 333.33 333.34 or 333.00 333.00 334.00

This will be query result that I will e-mail. I may tranfer to excel sheet.

Hi Experts, I have data result that looks like the below: Date name Quantity Amount 03/2011 Smith 4 1000 03/2011 John 3 9000 03/2011 Bert 1 1500 I would like to be able to show the result, if the quantity is more than one...

Hi All, I have a big project that I am working on and I am stuck. I don't have any clue of what to do. Any suggestions would be greatly appreciated. We have 3 big departments merged together. Each department has list of providers used for services. We all share the same providers as needed. The...