Search results for query: *

Thanks - I tried your suggestion by creating a second query rather than both forms relying on the same one. It worked fine as I was able to set the second so that it wouldn't allow updates - but then I realised that as I have two subforms on my main form both with their own queries. Is having...

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...

Pls disregard. Have resolved it now.

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...

Thanks Duane for your response. Could you elaborate on your suggestion of... "then use the events of a form to trigger insertion of records." ?

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

This shows how to locate the address book (which I will also need to do so thanks!) but will this .wab file also contain the contents of the inbox from OE?

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.

Thanks for your quick response. I'm sure I tried this already and had a problem because the new record is to be added to the subform (in datasheet view) and the subform is opened at the same time as the main form.

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...

Hi Sandy Thanks for your response. If I used another Access database to perform the tasks(delete previous/import.csv/clean up and add date) before appending data will it avoid the need for regular compacting? My users are beginners (at best) and they don't have on site support at any level...

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...

I'm sure I can help but I'm not sure what you mean! If Plan1!a1 and Plan2!a1 are the same (ie Red) - what do you want to see in Plan3!a1? Also, if If Plan1!a1 and Plan2!a1 are different(ie blue/green) - what do you want to see in Plan3!a1?

I've got a similar problem in that my client wants to email Access reports. I've had to re-create the report in Word and use query results from the .mdb file with mail merge so if you find a solution, please let me know. I did see a post on this site earlier today about using snapshot viewer to...

I've recreated this in Powerpoint 2000 but the footer is visible. What process are you using to apply the footer to the template?