| Thread | Last Post | Replies |
|
| Updating Access Database | 30 Oct 2006 23:01 GMT | 1 |
I'm a relative newbie with Access 03. I have created a test database and imported an Excel spreadsheet w/data into the database, so far so good. Now I need information (think Access for dummy's type info) on how to update/refresh the current database table with new data from an ...
|
| Display True, False, or "All" records in a continuous form | 30 Oct 2006 22:05 GMT | 2 |
I'm sure this is a common question, but I can't seem to phrase it right to find the answer. I have an option group in the header of my form called "grpFloat". I want to display records in this continous form that reflect selections in the option
|
| trouble importing into access | 30 Oct 2006 21:59 GMT | 4 |
I'm running Access 2003. Trying to import two files, either CSV or XLS. Access allows me to select the file type, location and so-on. However when I've selected the file (either double click or "import) the dialog box disappears, and no import! Tried this from a couple of Db's ...
|
| Export Hyperlinks to Excel | 30 Oct 2006 20:06 GMT | 4 |
I am exporting records from Access to Excel. One of the fields is a hyperlink and I am having trouble getting a working link by the time it reaches Excel. What techniques are needed to make this work? One thing that I noticed is that the hyperlink in Excel has leading and
|
| FoxPro Connection String | 30 Oct 2006 18:24 GMT | 1 |
I'm using MS Access 2003 on an Access 2000 database file and the FoxPro are "Free" tables. ie. no dbc file, only dbf files. Problem: Relinking FoxPro tables generates an Access error number: 3011, description:
|
| How do I display number field in Access? | 30 Oct 2006 17:25 GMT | 3 |
I am trying to create a database by an fixed width ascii text file. The number field is 13 digit number, including two leading zeros. I have formatted the field in Access for a numeric, long integer type. My problem is that when Access imports the data, that numbers will not ...
|
| inserting data from excel sheet into a form | 30 Oct 2006 04:36 GMT | 1 |
i have something in my mind that im trying to do but i dont know how... there is a Excel table using many functions in its fields...the last row of this excel sheet represents the total (currency euro) of all functions of above...so
|
| Is it possible to mail merge two access tables into one word docum | 29 Oct 2006 17:19 GMT | 2 |
I was wondering if anyone knew if you can make one mail merge document based on two access tables. One table has say client information. The other is the products assigned to a client. It is a many to many situation with the product information coming from a seperate table.
|
| Can't Add a linked table to SQL Server 2005 with Access 2003 | 28 Oct 2006 22:27 GMT | 1 |
I have an Access 2003 front end that contains a number of linked tables on SQL Server 2005 SE. I recreated the application on a second network for testing and was able to use the Linked Table Manager to refresh the database connections. The problem is when I try and add another ...
|
| Decimal places changes in word document? | 28 Oct 2006 11:40 GMT | 1 |
When using the merge in word with a excel spreadsheet the decimal place changes from two to eight decimal places. How can this be corrected?
|
| how to replicate access database accros network? | 28 Oct 2006 01:35 GMT | 1 |
I'm having dificulty finding out how to replicate an access 2003 database across a VPN network via a mapped drive. I have read docs on using an "replication manager" but i can not locate such a application. I would like to add this to a vb.net 2.0 in app also.
|
| macro/code needed to export multiple tables to .txt files | 28 Oct 2006 01:34 GMT | 3 |
Several times a month, I export the same 3 tables each to a fixed-width text file. I maintain the same file name (as table object) and then append the current date at the end of the name. These files are then appended together in a text app for upload to another system (I can't ...
|
| How import a new ver outlook archive pst file to an old ver outloo | 27 Oct 2006 19:51 GMT | 1 |
I'm trying to import an outlook archive pst file from a newer version to an older version, how can I do this? Is there a way to convert the pst files?
|
| Problem Importing Fixed Length Text File Using VBA | 27 Oct 2006 19:01 GMT | 1 |
I receive this file from another organization that contains several fields in a Fixed Length format. I can import the file manually using the wizard to a local table in Access2k3. I saved and regularly use a specification to do this.
|
| How do I import DOS files into Excel? | 27 Oct 2006 17:39 GMT | 10 |
My new boss has a DOS database with clients names addresses and account numbers. The ultimate goal is to get this into Access. I am assuming I need to get it into Excel first. How can I do this?
|