Hi All,
I need your assistance. I have the following SQL that works in SQL Query Analyser but it is not working on MS Access on the SQL section.
I received the following error:
Undefi...
I do collection work for creditors in the UK who have clients in the US.
I have a database where the debtor has been invoiced in £GBP which I convert to $USD on the day of invoicing. When we...
I recently moved a PC at work to a new location, now it cannot print a certain page out of MS Access. It can print out of one database, but not another it prints a sheet with the header but no...
Access 2003 SP2 / MDE / Runtime / Windows XP SP2
Does anyone have a list of the various error numbers/messages you can get when using ADO objects and you push past the number of connections p...
Obviously, logical operators are different between Excel and Access. I'm only used to the former, and I'm tired of guessing about the latter. I need an answer ASAP.
I have a query that, f...
Hi:
I am trying use a query formula like:
Sales Stage: IIf([Sales Stage] like "6 - Sold*","Sold","Not Sold")
It returns an error saying it contains invalid syntax or I need to enclose my...
I heard that Access2007 uses a different extention than .mdb. If I install Office 2007 can I still write databases for clients that have 2000 or 2003 (i'm sure without any of the new features...
Some of our users have been working with Office 200 and were recently upgraded to Office 2003 via a Tivoli push.
One person tried to open an Access database that is regularly used and recei...
Hello.
I recently moved an order processing database from one server to another. This database is the source for linked tables in other databases. Everything works for several hours, but even...
Hello - I'm trying to Set a QueryDef variable to a particular Select query, that has 1 parameter, and then exporting that query to a text file, using an Export spec:
Dim dbs As Database...
Using innosetup5 can anyone help me with the scritpt for the following:
1. To check if MS Access 2000 Runtime, MS Access 2000, 2002 or 2003 are installed
2. To register / install the fol...
Do anyone know how i can identify relationship verbs or cardinality marks in my ERD?
Reference_Food_Category
PK food_category_code
Food_category_descritpion
Reference_Animal_Breeds
...
Hi Experts,
I want to do a mailshot from access using outlook. The email addresses are stored in a table "Clients" and the field is, surprisingly "email". This works nicely.
My proble...
I know this has been answered elsewhere but I'm paying to be here so I'll ask anyways =-)
I have a Select box (drop down) that I want to be used to search through records. I.E. Customer Ed...
Access 2003 Excel 2003
The following routine is exporting a table to excel
The name is a variable I'am passing
What I need:
When this sheet is open I need to check and see if a she...
I have two tables. One we'll call "Order" and one called "Accessories".
I created a List Box (that I want people to select multiple options from) in the form for "Order" that grabs the acc...
Is there a way when wanting to only print 1 page to preview the document before using the printout command?
I have a document that is 141 pages, I only want the end user to print the first pa...
---PROBLEM,,unable to store interger count for the number of entries in table..
**************************************
declare @CurrentDate Nvarchar(11), @MCEntryDate Nvarchar(11),
se...
I have a report with three subreports in it. Each subreport has the same format. There are vertical lines spearating some of the columns in each subreport. The subreports have no space between...
Hi All,
I have an AccessXP vba procedure which attaches a report to Groupwise
and sends it to recipients. That line of code looks like this
MailApplication.Recipients.Add strTo
this li...
Other than the obvious implications of mapped drives sometimes changing, would there be any reason to set up hyperlink objects within an ACCESS database that point to the UNC path location rat...
How do you set up fields in MS ACCESS for e-mails that can be connected to MS Outlook for a mass mailing? What is the field type? After the first and last names and e-mail addressess are ent...
I have two date fields in a MicroSoft Access table that contain Date Values. I want to compare the two fields to get the number of days between the two dates. i.e. - And order is placed on 01/...
Hi all.
I am working on an Access Report that I would like to have most of the data pull from SQL Server. I have 2 of the 3 parts, but I need help on the one of the parts.
This is what I...
rEALLY qUICK qUESTION - 500 POINTS by 10:15AM
I have the following code, i can see the form name when i put in break points and it is correct, i can run the sub with a hand coded value that...
