We have a Access database that uses a wrapup process from SageKey to produce a Runtime version of the database. Over the last year, we have run into situations where the Spellcheck feature in...
experts, I have Access 2007 and need to have easy access to a form from the menu or some icon somewhere. How do I do this?
Thank you
I have a table showing the realtionship between rainfall and absolute bearings. I want to modify this into a table showing the relationship between average rainfall between a range of bearings...
I need the locations file of the "MSACCESS.exe" and Desktop Shortcuts in Access 2000, 2002, 2003 and 2007.
I have a form in which the user can enter Currency to be use to breakdown money into $100, $50, $20 etc. I would like to form an array of the notes and coins to be used and pass this array to ...
I would like to have a combo box on a form that would have a list of all of possible tables potentially used in a query. When the user picks the table for the list, a second combo box would ap...
Hi experts,
i'm creating an access 2007 program which I intend to distribute as a single user interface program to about 50 users (no network involved, other then import/export from a main ...
I am looking for the best way to track data changes. Basically I will have some users entering data into a form but on a weekly basis I have to QA the data. What I want to be able to do is cha...
Hello Experts,
I have an Access Databse that I have split and use a hyperlink on our sharepoint site that users use for the Front-end. If everyone is using the same frontend file, does that ...
I have 2 fields in a query.
firstname
contractexpirydate
how do I do a query where the contract expiry date is within one month of "now" - today
I developed an Access database, and I used the user level security wizard to set user name and password for users. The database mdb (intake.mdb) and workgroup mdw (secruity.mdw) file are in th...
I have created a searchable database catalog using MS Access 2002. I would like to put this on a CD, but my customers apparently will have to have MS Access in order to use it? Is there a so...
I want to be able to build an access file from a text file. This I did. the problem is I can't modify the access table. I'm getting a this property cannot be modified in linked tables....
h...
I am working to design an Access 2003 DB in which data is entered into an unbound form and then saved into two tables at the press of a button. When I attempt to press the button to runt he s...
I have a Risks & Issues d.b. with Access fe and be. It's on a Corporate LAN / WAN with about ~20 users who use the system lightly most of the time, then heavily when preparing for meetings, et...
Iam using access2003 and try to connect an .adp to MsSql2005 it connects but it would not accept editing the tables. It says that I shall look for servicepaks. Do you know about servicepack fo...
I like to make a DB in Access to help a frend truck driver with his IFTA forms.
I need a fill in form for my info about the trips this guy makes every week, like:
STATE STATE IN MIL...
Does Access 2007 support ADP's
i have to store some data in a database which could have about 300,000+ records per year.
will my queries execute slower as the database gets larger?
will it be better to create a new tabl...
I have an access database where I can store inventory type information about our office computers in on table and about out useres in another table. I can associate one user to many computers ...
I am building a database to house deal data for our team. The data currently exists in an Excel workbook. I have built the queries needed to fully import the data into the new database and t...
I want to make a form can relink the table when it startup, if the data source is change or can not find then pop up the open dialog to find the data source and reconnect the table! How to do...
Here's one for you geniouses - I have a drop down that is created with this code:
rowsource of combo box:
---------------------------------------
select [name] from msysobjects where type...
Hello Experts,
First, I'm trying to set up a table(s) that have biochemical reference ranges. Unfortunately, it's not as easy as lower and upper limits for a particular blood value. Most va...
Seems like it should work but I've tried it and it won't!
