| Thread | Last Post | Replies |
|
| Recovering table | 20 Dec 2004 06:32 GMT | 3 |
Is there any way to recover a table after you delete it from Access? Robert
|
| How to restore cursor position after acSaveRecord? | 20 Dec 2004 02:33 GMT | 2 |
Right now, as the user types I'm invoking this code in the field's Change event: ----------------- With theField cursorPos = .SelStart
|
| Polymorphism and inheritance patterns in VB | 20 Dec 2004 02:16 GMT | 12 |
The classing Visual Basic and VBA support for polymorphism, let's face it, is a bit on the weak side, and built-in support for inheritance is non-existent. This little essay is about some patterns I've ended up using successfully for certain kinds of inheritance and polymorphism, ...
|
| SQL INSERT INTO PROBLEM | 20 Dec 2004 00:27 GMT | 1 |
I have the following lines in a macro: sql = "INSERT INTO IM (ITEM, DESC) VALUES (vitem, ndesc)" DoCmd.RunSQL sql Every time I execute the macro, I get a run time error saying there is a
|
| Excel Automation from Access - releasing instance | 19 Dec 2004 23:33 GMT | 1 |
I have a problem with the following code, which leaves an instance of Excel visible in Task Manager. By a process of elimination I have got it down to the fact that something in the DoCmd.Transfer Spreadsheet line is holding on to an Excel reference somewhere - can anybody assist ...
|
| There is no limit to human folly | 19 Dec 2004 23:03 GMT | 9 |
It seemed too rude to post this in reply to the post which triggered it but I had to get it off my chest. David
|
| Import Pics from folder... | 19 Dec 2004 20:42 GMT | 2 |
Currently we open a form and manualy place the pic in each new record. I need someway for to give Access a folder and then have it import each pic it finds in the folder and place the file name in the txtFilename text box. Can access do this?
|
| SQL MAX() on two tables | 19 Dec 2004 18:17 GMT | 1 |
I try to get data out of my access DB with only sql. I undersstand how I do it in access with two queries but i am trying to access it from an ASP.NET site! I have two tables like this:
|
| Unrecognised database format | 19 Dec 2004 18:12 GMT | 1 |
After splitting a database into a front and backend the database operates ok on a network for the rest of the day, however the following day it returns the error unrecognised database format, and does not open.
|
| delete column values (but not the column) | 19 Dec 2004 15:37 GMT | 1 |
A collegue of mine has made an access entry field and keyed in all the data. Now I have to key in the same data in the same database. However, I first need to delete the values in several colums in order to start. i.e. i need the current values of a certain column to
|
| populate combo with field-caption-names of a table | 19 Dec 2004 15:28 GMT | 7 |
How can i populate a combo with the field-caption-names of 1 table? Thanks Filip
|
| Making change to tab-defined linked file from access | 19 Dec 2004 14:46 GMT | 3 |
I have a tab-defined file linked to a table in access. it seems to work fine but I can't make changes or delete any queries. Why? It only works if I make new queries. Henrik
|
| Function As Rowsource In Listbox??? | 19 Dec 2004 11:58 GMT | 3 |
I have a function named MyFunction in a standard module that creates a semi-colon delimited list. I want to use this list for the value list in a listbox. I have the row source type property set to Value List. Can I use the function, MyFunction, as the row source of the listbox? I ...
|
| Copy and Paste header into MSWord template | 19 Dec 2004 04:32 GMT | 1 |
I am doing a job where I need to copy a letter header into each of about 100 letters which are mail merge template documents for about 20 different customers - all up about 2000 copy and pastes requiring opening each document and deleting the current header and pasting the new one. ...
|
| How to track the history of a selected number of fields in a record? Access2003 | 19 Dec 2004 04:12 GMT | 1 |
I have set up two tables ****current and ****history. The history table contains all the fields which I want to track changes on. The current table contains just the most recent information from those fields (history not important).
|