| Thread | Last Post | Replies |
|
| Create a fix for file conversions | 26 Nov 2004 17:25 GMT | 2 |
I suggest you create a fix for file conversions; meaning that not all conversions are able to be read. I suggest a chart or table stating what each of the conversions are and which file type they belong to and what one needs to convert it to a different file type.
|
| Selecting and copying records sets from query to table using event | 26 Nov 2004 08:05 GMT | 8 |
I would to be able to write a event procedure that once a button is clicked it would run a query select and copy all the results of that query and paste them into a predetermined table which would need all of its current records deleted before it paste the new records. I would ...
|
| DAO Library Problems | 25 Nov 2004 22:11 GMT | 4 |
Folks, I noticed something strange between two reference library versions, DAO 3.51 and DAO 3.6. IF I reference DAO 3.6, my database can't find the MySysRepInfo table (replication info). I developed code in using DAO 3.51 to
|
| Opening up a Password protected file using VB | 25 Nov 2004 20:57 GMT | 1 |
Please can you help? I am writing some code that will show what users are using a shared database and in the code I have to put what file I am looking at so I have put the path in but the file is password protected and when i run the code it is
|
| Importing fields from a SQL file | 25 Nov 2004 18:23 GMT | 1 |
I would like to be able to enter into a excel cell a field from a SQL Query and have the rest of the fields auto fill in the predesigned excel fields. IE when I put in the customer number, the name, addresss, phone...... update in the cell. Is this possible?
|
| Opening a word document from a command button on a form | 25 Nov 2004 18:07 GMT | 4 |
I have created a new command button on a form which I would like to open a word document with. This is the code I have put in when creating the cmdButton Private Sub cmdReport1_Click()
|
| Custom toolbar does not appear | 25 Nov 2004 17:06 GMT | 2 |
Mdb1 uses a VB reference to a function in mdb2 to open a form in mdb2. When the form opens, a custom toolbar is suppose to be visible, but is not. Can I resolve this behavior, and if so, how?
|
| Disable mouse | 25 Nov 2004 15:40 GMT | 1 |
I need to disable the mouse scroll wheel function. Everytime I scroll the wheel at a new form, it automatically insert new records. If not careful, quite a number of new records can be created.
|
| Controlling Excel from Access | 25 Nov 2004 11:03 GMT | 1 |
I have a requirement to table a query from Acess and automatically open an existing excel spreadsheet, create a new sheet and export the data. I understand how to export the data but I am having problems opening a specific sheet.
|
| How to Handle Crosstabs and Filters | 25 Nov 2004 08:12 GMT | 3 |
I am trying to do a crosstab query based on another query which has a filter on it. The filter was the following: Between [Forms]![DialogPrintfrm]![DateLow]+1 And [Forms]![DialogPrintfrm]![DateHigh]
|
| Character adding | 25 Nov 2004 07:59 GMT | 3 |
Can anyone hook me up the VB Syntax? I want to increment a single character through the alphabet each time a button is clicked. It'll start at 'a' then go to 'b'. This is to uniquely differentiate quotes.
|
| Program failure | 25 Nov 2004 04:07 GMT | 4 |
A database which has been running successfully for some time has started reporting an error when any VBA calls are made. The database reports the following error: Error accessing file. Network connections may have been lost.
|
| Synchronize "After Update" and "Not In List" functions | 25 Nov 2004 03:48 GMT | 3 |
I need some help w/ synchronizing the 2 functions... "AfterUpdate" & "NotinList". Currently, I have a main form plus subform. On the main form, I placed an UNBOUND combo box which contains the AFTERUPDATE event (see below)
|
| how to resort a table from a module to extract firstrecord | 25 Nov 2004 02:17 GMT | 4 |
I have a table that with a Date field What I need is after adding , deleting or editing the Date field from an access module how do I resort the Date field to go to the first record (earliest)
|
| Splitting Date/Time values | 25 Nov 2004 02:01 GMT | 7 |
I need to split data in a column that is date/time. The data will be imported into an application and the import specifications require one date field and one time field, not combined values. Does anyone have a programmatic method of solving this? Or can anyone point me to ...
|