Search results

Fantastic, got it straightened out using your info. Thanks Again Minty!

So now I'm trying to add a third combo box and set it's row source based on the other two. [Colorant_Change_Time] is date/time format [Colorant_Change_Date] is date/time format [Press_No] is numeric "SELECT [Colorant_Change_Time] FROM Colorant_Lot_Changes WHERE [Press_No]=" & Me.Combo0 & " &...

Thanks to all that replied. I used Minty's solution and that worked. Thank you so much Minty and thanks for the tip Mark!

Can someone tell me what's wrong with this? strRowSource = "SELECT [colorant_Change_Date] FROM colorant_lot_Changes WHERE [Press_No]=' ' " & Me!Combo0 & """" Me!Combo2.RowSource = strRowSource [colorant_Change_Date] field is date/time format [Press_No] field is numeric format I'm getting...

I'll take a look at this. Thanks for responding.

No, not all changes occur through forms. That's is why I'm looking for something in the table design.

It's Access 2010. All I want to record is a date and time the record was modified. Don't care about user. Don't need to know what was changed or If they delete. Just if the record was modified/edited. Thanks for responding!

Is there a way to have a modified date field in a table that would update any time a particular record was edited in any way? I have a backend with several front ends linked to it and want to know whenever someone changes data in any of the fields of a record. Is there a way to set something in...

Here's an image of my query if that helps.

Dates are entered in one table "Silo Changes" to show when a machine has been changed to a different silo containing raw material. The other table "resin_lot_change" lists the silos along with the raw material in the silo and the date that silo switched to a certain raw material. I want to...

users are picking a date on a form that finds the matching record in the table. I have a sub form that's based on this query to show me any records that match the date selected or greater then the date selected. That works fine. I just need the query to also return the last record that was...

No. It looks at some fields on a form and uses a date field. I get what I want except I need the next oldest record (previous) that was entered. SELECT resin_lot_change.silo, resin_lot_change.resin, resin_lot_change.resin_lot, resin_lot_change.Resin_lot_date...

I'm sure it's been posted before but I can't find it. How do I find the previous record in a query using the autonumber field? Thanks in advance to anyone who helps!

Thank You pbaldy! Your code worked. I appreciate you taking the time to answer. And to spikepl. Sorry if there was a misunderstanding.

I'm sorry, but if you notice my second post I wasn't sure what Paul was saying. Then you chimed in with my tables not being setup properly. I now realise that Paul had altered the code so I will give that a try. Chill out.

:banghead: That's true. But I'm also using this particular Access file in a noconventional way. Instead of pointing out the obvious, how about an answer to the question which is: Is there a way to use a variable in an SQL statement something like my sample?

Sorry? I don't follow what your saying.

Is there a way to use a variable in an SQL statement? Something like this: dim mysql1, newname newname = inputbox("direction on what to do go here?",,) mysql1 = "INSERT INTO FinalAll SELECT newname.* FROM newname;" DoCmd.RunSQL mysql1 Where newname would be a variable assigned from an...

Yes, That worked. Don't know why I didn't think of it myself. Thanks so much for responding!

What do I use in VB to set a date combo box to nothing. In other words I want the combo box to be blank after an update event. This does not work Me![Combo2] = " " I get an error "the value you entered isn't valid for this field" Thanks for any help!