Search results

this worked before the way I had it, and I noticed the query wont work because I put date in 1/10/08 and it has 1/10/08 and the time so it doesnt recognize when I type 1/10/08, can this be fixed

This is what I had back when it worked to ask for a range of dates for the report to pull, but it didnt' work either Between [forms]![frmTest]![Test_Date].[startdate] And [forms]![frmTest]![Test_Date].[enddate] I noticed the query wont work because I put date in 1/10/08 and it has 1/10/08 and...

here you go Ok, here is the db, if you open up frmtest and go to properties on Date I put in general date and =Now() in to print out current date and time the test was taken, but if you run my report now it shows empty if I put a test in? It saves in the table but doesn't print the report...

My db was running great, and everyone was using it, the manager I made this db for wanted me to add date/time in the report so he knew which shift entered what, I just had the date in there and now when I add General date so it shows date and time, now nothing shows on my report i think there...

That corrected it, thank you so much for your help

sorry I did write it was linked to event prod but must not of sent, and it is bound to a query telling it to pull the parts in numeric order and it has this event procedure linked to it Private Sub Test_Part_BeforeUpdate(Cancel As Integer) Dim strPart As String strPart =...

ok the control is my combo box

Here is a question: thought I was done,but thats never the case. When I click on a part number in my drop down box and hit enter, it disappears, but if I click on a part number in the drop down and click in the next field it stays..any thoughts there?

way to funny Ken

ok, I think I'm getting more confused if possible, the db in Post 7 is a simple query if all the information I need is in one table, the problem is I need everything in tblTest, I need Type_Name in lkpType, and I need Weig_Submerged and Weig_Dry in tblWeight, that is why I'm trying to link them...

Ken I got your Db and I understand that part and I believe thats what I have, the problem is I need everything in the test table which is in the query and the other thing I need to to link that to the weight table so I can pull in the density (by creating a formula in the report, and I need the...

Thank you so much for your time and help Ken that corrected it, your right I had one too many tables involved. Thanks again and have a great day

Yes, correct as far

I think I know what your talking about but I need the one to four because of the information I need to pull over for my report? is there a way around this? See I need all the information on the test table to pull in, plus the Part type which comes from the form to pull in, and thats why I have...

In my table I have for example part number 123, type B, wgt5 and part number 123,type C, wgt2 when I do the query it says part number 123, Type B, wgt5 part number 123, Type C, wgt 2...

yeah I orginally tried that too, but its still duplicates the records????

I have a query where I want to type in the part number and the begin and end dates and have that information appear. In part number I have [form]![frmTest]![Test_Part] and in Date I have Between [forms]![frmTest]![Test_Date].[startdate] And [forms]![frmTest]![Test_Date].[enddate] It is...

Congrats Bob on the new job and thank you for trying to get me in the right direction with my DB

In my form I have weight, sub weight, del weight and density, I need to take weight minus sub weight and have the answer in del weight, so in my form in the control source I have =[weight]-[sub weight] and it does not show in my table

One confused girl In my Form in design view I have the calcalation in the field, and looking at the form it does the calculation correctly for me, the problem is it's not saving in the table, are you saying it won't save in the table and I need a query?