This question is sort of general with perhaps many different answers, but Im having difficulty coming up with one good one. How to incorporate pre-defined sections into DB tables, to organ...
I'm starting our company's database over again from scratch and want to institute best practices this time around.
I have a two part question:
1) Is it feasible or recommended to have o...
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 have a Access db created in Professional 2000. Can it be run in the non pro Access?
I think the answer is no, but is there a way to see how much of the total database size a particular table accounts for?
I have a database with a couple of large tables and I want to see if o...
I want to set the pagesettings of a report in MS Access 2000. I found out how to change the printer with code in MS Access 2000, but now I need to change the pagesettings as well.
I am working with a group that is having issues changing reports in a Microsoft Access database. The designer of the database recently moved out of state to pursue his PHD, so he is not availa...
I get an error when I try to open a report which is based on a crosstab query. The error is due a missing field the crosstab after it is run on a certian set of data. The report has fixed fi...
I build the sugguested tables. Does the relates fields automatically fill themselves?
I have linked tables in MS Access linking to SQL server tables. Normally I can just open the tables without the password, but lately some of the tables are requiring a password. Since some o...
I have this query in my access database
SELECT Invoices.InvoiceID AS Invoices_InvoiceID, Invoices.DateStamp, Invoices.Total, TaxInvoice.InvoiceID AS TaxInvoice_InvoiceID, TaxInvoice.TaxID, ...
I have an access query that output long text and html into a field. It all displays ok in the query if I run a select query but if I run a make table query it cut some of the text of the end. ...
Hi
I am trying to create a basic database for my colleagues that records several features of training for customers over the course of time. I have a form that records the course details - da...
I have created an access database with many forms and multiple tables. I need an enduser to be able to enter information on the form which will populate into different tables.
I need the locations file of the "MSACCESS.exe" and Desktop Shortcuts in Access 2000, 2002, 2003 and 2007.
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...
I have two Access tables that badly need a redesign. I have posted the entire project and description here at www.dropio.com/tasksdb. What I really need is some hand holding via desktop shar...
Hi
I migrated one of my main master data tables and its 4 lookup tables from a BE Access MDB to a new SQLServer BE. Everything migrated ok.
Q1 : In the SQLServer BE when I open the main da...
I have been using an Access Database since I created it in Access 97, then upgraded to Access 2002 (XP) and now in Access 2007. I have Modifed some of the forms which I originally created in ...
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 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...
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'm trying to stop authorised users in the workgroup file from accessing the data tables in our database (BE) through external connections.
Our front end application (FE) connects to the B...
Hello Experts,
I created the table below. The Caloric Level is the first column and the values next to each type of food group correspond to how many serving are needed based on person's ca...
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...
