Search results for query: *

I have a form for "new" sales. A copy of that form is used to display "existing" sales to the user. I want the existing Sales form to be un-editable to ensure users don't modify orders after they've been placed (There's provision elsewhere to modify an existing order). I've created a quick...

My main form was fine when it was alone - and still fine when I added the first subform but now I've added a second subform it seems that I can't add new records to the main form. I am able to add new records to both subforms. Is the problem related to the second subform or has something else...

The following code provides a search facility on a DB I created some time ago. I need to perform an almost identical task now but am having trouble editing the code to suit. Sure it will be simple - but then, so am I. This one enables the user to search for a Doctor by name, and if there is more...

I'm creating a db for UPVC wndow sales. Some of the items on the customer order/invoice will be picked from existing stock items but the windows themselves are made to order (due to sepcial sizes/materials etc). Do I have to have two subforms on my form - one to select the stock items (and show...

I'm trying to design a stock control database for a retail business. I'll use a transactions table for the in/out movements of stock in the warehouse but the customer purchases will be made up of some items from warehouse stock and some bespoke sized items that have to be ordered in. How do I...

I need to compare (ona daily basis) how many records are updated by my users. I've found some code that will insert a new record in a separate table whenever changes are made. However, I cant get it to go past the line: Dim db As Database The process looks like this... Use the AfterUpdate...

My two tables contain exact matches on datatypes, there are no validation rules set, no required values set to yes and it all looks like my append query should work. However, I get an error message showing that of 3521 records, 3520 are not appended due to validation violations. There is no...

Now I have multiple users I'd like to capture their level of activity. Is there a way to collect username and date for each time a form is opened/updated or similar? I just want to compare the total number of records changed on a daily basis (so time is unimportant). Jax Introfield

Is it possible to transfer emails from Outlook Express on one pc to another pc? I've tried using the export command but Outlook Express doesnt create a .pst file as I expected.

I have a form which contains a subform Main form shows company details, subform shows history or contact/communication with that company. My client would like to have the blank row (new record) appear at the top of the datasheet subform and not the bottom to speed up data entry. My alternative...

My client wishes to regularly import a "campaign" from Thompson Business Search Pro (.csv). I have two problems... 1. A date field in the destination (Access 2000) table is a required field. The .csv file does not contain such a field (I am happy for current date to be inserted at...

My client wishes to regularly import a "campaign" from Thompson Business Search Pro. I have two problems... A date field in the destination (Access 2000) table is a required field. BSP export file does not contain such a field (I am happy for current date to be inserted at import)...