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

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 :(

Essencially yes i am, but the database needs to do that, so we can back reference the numbers to see what a product was ordered under - I know its long winded way of doing it, but it works.... kinda

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

Just got it working :D Option Compare Database Option Explicit Private Sub ProductName_Click() Dim Blanket_Orders As DAO.Database Dim rstRequests As DAO.Recordset Dim rst As DAO.Recordset Dim Count As Long Dim ProdID As String Dim db As DAO.Database Dim rs As...

When you click on the "hyperlinked" text - it will return say "24inch Monitor" the products table holds id, and product name. Now the sql searches the products table and finds "24inch Monitor" and returns the id "4" which I then want to populate a variable which i can use further down the...

How do I get the VBA to run the script and just output the value the SQL finds?