| Thread | Last Post | Replies |
|
| Printing Reports | 23 May 2008 00:58 GMT | 1 |
I have a "report" set up and would like each record to print on a 3x5 rolodex card. Somehow I cannot get this to work. I have individual cards, not a preforated sheet. Can anyone offer any suggestions Please!!!
|
| Hyperlink Default | 23 May 2008 00:55 GMT | 1 |
Hello, in Access2003... I have a search form that looks up quotes by quote number etc... one of the fields on the quote table is a hyperlink to a pdf of the quote form. Currently I have been linking the pdf files by right-click and find the path
|
| Want only database name from Application.CurrentDb.Name | 23 May 2008 00:20 GMT | 9 |
2003 How can one get only the current database path from the (Access converted macro to VBA) VBA command Application.CurrentDb.Name? I cannot find a function in Access VBA for the filepath of the current .mdb
|
| Adding Short Time? | 22 May 2008 23:52 GMT | 1 |
New to access so please be patient. I am making a database to track employee's overtime. I have an employees table and an overtime table. On the overtime table there is one column for date, one for time earned and one for compensation (cash or time). The amount of time earned is ...
|
| date function | 22 May 2008 23:40 GMT | 7 |
I am creating a customer database for my repair business. I would like to create a field that displays tomorrows date except on a Tuesday when it displays the next Thursdays date and on a Saturday it displays the next Mondays date.
|
| Link tables ODBC | 22 May 2008 23:18 GMT | 3 |
I have installed a driver which links to a MySQL database (tests successfully) However, when I try to link to the tables in Access 2003 nothing happens (the connection wizard fails to run) I press Get Externa Data, Link Tables and when I choose ODBC Databases
|
| Converted Access 2003 database loop | 22 May 2008 21:14 GMT | 3 |
Recently converted an Access 97 database to Access 2003. Moved the database from a Windows NT server to a SAN. All was well. Twice in the last 6 months strange event occurred. A basic VB Do While loop that inserts records into a table went crazy! First time inserted 2000+ ...
|
| Networking Access 2003 across different sites | 22 May 2008 20:40 GMT | 1 |
Ihave built many networked datases and have always used the technique of splitting the data tables placing them on a mapped drive and providing each user with a frontend that links to the data tables. However we have a client that has a client/server network installed on one
|
| Using DSum To Display Running Total On Form | 22 May 2008 20:35 GMT | 7 |
I have a form that tracks vacation hours accrued and taken. The Fields are as follows: Week Period End Date Accrued Hours Hours Taken Balance 1 12/26/07 3.08 0.0
|
| Multiply a field | 22 May 2008 20:09 GMT | 8 |
I would like to have a field be mulitplied by a set number and that number be stored in another field, for example: We copy medical records and charge a .75 cents per page. What I would like to do is that when the number of copies is entered into field it will be
|
| Primary Keys, Indexes, Relations (inability to update/edit queries | 22 May 2008 19:59 GMT | 5 |
Created an employee database with the following tables: Employee Info Haz Mat Training Records Safety Training Records
|
| Query -Change Column Headings each time | 22 May 2008 19:48 GMT | 2 |
I am a new user of Access. I am not sure this is a right question. Assume I have two tabels Jan Feb Mar Apr May Jun Table 1 Budget 98 98 56 45 879 99
|
| Choose function does not appear to be rounding the index | 22 May 2008 19:27 GMT | 2 |
I have a text field in a report named NumberRating and I want it to provide the average rating of all the records displayed. If I use the command =Avg([NumberRating]) in the Control Source and set the Format = Fixed and Decimal Places = 0, I get the appropriate results. For ...
|
| Database placed in a state by user . . prevents it from being open | 22 May 2008 19:22 GMT | 6 |
I have observed this problem on three different machines, with three different applications. I have come to the conclusion that it must be something about the computer itself. The problem is not related to the number of users. I have one user who opens that database and if ...
|
| Validation help | 22 May 2008 19:21 GMT | 1 |
this for my own practice, not for profit. I have run into this situation a couple times and never known hot to go about it OK, I have 3 fields: date, time start and duration (or could be time end) How can do I go about making it so that these fields can't overlap or have
|