Say I have a table like the one below in MS Access:
tblPay
Payer claim percent
tom 100 10
jerry 200 20
tim 230 5
I'd like to co...
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...
I have 2 databases; one called Employee1 and the other Employee2.
They both contain the same fields: FirstName, LastName, EmailAddress, and Center
The same record might exist in both databas...
I have a table that contains a customers details and 2 addresses (all in 1 table). The 1st address is a home address and the 2nd a business address.
I have a form based on this table. The ...
Hi,
The following is the case:
Table1: INVOICES
Table2: INVOICEDETAILS
INVOICES contains an autoinc-field "ID" and a integer-field "Invoiceno"
INVOICEDETAILS: only has a reference to IN...
Hi all,
Does anyone know how to take a spreadsheet from Access or Excel ie. (Customer#, Year, Type, Model, Price) and Import it into InDesign in a specific layout (probably using tags or si...
Hi Experts-- Lots of info on this subject but I can't seem to find an example that pertains to my situation. I have an Access 2003 application that uses a SQL Server 2005 DB backend. The Ac...
I am using Microsoft Access 2007 as a contacts database. I am using the collect data wizard to try and capture data into my database by emailing my clients an HTML form to fill in.
The form...
I'm looking at solutions to send HTML-formatted emails via MS Access.
I do not have Outlook reference but do have access to an SMTP server.
Is there a way of doing this? If so, could you...
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...
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 need to reset the AutoNumber Key in the table, please is there a way to do that???
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...
Hi folks,
I have a database on a shared drive and its been working fine up to now. Hopwever, one of its users has started having trouble with adding new data. "The database has been placed in...
I have an Excel template that I fill with data from Access queries using VBA. I have a form with buttons, and when a particular button is clicked, the corresponding function is called. All of ...
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...
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?
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,
I'm trying to import a very large (50 thousand+ rows, 65+ columns) Excel spreadsheet into Access. I keep getting the "Numeric Field Overflow" error. Every field in the table that i'm im...
I'm sure someone has the perfect answer for this. what is the trick to inserting text into a table via sql/vba that includes apostrophe's? (Or other characters that will break it for that matt...
I am running Windows 2000 and Access 2000. I have built a database that resides on a shared location on a novell server. For some users, the database runs as efficiently for them as it does ...
Hi all,
I have an Access form which is set to Continuous Form view and is driven by a query. The query outputs a number of text fields which are displayed on the form in addition to a nume...
In Access 2007, have do I reveal a hidden table or other object? It was easy ito do in earlier versions of Access but in 2007 I cannot find a way.
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...
I have MS Access as the front end with tables from an SQL database linked into the access file and these act as datasource for the various queries which are displayed on the click of buttons o...
