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