We have this old Access app that REQUIRES the 2003 runtime and doesn't run correctly under 2007. The app can't be updated, either. So, we need to find a download of the 2003 runtime. Does a...
Hi All,
This should be an easy one, but I'm running out of time and need this asap. I need to download the Microsoft Access ODBC Driver so that I can set up a User DSN that my Java program...
I have a table tblCustomer where I have tags on a number of records, tag field is called select1.
I would like to select all select1=yes records and update a sub table called tblCustomerSub. ...
I created a small Access 2003 DB for use on my home domain. Recently two things changed. First, I added Access 2007 to one of the PCs on the network. Second, my Windows server 2003 domain c...
The templates on microsoft site seem to be rather limited. I seem to remember many more under Access??
Looking for one for a small hotel/restaurant which can be configured to suit their nee...
I have an access database. The primary key in one table A and is set to autonumber
and links to a field in another table set to number (foreign key). Relationship is one to many. When I ente...
I really could use some help on an approach to automate a Word Mail Merge that uses different documents/pages depending on the data. The data record can have the name of the specific word doc...
01C902AFFBB8E2A0
is a hex string representing file time, that is 100 nanosecond periods since 1 Jan 1601.
I have a conversion, but would like an indepent process of doing the conversion in V...
Hello Experts
This should be a quick one but not sure. I would like VBA code to export a Table in MS Access to a Tab Delimited with no qualifier text file.
We have a rather large MS Access 2007 database. We have created the table releationships using the MS Access 2007 database diagram tool. We need to print this Relationship Diagram but when we ...
Hi,
I need a value as a date type for it to work with a function, how can I convert a string to a date type?
I simply tried the following code but recieved the error "ByRef argument type...
Afternoon,
Can someone please tell me a simple way to export my table in the form of a text file? I use a similar method to export as an Excel file, bit can never get the text version to work...
Morning,
I was wandering if there was anyway to import an Excel XML file into Access using the same principles as below. I have read a few internet articles but nothing is really that clear. ...
I am running MS Access 2003 and Access 2007 side-by-side on the same computer (Windows Server 2003 Terminal Server). The applications do run successfully when working with databases but each t...
Hi there, i am facing a real problem, I created 2 tables.
MovieCategory(MovieCategoryID, CategoryName)
Movies(MovieID, MovieCategoryID, Title, ratings ...)
I have populated the MovieCat...
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...
Hi experts-
I'm building a small access program that cycles through an email list table and sends emails/attachments using the CDO Message object. A small sample of the code I wrote is below:...
Morning,
My database exports two text files to my desktop. Whenever I run my database I need for these files to be removed so that the new ones can be enetered in their place. Does anyone kno...
I have some VBA code that runs every day in Access and creates a few hundred reports. With all the variables it is possible that over 10,000 reports could be run in a day. What I'm trying to...
I will like to create a table listing the ft and inches on one column, list the converted fraction in the next column and finally list the conversion in decimal places in the last column as sh...
I need to convert a text in a field called "Bin" to upper case. I am using Access 20007 front-end and SQL 2005 backend. Example:
Table - Inventory, Bin=abc
After convertion:
Table - ...
I have a .mdb database created in microsoft access 2003.
In this database, I have created a main menu and some shortcut menus.
I've managed to hide the default database menu and toolbars an...
Hi Experts,
Thanks for your time and knowledge in advance.
I have a combo box "Variety" on a form "Variety Historical Evaluation". This combo box is being used to search for the value in...
Dear experts,
I'm having trouble setting report fields recordsource (in Access 2007 adp project) to an ADO recordset returned by SQL Server 2005 stored proc .
Access crashes when I tried t...
Hi:
I need to copy the table structure with the data in it, from database1 to database2.
Is it possible to do so.
Pleas
