| Thread | Last Post | Replies |
|
| Form for multiple client use and transfer of responses to table | 11 Jun 2007 08:38 GMT | 4 |
I wish to create a form for staff to use that contains questions about their existing skills and then have Access transfer their reponses automatically to a table. I want Access to open at the same blank form each time ready for staff to use, without the need to create a new form ...
|
| Can I create a program utilizing Access? | 10 Jun 2007 20:18 GMT | 2 |
I am a chiropractor who wants to create a universal program to clinically diagnose low back complaints. The questions I have are: 1. Can I create a program (utilizing Access) that others can use even if they don't have Access?
|
| Guest/Room Allocation Database | 10 Jun 2007 11:49 GMT | 2 |
I am an Access novice and need to create a database which will help me assign rooms, with host families, to international exchange students. I also need to be able to check availability of rooms etc. at any given date. At the moment I have a table with Family ID, Name, Address, ...
|
| Tracking multiple man #'s with one work order # | 10 Jun 2007 01:37 GMT | 6 |
I designed a database to track quality control inspections for a vehicle maintenance shop and I have a problem. Several mechanics may put time on one work order. How can I track several man numbers to one work order number? Here is how I have it set up:
|
| Access-friendly spreadsheet data | 09 Jun 2007 16:37 GMT | 3 |
I have an excel spreadsheet that I need to be able to translate into something Access can use. The problem I have is that there are both row and column headings (like a pivot table) and the spreadsheet field is a non calculated answer. The data is static and used in other ...
|
| Questionnaire data onto table | 09 Jun 2007 13:06 GMT | 3 |
I wish to create a questionnaire and have Access automatically record the responses on a table. I want staff to be able to use the same questionnaire (i.e. it is refreshed for the next user) not to have to create new forms for new users.
|
| Switchboard creation | 08 Jun 2007 20:12 GMT | 3 |
I have 12 sections in my office and Im trying to setup a switchboard with a page for each of the sections but im finding myself limited to 8. How can I change this so i can use as many as neccesary?
|
| Table Problem | 08 Jun 2007 18:44 GMT | 4 |
I have a database with two tables. (Access 2003) In table1, there is a lookup field that uses table2 (table2 contains employee names). For some reason, Access is assigning the data type of that field to NUMBER.
|
| Custom error messages | 08 Jun 2007 14:20 GMT | 2 |
Is there a way of overriding certain Access error messages with my own? I know you can do it at the form level, but is there a way of just saying..."anytime this error ever comes up, bring up my custom error message." The reason is b/c I have a lot of forms and buttons and ...
|
| ACCESS TEMPLATE FOR ISSUES | 08 Jun 2007 12:16 GMT | 1 |
We downloaded th etemplate for issues and have added several fields to the form. They are also fields in the dtatabase. When entering data via the form, it does not fill in the added fields in the database table. Help please?
|
| Multiple values into one cell with each on a new line | 08 Jun 2007 08:52 GMT | 3 |
I am trying to concatenate [Street 1], [Street 2], City, State, and Zip fields into one field called Address in a separate table. Is it possible to create a query that would use INSERT INTO and add the next field as a new line below the previous one? I tried using VB but all I ...
|
| Q: Exel vs. Access, email notification's, calculations | 08 Jun 2007 00:10 GMT | 2 |
I am setting up a database and have a few questions. I am setting up a road database for the Village that I work in to track the maitenance of the roads, as well that the time lines for reconstruction. 1. First off I am not sure if I should be using Access or Excel for a
|
| Replica Database in Briefcase | 07 Jun 2007 16:16 GMT | 1 |
I have an Access database which is on the main office server and updated by my office staff. I have recently dragged a copy of this file into the "Briefcase" on my Laptop so that I can have a "more or Less" up to date version with me when I am out of the office. When I did this I ...
|
| Making a value span multiple rows | 07 Jun 2007 16:14 GMT | 1 |
I am trying to concatenate [Street 1], [Street 2], City, State, and Zip fields into one field called Address in a separate table. Is it possible to create a query that would use INSERT INTO and add the next field as a new line below the previous one? I tried using VB but all I ...
|
| SQL Server 2005 | 07 Jun 2007 14:19 GMT | 1 |
I am planning on rewriting an Access database using an Access front/back ends into one that uses an Access front-end and SQL Server 2005 back end. When I designed the db originally, the database was stored on the G:\ drive and the front end was on each computer. On my ...
|