I need some help asap, if possible...
I am working on creating queries to output data into excel files. The query provides multiple groups of data (all numbers). I need to be able to provid...
(1). I have this code below to hide the tables. I am looking for this type of code to hide the other objects like:
Forms, Queries, Macro and Modules.
(2). I will also appreciate code...
I have an Access 2003 Database in which I would like to run a query to change the default values for several columns within a table to NULL. Is it possible to write a query without VBA to do s...
I have a VB6 application that currently uses ODBC to connect to an ACCESS database which does not currently have a System DB associated with it.
A customer wants the option to choose either ...
Hello
below is my code and i get error as
1.) ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 6. on Update
2.) ERROR [07002] [Microsoft][ODBC Micros...
I have a Point of Sale Application that I made in Access. It works fine. Except for the printing. Here's my question....I have a number of printers, whenever a report is sent to a printer I...
Hi,
I'm not very familiar with SQL but I'm trying to update fields on multiple tables using a SQL statement in my VBA code. Basically I have 4 tables that all have a yes/no field called Del...
I have an Access 2003 database and I want all text to be entered to be in capital letters. I know I can put UCase in a query but is there some way that in the tables it just automatically goes...
I have an SQL database on SQL Server Enterprise Manager. I also have an access data base with ODBC links to the tables in the databasse.
On Friday, we moved it from one server to another se...
I have packaged my progamme with Microsoft Office Access Developers Extensions. When opened by the user a message appears that the "project contains missing or broken reference to the file mso...
Hello everyone. I am hoping that someone has a simple answer to this problem. I have an Access 2002 front end to an Oracle database. The tables are linked into Access and we use ODBC to co...
hello i am having a problem with one machine on my server 2003 domain. the user is having trouble opening their copy of the access xp "2002" database they have read only permissions to the da...
In the Sub below I am trying to add the value from a text box into a table. I am inserting a new record. However, when I execute it the value of the variable is not added to the table, instead...
Hi
I have the following formula in excel:
=IF(AND(Reported Surplus=0,Reported Decifit=0),"Surplus",IF(AND(Reported Surplus>0,Reported Decifit<0),"Deficit",IF(AND(Reported Surplus>0,Reporte...
IS THERE ANY WAY WE CONVERT MDE INTO MDB. I LOST MY MDB APPLICATION. I HAVE ONLY MDE . IS THERE ANY WAY I CONVERT INTO MDB WITH ALL SCREENS AND REPORTS .
Hi,
We have an Access 2000 Db residing on WinXP running as a server and part of a Win2000 Server domain. We are getting the above intermittant error in Access. It seems to occur for ...
I am having difficulty while trying to link tables from Oracle database. The error I'm getting is "ODBC -- call failed... Restricted data type attribute violation. Any idea?
I would like to trap the ODBC connection error so I can display a meaningful messege to the user pointing them to the documention on how to establish a DSN.
My first thought was to trap the...
I am trying to run a pass-through query in access with a variable that a user enters in a form. I can't seem to get this to work. Can somebody please help? The variable should be where the 121...
I get an error -2147217900 (80040e14) run-time error. The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relat...
Hi Experts,
I am completely ignorant of Pivot Tables & Charts but, from what I've read, I think they may possible meet my requirements but I need some help putting it all together.
The app...
I'm getting this message when I try to open the DB, it is access 2000 the database is a little big.
Can anyone please help me there is very important data in it, but keep in mind I'm not mu...
I can't seem to find the maximum recommended size for an Access database or an Access table. The database I'm building now will have a few smallish table, and one table with a million records...
I need to end up with a csv file that can be used for import and export from one program into another.
I have an access database that reads the data from one program via odbc, massages it a...
I have a Microsoft Access program that I run each quarter. It ran in June just fine and now it gets the above referenced message. I have confirmed that the Jet*.tmp file has reached the 2,092,...
