Recent content by confused_Pete

Thanks for your help, i feel this is one of those cases where Microsoft has removed a feature unnecessarily. Oh well people will just have to get used to good old fashioned keyboard shortcuts. If anyone else has any thoughts on the matter please let me know. I will forward this on to Microsoft...

Cheers for the info on default shortcut menu's. Didn't do the job though. Could someone else who is running access 2002 (all service packs) try and create either a query or report that will utilize a dialogue box for entering say parameter values. When this dialogue box appears could you try and...

Thanks for the replies, Still having the same problem, this appears to happen in any database running in access 2002 where you have a dialogue box appear to enter a value. explorer features (cut, copy etc..) work when using key commands (ctrl - V etc..) but i do not get a right click window...

Hi, Just thought i would ask and see if anyone else has had this problem. When i use anything that needs a dialogue box (a query with a parameter to enter or a report with an option that needs defining) the right click options appear to have been disabled. I can press control and V to paste...

many thanks FoFa, I had an error in my update query SQL. many thanks for your help, and for the other suggestions that were put forward. Cheers Pete

This brings me right back to my first question which was, 'How do i create an update query to update the date field?' (please refer to my first post). Any help on how to do this would be appreciated. (as regardless of whether concerned members of the forum think i should be doing this or not is...

Cheers for the reply, but i do need to calculate and store this field. Is there a way to store this information, as each time a date is entered for a new order i need to add 3 days to this date and enter that information into the date_expected field. is there a way to do this, or should i not...

Hello, Im looking into a way of using an update query to take a date from a field add a certain number of days to that date and then update another field with that date. here is my select statement, how do i modify this to actually update the Date SELECT tblorder_no.Date_ordered...

Hi guys, thanks for your help. I decided that i was unable to solve this using SQL or QBE so decided at giving VBA a try, with perfect results, see code below: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Order_no.SetFocus Set rsOrderQuantity =...

Hello, Does anyone have any advice on this topic? I haven't been able to find any information by trawling through numerous books. What is the easiest way to add or subtract an amount in a field from another field in a seperate table? An example being, you have a main store of stock tblitem...

Hello, Thank you for your reply. In this particular system (analysis, theory) stock is entered into tblItem through tblorderquantity, and then later taken out through tbljobno. is there any way that this can achieved through a form, maybe even through controls on a button? I do appreciate...

Hello, First of all thanks to anyone who might be able to offer any assistance. I have a 6 table stock database which is in access 2000. I have a main store of the stock called tblitem (which contains item_id, item_quantity, description etc...), i have another table tblorderquantity this...