| Thread | Last Post | Replies |
|
| SendObject problems | 11 Feb 2004 15:02 GMT | 8 |
Sorry if this isn't the correct group for this but I'm not sure which Access group is more relevant. I'm having a problem using SendObject to send an email automatically from within Access. I understand how it works and have had help with the code I
|
| Form data to Word Document | 11 Feb 2004 13:56 GMT | 1 |
I have some forms setup where the information displayed is determined by the ClientName the user selects from a listbox. I then have a button which I want to print a word
|
| Export text file | 11 Feb 2004 05:35 GMT | 12 |
I have successfully exported data from Access 2000 into a text file using a custom export specification. I'm getting the data I want. However, the resultant text file records are still not in the form that my accounting software needs. Is there any way in VBA to open a text ...
|
| Connecting to secured db | 11 Feb 2004 02:54 GMT | 1 |
A Word form connects to Access by: vConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "data source=C:\Program Files\CheckIt!\Diagnostic_Testing_be.mdb;" & "Jet OLEDB:System Database=C:\Documents and Settings\Dr Mirro\Business
|
| Primary Keys: Importing Access DB in Access DB | 11 Feb 2004 01:47 GMT | 2 |
I hope somebody can help me: I have an Access DB and want to give a copy to another person. The other person and me will work parallel on our copies of the DB. After a while we want to merge the two
|
| Error trapping on RunSQL | 10 Feb 2004 22:23 GMT | 2 |
Trying to get a list of files not able to be appended into my tblBdata. These linked .csv files come from the field and while they <should> be in the specific format, they are not always.
|
| problem | 10 Feb 2004 20:21 GMT | 2 |
I tried the first idea with no luck with the paste values. the common repetition that does not import is that the new rows would import less each time a set of 8 rows were added. eg i add 8 rows and only import 3. tommorow i add 8 rows and only imort 1. now it does not import any ...
|
| query produces duplicates for every record | 10 Feb 2004 19:08 GMT | 5 |
I have two separate groups of tables and queries from one source. I am using the retrieval to my Word Merge files since there are quite a bit of "IF...THEN...ELSE" in my merge
|
| Error Accessing File | 10 Feb 2004 18:27 GMT | 1 |
I have several databases that I am having a problem with. Development goes along just fine. Then, at some point, out of nowhere, I get a message that says "Error Accessing File. Network connection may have been lost". Then the database does all sorts of strange things, like I can't ...
|
| Importing Text without changing the Format to Scientific? | 09 Feb 2004 22:24 GMT | 1 |
When Importing Data into a New Table in Access 2000 from Excel 2000, one of my Columns/Fields changes the Text to a Scientific Notation Number? The Import Column in Excel is formated as Text and
|
| Updating Information in a Database | 09 Feb 2004 19:29 GMT | 1 |
Is there a way to have Access automatically update the date whenever a change is made?
|
| Importing Cobol file | 09 Feb 2004 12:14 GMT | 3 |
What is the simplest way to import COBOL COMP-3 variables in Access XP ?
|
| Import spec is "Empty" in TransferText command? | 09 Feb 2004 08:22 GMT | 4 |
This codes links all .csv files in a directory to my database. For some reason, even though the "A2Import" spec exists, and the specification does work
|
| Export query to Excel and run excel macro | 09 Feb 2004 07:10 GMT | 1 |
Hi. Can anyone provide a suggestion or code to export a query to Excel then run macros from Excel, which I've already created in Excel. I have my Excel macros in a workbook called "Vendor25K" and my Access query is
|
| link table | 08 Feb 2004 19:20 GMT | 4 |
Hi, I create a user(user1) only have "read" permission in SQL server. and through ODBC(use user1) and Access to create a link table to access the sql server database. At my clinet's computer, I at least saw two situations:
|