Search results

Hi all, I remember seeing a thread regarding setting up an automated Compact & Repair process, but I can't seem to find that thread now. Could someone please direct me to a reliable version of this type of process. Thanks.

Hi all, I have created a form that acts as the main / home screen for my database. Is it possible to add a text box or other control that will display the database file size so I can monitor my database growth without going through My Computer or Windows Explorer? If so, how?

Everytime I've faced a near death experience on the road it's been due to a female driver. So, even though I'm biased, and at the risk of starting World War 3, I thought I'd pose the question. Which sex are better drivers? No sitting on the fence with this one! :eek:

I'm designing a report so I've put the thread here, but it could almost be a Table question also. Okay, within one of my tables, I record a catalogue number. The column though is set to Text because the catalogue number could be "878b" for example. I've built my queries for that table and...

Hi all, Every time I open my database if the first thing I do is run Performance Analyzer for VBA Project I get the following suggestion :- "Application: The application is not saved in a fully compiled state" Where I'm confused is that I can go into Visual Basic, select Debug, and select...

Hi all, I recently added a code to my forms so that I will now receive a message telling me to confirm changes to the record. When I run Analyze Performance now though I get an idea warning for each form in the database suggesting that I use an Option Explicit statement at the beginning of the...

Hi all, I was wondering if it is possible to create a "Confirm changes" dialog for a form. If I open a form at the moment and edit a field, that change is automatically saved to the table. The problem with this is if a change was made accidentally, it would be saved when you moved to the next...

Hi all, Is it possible to create a button that will take you to a second form that brings up the same record. Form example, you have FRM_Alpha open and enter a certain amount of data and then click the button to open FRM_Bravo at the same record number to enter the second half of the data...

Hi all, Can you use the same referenced ID more than once in the same table? I have a database for my stamps. The exact same type of stamp may be kept in more than one location (Album). So, I have TBL_Albums which has two fields "AlbumID" and "AlbumName". Can I use "AlbumID" in my main...

Hi all, I have just normalized my database. In my main table "TBL_Main" I have a column "CategoryID" which gets it's information via a form combo box. The combo box looks at another table "TBL_Categories" which has fields "CategoryID" & "CategoryName". So for example, the first record in...

Hi all, I'm currently re-vamping an existing database. What I'd like to know is how to enable a combo box so that I can make and display multiple selections on a form. I have a table called colours which just contains 2 fields "ID" & "Colours". The way the database was previously set up I had a...

Hi all, Okay, here's the scenario. I have a database for a stamp collection. I have a table named "CWused" with records data for Commonwealth used stamps. I have a form for this table called "CW Used Stamps". One of the combo boxes on the form looks up another table called "CW Countries". Within...