Recent content by Jamz

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

But in datasheet view when you add another text box, it just adds the text box into another column, and not behind another column

Yes i have looked at conditional formatting, but it does not allow you to format one cell from another (as i described above) - Doesnt even allow you to condition a row or column

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

lol - you knew i would figuire it out in the end - everything working spot on :D

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

got it working a different way, a way im more familiar with DoCmd.SetWarnings (False) testsql = "INSERT INTO [Requests] (PO,ProductID,DateDelivered,Notes) VALUES ('" & repPO & "','" & repPID & "','" & repDel & "','" & repNTE & "')" DoCmd.RunSQL testsql...

Hi vbaInet - i see what you are saying there, it probably would have been easier to make the database that way, but this database has already been made and its huge, i'm just modifying it which how its already been made to add in a couple of new features, which is why im doing it in the code...

Im using 2007 mate.

Only this kinda update: rstRequests.AddNew rstRequests("PO").Value = RepPO rstRequests.Update

Any code to help me out? I'm rubbish at thinking for myself, but if someone else puts code up, i can figure out what it does.... Coming from a PHP coding background - quote new to VBA

I was kinda following this guide: http://www.functionx.com/vbaccess2003/howto/addrecord.htm But doesnt seem to insert the data in RepPO

But the table isnt to be updated, a new record is to be created from a record that already exists

Yea for auditing... the loop is becuase each work request could have multipal items - so it loops through the DB to check to see if there are more then one item. I use the rstRequests.Update - but this does not put any data into the field i create :(