| Thread | Last Post | Replies |
|
| Excel to Access | 16 Dec 2003 06:08 GMT | 1 |
Hi, I am a new user. I have an excel timesheet that everyone uses to enter their time. My boss wants to be able to have everyone enter their time on the excel timesheet file
|
| Scheduling Appointments | 16 Dec 2003 02:24 GMT | 5 |
What I am looking for is an easy way of setting up a calendar for booking appointments similar to the Calendar fuction within Outlook. We have a database the tracks work orders that we generate here. Now we want to use
|
| Linking Not Expected format | 15 Dec 2003 23:28 GMT | 1 |
I am trying to link to a log file in Faxman system. It's a log file, however recognized as a dbase IV file in Access. It gives me an "External file is not in the expected format" error. Does anyone know how to correct this? Do I
|
| Error writing to Linked Excel Table | 15 Dec 2003 18:26 GMT | 1 |
I have an Excel table linked in an Access 2000 Database. If I use a form to write to the excel table, the form accepts the data and closes without errors. However, if I then try to open the linked table, I receive the "External
|
| Preventing import of tables and queries from secure mdb | 15 Dec 2003 03:27 GMT | 1 |
Hi, I'm using user-level security with Access 2000. Even though I've secured my mdb, I've noticed that someone can create a new mdb, and import my queries and table links.
|
| Linking to Oracle: Too Many Indexes | 15 Dec 2003 02:56 GMT | 1 |
I'm attempting to link to an Oracle table and getting "Too Many Indexes" error message. Is there a workaround?
|
| Is there a way to test if a table exists in VBA | 14 Dec 2003 04:40 GMT | 8 |
Is there a way to test if a table exists in VBA before deleteing it ? I use this code to delete a table "CurrentDb.Execute "DROP TABLE Customer"", but if it is not there when that happens, it bombs the program with an error.
|
| Importing information from an EMAIL | 13 Dec 2003 23:13 GMT | 2 |
Does anyone know how to automatically import information from incoming emails into an Access database? I'd appreciate any advice as to how to set up something along these lines.
|
| WORD | 13 Dec 2003 06:56 GMT | 1 |
I have a query that uses a control on a form as one of its criteria. This seems to cause problems when I attempt to import the values from the query into Word. I realize the form needs
|
| Password connection to ODBC database | 13 Dec 2003 02:58 GMT | 10 |
I am working on an access database that will pull some data from a networked SQL server. I have most of the cod written and it works but when I first access the SQL server (as an ODBC linked table) I am propted for the password. How can I pass the password in VB? If it matters I ...
|
| Unsplitting a database? | 13 Dec 2003 02:41 GMT | 4 |
Hello, I have a split database with an Access fe and be. I would like to "unsplit" the database so that the tables reside in one .mdb file. How do I do this??
|
| linked sql server table | 13 Dec 2003 02:09 GMT | 1 |
i have a linked sql server table through an ODBC every time i open the table it prompts me for the password in the ODBC itself i can't get a password to be saved i don't want to have to enter the password everytime i
|
| need help exporting from Crystal Reports to Access | 12 Dec 2003 23:12 GMT | 1 |
I am trying to export a report from Crystal Reports to Access using ODBC. I create a report in Crystal Reports and save it. I create a blank database in Access and save it. I close Access. In Crystal Reports I go to
|
| Help Linking Tables In Access97 | 12 Dec 2003 22:44 GMT | 4 |
I've been asked to modify an Access97 application developed two years ago and no one is around that knows anything about it. The application has a Paradox DB and an Access97 DB. A
|
| Linking to Excel Spreadsheet, Format Problems | 12 Dec 2003 21:26 GMT | 1 |
I'm currently linking to an Excel Spreadsheet which contains our shipping report. THe link is fine with the exception that fields in the report generated by Access have different properties (Excel is formated as all text
|