Search results

Could anyone maybe explain why I would be getting this error. I have been using this db and made a couple of changes and now I get this error when I try to compile it. Private Sub addtocustomer_Click() DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim...

thanks for the reply I will just use conditional formatting on each field then.

by reading several posts I came up with the DoCmd.RunCommand acCmdSelectRecord to highlight a record in a subform in datasheet view. My question is, is there any way to adapt a gray background color to the selected record instead of black?

Thank you I will look up the samples and give it a whirl.... I will definitely not be using this for order entry, as I am a novice and am thankful to have made it this far. Wish I could adapt order entry but I am a far cry from being able to accomplish that.

I think we're getting somewhere So I wasn't really to far off with my original design having the cost and the um in the tblparts. I have to say that I don't know very much at all about vba and I think that is what I need to make the beforeupdate event of the subform store the cost history. ...

? I am getting a "cannot add record(s): join key of table 'cost of goods' not in recordset what does this mean.

Correct me if I am wrong I understand what you are suggesting, so what would the recordsource for the subform become. I am using a query but this is giving me problems with entering a cost before a part record has been created and the u/m field may work if I just lock it. But how would you...

i'm sorry This was a sloppy db to post. I originally had the unitprice in the product table and everything worked great except I had no way of keeping track of price changes. It was then that I created the cost table and queries. I am totally lost on a good way to be able to view the current...

Haven't tried this yet Pat, I am somewhat confused on the what you are telling me to do. I don't think this will work for a subform set to continuous records will it. In the file I attached, notice that this program is only used as an informational source and not a purchase order program...

not sure what you mean Not sure what you mean. Are you saying on the form use a combobox and have it find the correct part price. If so could you elaborate because this would be on a subform doesn't that make it all kind of tricky?

??? Subquery? that's something I'll have to read up on. and the dmax() function, where would I add that to make that function. Would it still be possible to add a new record in my subform?

Maybe this will help I have attached a file with the exact form i am using. What I need to do is be able to keep track of the price changes but everything I am trying is not giving me the desired results. Does anyone have a suggestion on how to add this feature and still keep the form working...

table added small example of tables is Parts: PartID PartName Description CostofGoods: CostID PartID Cost U/M PartID's are linked one to many Then I have a query: (LastCostDate) SELECT CostofGoods.PartID, Max(CostofGoods.Date) AS MaxOfDate FROM...

Everything was great until this. I have a form which the recordsource was built with the sql, query builder option. My form worked great and I could add or change anything I wanted to. But I had to have a way to keep track of price changes so I add a table. Then I had to use a make a query...

response to pat harman Because what I have is a main form with a list of parts. Beside this list of parts is a total on hand which the main forms recordsource calculates. The second form that is opened allows the inventory to be updated and after it's updated I need the correct total on hand...

I have a subform that after update, requery's the main form. Can someone please tell me how to write code to relocte the main form to the record it was at before the requery? Thank you in advance

Thank you Nouba this works perfect:)

same problem I am trying to accomplish this same task for this reason. My mainform is a continuous form that I need to be able to view the total on hand amounts for each record. then I have a subform that does the individual calculations. But if I don't store the values in a table then the...

I have an unbound form that I use a combo box to filter records. When the form is opened it shows all records and the combobox is empty. Can I set the value on of the combobox to the first item in the list and filter it on open.

I have a search form that I would like to add a feature to. The search form has a textbox that queries the results of the search form. Upon close I would like to save the value of this textbox. Then I want to add a 5 line listbox to the search form that can display the 5 most recently searched...