| Thread | Last Post | Replies |
|
| using database from different versions | 28 Nov 2005 20:41 GMT | 4 |
Is it possible to use\view a database that was built using Access 2000 with Access 97. Are there some steps that can be taken to make them compatible. I get a "unrecognized database format" error message when try to open it in '97.
|
| Print Publisher document | 28 Nov 2005 20:14 GMT | 1 |
Users want to click on a control and immediately ship a Publisher -- or PDF -- document to the printer. I found an old conversation with this code for Word: Dim wdApp As Word.Application
|
| Custom Menus Question (Remove 'Type a question for help'). | 28 Nov 2005 20:08 GMT | 1 |
In one (actualy several) of my databases I create custom menus. However on all of these menus, the "Type a question heer for help" combo box appears to the right side. Can anyone here point me to code (whatever) that will turn this feature off?
|
| MS Access 97 / UNION / SELECT INTO | 28 Nov 2005 19:56 GMT | 2 |
Dear List, as it seems, MS SQL as used in Access does not allow a select INTO within a UNION query. Also, it seems that a UNION query can not be used as a subquery.
|
| Create a Query on a Hyperlink | 28 Nov 2005 19:00 GMT | 5 |
Have '97 and am trying to create a query on the underlying Hyperlink field - ie if xxx then else ... Can't find a way to do this and would very much appreciate some kind help - thanks - John
|
| create relationship between two tables | 28 Nov 2005 18:02 GMT | 2 |
I want to create links between my two tables. The primary keys of these two tables are character variables, with length =11. I followed exactly the instruction of Dummuy Book for ACCESS 2003. I click the primary key of table A , and hold and move the mouse to table B. But nothing
|
| HELP: how to recover deleted record from a Table | 28 Nov 2005 17:37 GMT | 1 |
there is a utility o procedure to recovery deleted record from a Access table (versione 2002/2003) ? Thanks in advance Roberto
|
| How to enforce pessimistic record locking? | 28 Nov 2005 15:27 GMT | 1 |
I have been ok with optimistic locking most of the time but I have a situation now where there is more of a chance that users could try to edit a record at the same time. I'd like to use pessimitic locking, but it's not working quite as I expected. I've read all over, and by now
|
| AutoNumber Issue | 28 Nov 2005 13:02 GMT | 2 |
I am writing a program in C, which will be driving via a MS Access database. I am relitivly new to database design, so if anyone could help me with my issue I would be greatful. I have defined a database field to be a primary Key, this field is set to
|
| Is it possible to refresh records displayed in an open table from a form? | 28 Nov 2005 12:04 GMT | 4 |
If both a form and a table are open in an A97 database, are there VBA commands that will refresh records shown in the open table so that records appended since the table was first opened will display - similar to how they would be
|
| User Roster for a secured backend | 28 Nov 2005 10:29 GMT | 1 |
I'm trying to determine who is linked to the backend. I'm using the Microsoft code on the Jet User Roster that uses ado to develop a list. The front end and backend are secured. This code is to go in the front end. I don't understand why Access is telling me that I need to provide ...
|
| How to use UNION ALL and SORT BY | 28 Nov 2005 10:28 GMT | 1 |
I have an asp site where I sell some products. Product categories are stored in different tables. There are different asp product pages, which collects data from these tables. I have also created an all-product-page, which works fine with the
|
| Adjusting Report Properites via code | 28 Nov 2005 09:05 GMT | 1 |
I have set up a simple database to create labels for bottles. I insert a set number of records into a table and have produced a label report based on that table. After a bit of tweaking, the labels fit perfectly to the A4 label sheets I have.
|
| understanding North Wind Stock control | 28 Nov 2005 07:52 GMT | 4 |
In the sample northwind database when an order is sent the sent value come of the instock value. I can not work out how they have done this . I can see that it is an eventprocedure but can not understand it or relate it to my data base.
|
| refresh/redraw flicker on mouse over of lable control | 28 Nov 2005 05:26 GMT | 1 |
I've built a data entry form for a survey database that appears to make the entire form flicker when I mouse over anyn of the label controls. I suspect that it has to do with the standard hyperlink function embedded all label control, even though I am not using it. The ...
|