Search results

Hi Guys, Right I have a macro that creates a new record then closes the form back to the main menu. Now I would like to change this a little, so it creates the new record, then opens another form pointing at the record that has just been created. So far it runs: GoToRecord - New Close...

Hi Guys, Is it possible to conditional format a row, or even use VBA or something to match a condition and conditional format a certain cell. For example: Product Name Stock 19 Inch Monitor 66 24 Inch Monitor 59 Microsoft Front Page...

Hi guys, I have a macro that inserts a new entry into the database, then closes the window. Now this is done by a macro, but what I would like is when the form closes, the main windows gets a refresh, but I cannot figure out how to get the main page to refresh without using VBA - is this...

Hi Guys, Trying to update a table [WR] with todays date where the text box on the form = ID closesql = "UPDATE [WR] SET DateClose '" & Date & "' = WHERE ID = '" & Me.ID & "';" DoCmd.RunSQL closesql Pops up an error message saying there is SYNTAX error in update statement, but i...

Hi Guys, Trying to figure out what im doing wrong here, I have a value from a record that I want to add to a new entry when a button is pressed... Now ive got the value into variable, and I know its there as I have a messagebox pop up to check, but when I try and insert the value into a new...

Hi Guys, Right I would say i need a bit of help with this one - I am quite new to VBA, but have used access DB's for a while now - but i program in other languages so can get my head around things once im shown. Anyway, I have a database that I have setup, and is mostly working, apart from...