I have a .dbf file that was exported from a third party program. I cannot import it into access 2007. It imports fine into access 2003. I can open excel 2007 and do a file open and select d...
How do i run a MS Access 2007 database on an Apple Mac to view or edit data?
After upgrading a users computer from Office2000 to Office2003 he is getting this error message popup.
Setup
Unable to exeucte file: c:\dde\ddenonprod.mdb
ShellExecuteEx failed; code 2
...
Hi,
I'm trying to create a form so that we will be able to select specific information from our tables when we want it. It seems like this should be really easy. I know of a simple way to q...
I'm helping a friend trying to debug this issue as he's posted all over the web, so I've come to the experts for some help... here's the question below:
I have a problem converting linked t...
How to write scripts such that the data from AS400 (IBM) can be extracted into text format or MS Access ? (related question)
I have the ODBC connection and initially i used to export from A...
Hi,
I am trying to create a formula or VB script for an Access database. I have a TIME IN and TIME Out difference field that is currently stored in a table. I would like to take this total...
I have a form which has a subform. The subform has a subform.
frm_Application - main form - AppID(Numeric)
frm_Module - subform - ModID(Numeric)
frm_Objects - sub-subform - ObjID(Numeric)...
I split my database, now i am testing in 2 computers, in the original computer everything is working perfect, i set the database to work in both computers, in the other, i got 1 error when i m...
I currently have an crosstab query containing several pcs of data. The Column heading is a date related to to some data being queried from outside Access (not relevant).
I am trying to wr...
I have a query in which I am trying to calculate a running total. The problem is, that I am trying to calculate the running total within a subset of data within the query. For example, my ta...
I have an Access 2007 database. I have a many to many relationship.
These are my 3 tables.
tbl_Clinic
tbl_Provider
tbl_ClinicProvider
The tbl_ClinicProvider has the primary key from tbl_...
I am running this Access DB from 2 machines. One is my dev box where I make changes the other is a little consol where the inventory comes in and needs to be scanned. I just upgraded from Offi...
Does anyone know of a way to automate sending messages from Access 2000 via Outlook EXPRESS, similar to the following in Outlook?:
Dim strRecipient As String
Dim strSubject As Stri...
How do I programmatically change the ODBC Timeout in my MS Access queries, specifically those querying via ODBC to the backend Database ?
When I installed an Access 2003 database on another computer, I had 2 broken references on the other computer. I can easily fix the references manually, but I need to do it at runtime because ...
I am tyring to use the Microsoft DataGrid Control on a MS Access 2002 or 2003 Database.
I have included the reference: Microsoft DataGrid Control 6.0 (SP5) (OLEDB)
In My form I placed a ...
I keep getting the message "Your Issues Tracking Database database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5.
Does anyone know how to fix this?...
Need to create line graph in MSAccess report.:
Want to Graph weight over time. Weights are daily
Sample data:
Joe: 111,112,113,115,111,112,113,114.....
Bill: 222,222,222,222,223,224,221,2...
Ever since upgrading to Access 2007, whenever users choose to "Compact and Repair" a database on a network share, the compacted version is saved as "database.mdb" in the same folder as the ori...
We have a memo field that serves as a scratchboard-type of notes field. Several command buttons allow users to enter common phrases to the memo field by just clicking on them.
Example:
Me.r...
I need some help dumping a recordset into a temporary table to be displayed in Access. Is this possible?
VBA code is used to perform a stored parameter query. The code is attached below.
Hi Everyone-
I am fairly new to developing with VBA and I am stuck on a problem. I have an Access database that current runs a screen scraping process to get data. The screens are being retir...
Hi,
I have two tables in MS Access 2003:
> tbl_project; and
> tbl_requirement.
tbl_project has fields "project_id" and "project_name"
tbl_requirement has fields "req_id", "project_i...
Alright Access experts!
There are a lot of "export to excel" posts on EE and the web in general. There are even a couple that were posted by myself over a year ago when I was trying to do s...
