Search results

Hi all, I am a newbie and need to copy a calculated result from a textbox ("txtAmountEnter") to another ("InvAmount") whose control source is a field in a table (therefore not able to hold a calculation). I have been using: ======================================== DoCmd.GoToControl...

Hi all, I have a Form with a combo box that I access by pressing F6 with the following function (converted from a Autokey macro): Function AutoKeysF6() On Error GoTo AutoKeysF6_Err ' Find PO# DoCmd.GoToControl "FindPO" AutoKeysF6_Exit: Exit Function AutoKeysF6_Err: MsgBox Error$ Resume...

Hi all, I have an append query that I run daily and want to append only records with different OrderID. ------------------------------------------------------------------------ INSERT INTO tblConfirmSchedule ( OrderID, JobCode, JobDate, Status, [Home#], [Work #], Ext, [Other#], Ext2 ) SELECT...

Thanks DocMan for trying to help. I already solved the problem and have the tables ready, I had to add some tables. The price list is been updated with update queries thru my form like it was suggested, and if not for a nagging glitch with the formulas I am almost done. Sorry for all the...

OOOOOOOH, is that how you see it? All I am asking is if someone who has the proffesional knowledge like you take a quick look at my table designs (I figure that it would help to look at my spreadsheet to know where I am coming from) and briefly comment on them. Thank you for offering to help...

Hi all, I started a new thread, because it is a new subject even though is related to my Price List thread, I hope is OK. If someone can please take a look at my attached Excel Price List (particulary the factors sheet) and give me an opinion of how my tables should be created. I cleaned the...

Thank you I will try that. Thanks again, Emilio

Thank a lot for taking time to help me DocMan. I think I understand exactly where you are coming from. I understand that is VERY important to keep the orders (Invoices) historically correct. Early on I made sure that my Order Details reflect the prices at the time of sale, having taken care...

Thanks again Neil, I converted the mdb to 2000 if you want to see it. I understand what you saying, but have problem visualizing how to accomplish it. What I want to do is create a form where a user can enter new products and update prices when needed. I created a frmAddProducts some of the...

Thanks for your responses, Like I said at the beginning I am a Newbie, in the sense that on top of running my business once every two months or so I get to make some additions or changes (which I love to do), being self-tought I forget easily and need some remainder to get started. You...

Hi all, Before I start, please know that I am what you call a newbie to a certain extent even though I created in the last 3 years a very complex and efficient database for my business. This is going to be hard to explain, but I'll try. The time came to stop creating the Price List in Excel...