Search results

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...

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...

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!

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...

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!

Hello All! I want to open a form that is filtered by the selections made from another form with three combo boxes. I have this so far to filter from one of the combo boxes how do I filter using all three combo boxes. wclause = "[date] = #" & Me![Combo2] & "#" DoCmd.OpenForm...

Hello all! Can someone tell me why I would get "data type mismatch" error for this string and what I need to do to correct it. Trying to use it as a row source for a combo box in Access 2010 strRowSource = "SELECT time FROM [silo changes] WHERE [date]= """ & Me!Combo2 & """" Thanks!

We are migrating from Office 2003 to 2010. I opened one of my 2003 files in 2010 and noticed that when I have a report Maximized in preview mode the close button in the upper right hand corner disappears. The properties for the report are set to display this button and the min/max buttons. But...

My company is upgrading from Office 2003 to 2010 in a couple weeks. I have several Access databases in use being shared on our network. I have forms, reports, querys, macros, VBA code and a lot of time spent making them user friendly. Are we going to have any problems running the 2003 files in 2010?

Comparing two tables in a Query Good Evening All! I have 2 tables structurally exactly the same. Named "First Check" and "Second Check" used to take inventory. I have them joined in a query by an "item number" field. Each table has a "quantity" field. I need to compare the 2 tables and find...