Search results

  1. M

    insert into a table from a msgbox input

    this inserts the value if i run this querry on my sql server and try to insert 2.54 into the table INSERT INTO [PrototypeDatabaseCafe2010].[dbo].[PriceBasis] ([PriceBase] ) VALUES (2.54)
  2. M

    insert into a table from a msgbox input

    that it the specif database on my sql server with table name and colum name
  3. M

    insert into a table from a msgbox input

    run time 3134 syntax error in insert into statement
  4. M

    insert into a table from a msgbox input

    i tried using that change and now get a runtime error 3134
  5. M

    insert into a table from a msgbox input

    Still trying to take data entered in a msg box i set the value of that text to set price then try to take that and insert it into a sql table Private Sub Command45_Click() Dim SetPrice As Currency SetPrice = InputBox(Prompt:="Enter New Price Base.", _ Title:="New Price Base"...
  6. M

    insert into a table from a msgbox input

    the form is bound to a sub querry
  7. M

    insert into a table from a msgbox input

    thanks for the help so far but still missing how to bound it to a table
  8. M

    insert into a table from a msgbox input

    trying to take what a user enters into a msg box and insert that value into a new record in a table Dim SetPrice As Currency SetPrice = InputBox(Prompt:="Enter New Price Base.", _ Title:="New Price Base", Default:="Enter here") CurrentDb.Execute "INSERT INTO...
  9. M

    vba if statements

    bob thanks so much , work great thanks again for explaining it to me !!!
  10. M

    vba if statements

    Guys if anyone could help me understand why i get stuck on the one record in the sub table and have to hit escape to go to the next line to enter the next record , i dont get any errors with the code but seems like it is stuck in the loop Private Sub Form_AfterUpdate() 'check for delta...
View older results
Back
Top Bottom