Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Eddyoftheyear

    Unbound form

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

    Query

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

    form data entry

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

    form data entry

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

    form data entry

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

    Hyperlink

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

    Attaching a file to email

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

    Attaching a file to email

    I am using access 2007
  9. Eddyoftheyear

    Attaching a file to email

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

    MsgBox confirming status

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

    Email notification based on date

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

    Lookup date value

    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>=...
  13. Eddyoftheyear

    Lookup date value

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

    Top counts

    THANK YOU SOO MUCH. IT WORKED!!
  15. Eddyoftheyear

    Top counts

    I tried and gave me syntax error On query2
  16. Eddyoftheyear

    Top counts

    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;
  17. Eddyoftheyear

    Numbers in columns

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

    Numbers in columns

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

    Numbers in columns

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

    3 sets of Data

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

Part and Inventory Search

Back
Top