I have a form that is based on a table of information. I would like ther user to type in the primary key value and have the other related information appear on...

Hey There! Is there anyboddy who can help me? I try to send a mail via Access. This is my code: ------------------------------------------------- Private Sub...

So, I posted this last friday, and I figure I'd repost it with my additional comments after John had already made some comments: -----Original...

I have a simple form that won't calculate anything I put in as expressions (another story) but i also have a few precentage fields. I try to put in 0.3 and it...

Hi, I have a date time field, which I have formatted to show the date in 'dd/mm/yyyy hh:nn' format. I would like users to be able to key in the data in the...

I'm receiving an "Invalid argument" error message when trying to add a record to an Access database file that approaches the 2 GB size limitation. Compacting...

When the primary key is null and a record is being inserted I get this error: "Index or primary key cannot contain null values" I just want to change what the...

Hi All This question has probably been asked a million times before but.... I have a form that i have a can select a course ID No from eg. WORD001 from a...

Have a form with three subforms, over 100 controls in all. Under certain conditions, some of the controls on one of the subforms should not be enabled. The...

cannot save form after creating based on a specific table and unable to do so likewise for queries and reports '

When I am working in design view and I close the window I am not asked if I want to save my changes. This is a pain to me because many times I don't want to...

Is it possible to open another mdb file (i.e. close the current database and open another) using a command button? solution much appreciated peter

Hi I have a record lock function in my form which works fine until I click New Entry, which would normally start a new blank record. I keep getting the error...

I have a basic Combo Box/Employees form deal (with subforms, but the sub forms work OK). When I select a user from my drop down Combo Box, the correspdoniong...

Hello and thanks for any help on this as it has now happened twice. I have created a new database in Access 2000. I have imported some tables and forms from...

In my database, there is a presentation Form ("Form1"), which appears first when the database is opened and on Timer after 10 seconds, its closes the "Form1"...

I've created a hardware form(frmHardware). I've made it so that if any of the fields are changed, say Ram goes from 512 to 1024, it updates the comment field....

I haven't (successfully) used global variables yet, so I have a couple of questions. The general context here is a multi-user environment with user profiles...

This is my form's RecordSource (it works fine): SELECT tblProfiles.txtProfileID, tblProfiles.Version, tblProfiles.Type, tblProfiles.Description,...

I have an Excel file needs to export to an Access table. The Excel file has one worksheet and it contains 103 rows of data in 12 columns. One of the column...