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

    how to search data and display matches that include the user's input, but not necessarily match

    Hi, I have a form that I'd like users to be able to enter a partial word/string of letters and records that include the partial word/string of letters will display. For example, the search is to be done on a field called 'organization'. Needing a user to type in the exact way an organization...
  2. atadbitslow

    comparing fields, one populated with data and one blank

    Hi, I have two subforms on a form and I have VBA code that compares the fields on one subform to the other subform. If the fields don't match, I have a button for the user to click on to update the data in the field that doesn't match. It's basically: If...
  3. atadbitslow

    need help with syntax for a date

    Hi, I have this expression in a query. I can't figure out how to get the date the user will enter to work with the criteria. DLookUp("res_begin_start","zoom meetings tab","zoom_meeting_date=" & #[Please enter meeting date: mm/dd/yyyy]#) Thank you!
  4. atadbitslow

    Upgrade an Access 2010 database to Access 2013 or 2016?

    Hi, I will be upgrading our A2010 database, but I'm trying to decide whether to upgrade it to A2013 or A2016. I was hoping to get some feedback on any issues that others may have had with either of these versions. Any advice would be very much appreciated. Thank you!
  5. atadbitslow

    syntax help to be able to catch names with an apostrophe

    Hi, I have a form where a user can enter a name to search for and another form opens with the results of the search. The search does not work if a name that is being searched has an apostrophe, such as O'Leary and I know it's because I don't have the syntax correct in the code below, but I...
  6. atadbitslow

    creating a listserv from email field

    What is the best way to create a listserv using email addresses in an Access database? We often need to send email to large groups of people in our database. One of the problems is that our mail server only allows us to send out 50 emails at one time, unless we send them out under a group...
  7. atadbitslow

    type mismatch error

    Ques: I get a type mismatch error after the openrecordset command.....why? Private Sub addnewrecord() '(byval rst as Recordset, strinput as String) Dim db As Database Dim rs As Recordset Dim strinput As String Dim strmsg As String Dim varx As Variant Dim mymsg As String Dim dq As String Set db...
  8. atadbitslow

    Installing additional computer on wireless network

    We have a Dell Truemobile router and have successfully installed a PC laptop that has a Dell wireless adapter to the network. I am now trying to connect another PC laptop wirelessly. This laptop has a Spectrum24 LA2400 adapter (Symbol Technologies). When I use the Dell install CD to install...
  9. atadbitslow

    SPAM fighting products ??

    Does anyone have any suggestions for which product out there fights spam the best? Thanks!
  10. atadbitslow

    mail merge in an email?

    Is there anyway to merge data from an Access database into an email, such as names and dates? I couldn't find anything in Help-- We want to send emails to many individuals that would include their name and certain dates in the text of the email...... thanks--
  11. atadbitslow

    exporting email addresses to an Outlook group..??

    Is there a way to export email addresses from an Access database and create an Outlook group contact?? We have a need to send out large batches of legitimate emails using the email addresses from our database and the email addresses will vary each time. Currently, I have code that runs through...
  12. atadbitslow

    anyone know who sends this out??

    We receive this email after we have sent out multiple (legitimate) emails, and it is not from our mail server--does anyone know who it is from?? Hello user of [companyname].org e-mail server, Some of our clients complained about the spam (negative e-mail content) outgoing from your...
  13. atadbitslow

    envelope printing to specific printer

    I have an Access report that is setup to go to a specific printer under Page setup. I have set the orientation (landscape), and the margins set, and chosen envelope #10 under Page Setup also, and then saved the report. (For some reason, I have to change these settings on each system on the...
  14. atadbitslow

    rules not working on spam??

    I set up a rule to move emails that contain words such as "prescription, viagra, medication, viagr@" etc in the subject or body into a junk email folder, but it is not working.....the rule does work on legitimate emails from friends etc that may contain those words, but somehow the spammers got...
  15. atadbitslow

    summing up an extracted field

    I have an expression (#ofwks) in my report's controlsource query that extracts the last number from a text field (also in the query), ie text field is 3-5, the expression (#ofwks)= 5. I want to be able to sum up the expression field (#ofwks)which I've located on my report, but it keeps telling...
  16. atadbitslow

    Protecting an Excel file

    What is the best way to protect (or set as read-only) an Excel worksheet, so that only one particular user can make changes to it, and others can read it only? Thanks-
  17. atadbitslow

    avoiding the no current record error

    I get a "run-time Error 3021 No current record" when the code below is run......which just means it is at the end of the file---how do i get it to not error out? thanks- Function PS() Set db = CurrentDb Set rs1 = db.OpenRecordset("SELECT [collections thank you batch].ID...
  18. atadbitslow

    how to best to collect the data on a PDF form?

    I just downloaded the trial version of Adobe Acrobat Professional and am trying to learn it-- I successfully converted an existing Word file to a PDF file and also placed checkboxes and text fields on the file for the user to fill out. My question is, how is the PDF form best used to get the...
  19. atadbitslow

    asking recipient to answer ques in email

    What is the best way to have a recipient answer questions in an email that we will be sending to them--we would like our text in the original email to be uneditable, but give the recipient the ability to fill in answers to questions and they would then send it back to us....... Thanks!
  20. atadbitslow

    want blank fields when form is first opened

    I have a form that has a query for the recordsource. This form has a combo box that the user selects a person from and the fields on the form display that person's data. my question is--when the form is first opened, it displays the data for the first person in the recordsource--is there an...

Part and Inventory Search

Back
Top