I am trying to create a simple union query and I keep getting a syntax error in the from clause. This is my SQL statement:
SELECT CoName1, StatusID
FROM qryMeetingMembersNOTComing-crb
UNION SELECT CoName1, StatusID
FROM qryMeetingALLRegistrantMembers-NOreminders;
Can anyone tell me what I am...
I have a problem with good mail going in the junk mail folder. I had the same problem twice before and a technician determined that it was caused by a Microsoft junk mail update. He knew never to apply that update to my PC. My junk mail filter was working very well. Now a new techician...
When I type a hyphen in Word or Outlook, it changes to an equal sign and a hyphen (=-). Is this an autocorrect problem or is something else going on. I have checked the autocorrect list and there is no entry like that. Anyone have any suggestions?
I'm getting this error 50 percent of the time at least a variety of different pages (including my home page - Google), and when I hit refresh the page loads. This problem started occuring around the time we upgraded to Windows XP, brand new server and all. Lately, it seems to have gotten even...
I have a Word file that in the past I merged with data from a Microsoft Access parameter query. Since upgrading to XP, I have continuing problems with merging. When I try to select a new data source to start all over, my parameter query is not available in the list of queries from my Access...
I remember reading about this and doing it once but I can't think of what it was called. I want to combine certain fields from two queries into one to create a report. Or maybe it had to be tables. I remember that the field names had to match exactly. Can anyone give me a hint of how to do...
I have Symantec Mail Secury 5.0. When items are quarantined, the reason is "unscannable file rule." What does this mean? The message is deleted. There is no subject, and the recipient list looks like personal email.
What is the point of quarantining messages with the option to release the...
I did a stupid thing and disabled some services in Windows 2000 (trying to speed up startup). The services are Messenger, Remote Registry, Server. Now things aren't working correctly and I find I cannot un-disable them. I also cannot add/remove programs, dial up, copy/paste, etc. When I try...
I have a report that is based on a crosstab query. I want to have a text box that asks the user to enter a due date for returning the report, ex. ="Please return this form by " + [ender due date]
but I get the following error:
The Microsoft Jet databse engine does not recognize 'date' as a...
Can anyone tell me why Access database parameter queries are not available for merging into a Word document. Most the the tables are not available for merging either. We have recently upgraded to XP and the merge features are driving me crazy.
Even when I merged with a non-parameter query in...
I'm having a problem with a subform. The main form is a meeting registration form. To show a payment, a button on the form opens the subform to record payment. If there has not been a payment, the subform should show blank fields. However, on two PCs in our network the subform does not show...
How do you edit and save a high resolution PDF file and maintain the high resolution?
I want to replace one page in a PDF file that I have created for printing. Everytime I do this and try to save it the file size is reduced by more than half the size.
Does anyone have any suggestions?
We have recently upgraded Exchange to 2003. Is there any reason why after this upgrade a reply to one of my emails would not be deliverable?
In other words I send a message and the persons tries to reply but instead gets a nondelivery message. Instead he has to create a new email to send...
One of my users has a problem with messages she replies to but saves in the Draft folder for further editing. Each time she opens that draft reply for editing, another signature is added.
She is using Outlook 2003. I've tried using Detect and Repair, but that didn't help. Does anyone have...
My boss has a Windows XP Pro home computer connecting to a Windows XP Pro computer in the office. Is it possible to set the default printer in the office to the network printer in the office and the default for the home PC to the printer attached to the home PC? Or does she have to keep...
I just upgraded my Outlook 2000 to Outlook 2002. Now when I try to open certain emails, I get the runtime error "This application as requested the Runtime to terminate it in an unusual way..." Then I get the message "There is insufficient memory or disk space. Word cannot display the...
In certain windows, for example the Add Watermark window, I can't see, let alone use, the OK or cancel button. The window is too large and I cannot resize or move it up to reach the bottom of the window because it is too tall for the screen. Any suggestions?
My Access database is split with the backend on the server and frontend on user PCs. Recently, on closing the database, Access will not close. I've tried deleting the ldb file. That doesn't work. Tried rebooting. Tried repairing the database, and it tells me I can't do that because Admin is...
Can anyone tell me by looking at this code what is wrong with it? I know nothing about coding. I get this error when attempting to open this form to add a spouse to a registrants record from the form "frmMeetingRegistrantsInfo" or "frmMeetingExhibitorsInfo". Then the database freezes up and I...
I have Symantec AntiVirus Corporate Edition 8.0 and use Microsoft Exchange for our email server. We are being overwhelmed by virus notifications along with the original email. I have tried changing the settings on workstations and the server to delete the infected file but the emails still...
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.