Search results

Umid I probably should explain that the umid is just a reference to the unit of measure table so I don't have redundant info. For instance: umid unitofmeasure 1 = each 2 = box 3 = lb. So the umid should follow the cost where ever it goes...

Sorry everyone I have two relevant posts going on. Please refer to this post. Sorry but I don't want to drag other problems into this post. Thank you Jon K for helping me with the max date 2 query method, this does exactly what I want. Other relevant thread

Pat Harman... I have taken what you have said line by line and this is what I have come up with... 1. UID should not be in both the parts and cost (and cost history) tables unless it is part of the primary key of one and part of the foreign key in the other. -If you are referring to UMID...

Confused I appreciate the response but I don't think that will solve my problem. I know I can use queries to pull the latest not future cost of a part and display it in my frmpartssubform but then the form becomes uneditable. I tried using queries to filter out the current cost of the parts...

One More Thing This db is driving me crazy. I incorporated a tblcosthistory. Which worked fine until I realized that I couldn't change the effective date of a price change. The problem I have is this: I need to be able to change the cost of a part from the frmvendors. However the price...

Thank you Jon K Yes that helps, I was unaware of the purpose of the where function. Every thread I read was only about the max function. Thank you very much.

I can't seem to find any threads pertaining to future dates in queries. I have attached a db that I need to have the query show the most current date that is not a future date. I tried using the max function but I am getting multiple records. I am not understanding the other threads about...

Could someone please look at this db and tell me how I can possibly make the subform pull only the latest price that is not newer that todays date. I know I can use the max function in a query but then the subform becomes uneditable. I need the subform to be editable. I thought about storing the...

Just to clarify I am have problems with the takenby and approved by fields on my report. Just run the report and you will see what I mean.

Could someone please take a look at this db and tell me why I am having the problem of the report showing id values instead of the names related to them. I have tried everything I can possibly think of and I must be missing something very little. Thank you in advance.

Thank you Thank you for all your help. I will get reading.

Question I don't mean to sound dumb but where is the Access VB help section you are referring to. Is it the same as the help section in Access xp?

This demo works Your demo you posted works I am not sure why mine won't. One thing I noticed on your demo that I need to work differently though is I only want the command button disabled if all three text boxes are null. I still don't completely understand vba so I am not sure how to change...

I've tried both I have tried both spacepro and billyr suggestions and something just isn't right. It's like the oncurrent event isn't working on either one of them. Maybe it's just me. I have posted the db if someone could take a look I would appreciate it. Thank you :confused:

I am stumped on how I can enable a command button while typing in a field I have frmunits that has 3 fields Year, Model, Vin#. I want the cmdwarranty button disabled unless there is something entered in on of these boxes. I currently have this If Not IsNull(Year) Or Not IsNull(Model) Or...

Here is my sample I have tried everything I know, which isn't much. I understand what you are asking and yes I tried doing the calculation in the defaultvalue and the controlsource but don't know if i did it right so it may work I don't know. I have posted my db for you to check out if you...

Calculated field on subform problem I have a frmOrdersSubform which I use to enter order details ex. order date ship date productid currently the form uses a sql string as a recordsource. I calculate the 'amount due' in qryamountdue however I can't seem to be able to add this field to my...

Thank you I thought I had tried doing that but I must not have because it did fix it. Thank you again.

Please help... I have a form that seemed to be working fine and now everytime it is opened, it is filtered. However all the properties are set to no filtering and I have tried erasing all the code behind the form temporarily and it still filters on its own. I am opening the form from the...

i am really sorry Thank you ChrisO for pointing out the obvious. I guess now would be a good time to take a break. Yes I did change the form I was rearranging the form and must have accidentally erased the textbox. Thank you Nouba for the information I will take all the advice I can get...