Search results

Hi John, thank you again for all your help with this. I'm going to go through every single page and ensure that each field is correctly named. Also I'm well aware (now) of the problems encountered when putting a space into a field name. It's just a shame that the project is too far in to change...

John - Tel ID is an Autonumber field and I changed your Customer ID to Tel ID to reflect this. I don't understand what is causing the error message, it appears at random times and for no real reason. Sometimes the database can work fine for 2 hours but then the error will just appear. I don't...

That error could actually be because of the extra line below I inserted into your code John: If Me.NewRecord Or Me.Dirty Then Exit Sub The reason I put this in is because sometimes there will be no record in the system, so everytime the refresh occurs I get the error message: Invalid use of null.

John - thanks again for your help on this problem last week, however things aren't quite working 100%. Every now and then and seemingly at random we get the following error message: "Run time error 2109. There is no field named 'Tel ID' in the current record. I'm not sure exactly what causes...

John that did the job. Thank you very much matey. I would never have been able to write that piece of code. Did you write it yourself or find it on the internet? If you found it, which website did you use as I only use this site and the official Access forum, and any other useful sites would...

One other thing though - if the user is working on the record that's being bookmarked, I notice that after the requery the cursor goes back to the very first field in the record, is there any way to make the cursor remain in the field where data was being entered?

John that's superb and works an absolute treat! Thank you ever so much. :)

Hi guys, Bit of a problem I'm hoping someone can help with. I have a telephone call logging system. The system is a tabbed form with each tab representing a person's Telephone Call Inbox. As new calls are entered into the database, they appear in each person's inbox until they are marked as...

I'm getting closer to solving this: As a new filed in my query I have: QuantityRemaining: [Quantity]-[QtyDelivered] Which works, but I need this to be for the Sum of Qty Delivered. If I put [Quantity]-Sum[QtyDelivered] I get the error 'The expression you entered contains invalid syntax'...

Hi guys, I have a query containing the following fields: OrderNumber, ItemNumber, QuantityOrdered and QuantityDelivered QuantityDelivered is the SUM of all Deliveries against each Item in an order. I'm trying to generate another field called QuantityRemaining which is equal to...

I can't seem to find an answer to this on the forum already, if it has been answered the please provide a link and I apologise profusely. Anyway, I want to query a table based on various combo boxes, for example an orders table which contains details of all orders placed. I want say for...

Hi guys, I have a bit of a complicated query here that I need some serious help with. It's quite difficult to explain so bear with me. The basic jist of the problem is that I need to calculate the quantity remaining for an item by comparing the total delivered against that item number with the...