I have created an application for a local telco, split into a front and back end. Some users have the full version of Access installed, others are using...

I have a column that can be either a 6 or 8 digit number and it must be formatted as follows 99.99.99 or 99.99.99_99 How do I set up the imput mask and the...

Hi Is it possible to add new fields to a temp table or do they have to come from existing tables? for instance - i have a form based on 2 temp tables. i'd...

Hello All: I have a incident table, action_taken table and incident_action_taken table. incident table ------------------- iid(PK) name desc

I create 5 forms form related 1 to many related tables in MS Access. I need to keep the forms together. How can I do This_

Looking for a good hosting provider? The following site lists the current best selling hosting providers for shared and dedicated hosting. Best selling means...

I would like to be able to sort the records on a subform (in continuous form view) using a control. For example, clicking on the label for the Date field...

Hi, I am an MS Access newbie. I have a form with two subforms. Main form and subform both quries the SQL db though ODBC link. When I run main form and...

My main form is for my Contact table. It includes your basic data of name, Address, City, etc. I have a field called ContactPatientRelationship. If that field...

I have created a form with a subform. I need to subtract a feild from the subform from a feild on the form. Also the data from the fields come from two...

I need to make a button to copy all information entered by the user to a new record then allow the user to correct one or two field of them how can i do...

We are currently moving a paper based work system to access database, I have created the tables and linked them to forms, but I am struggling to make a field...

in some sort of date order? Or have it so people can sort by date order and search more easily? Posts seem to disappear and heaven forbid if you forget...

Dear all, In a main form for user to input and view records, I’ve added a sub-form which linked with a table called tblFileMovement to show two...

I'm having a problem with a small MS Access 2000 database (.mdb). I have a main form and on it I have two datasheet subforms I'll call sf1 and sf2. Sf1 and...

I have a subform with combo box. User's are having difficulty selecting values from the combo box directly because so many of the values are similar (many...

Hi there Can some pls help - i have a form with a delete button on the toolbar (not on the form) - depending on whether a record is assigned to another...

There is a form where it ask the two dates and then run a query then report. Private Sub Command36_Click() DoCmd.OpenQuery "qryResultsReport" DoCmd.OpenReport...

I have a accounting database that comprises many suppliers, who are each owed many invoices. I want to design a form that shows on or two pages each invoice...

Here's my current AfterUpdate on a ComboBox: Private Sub cboProductFamily_AfterUpdate() ' Find the record that matches the control. Dim rs As Object ...