Search results

Thankyou again for your input, I must have put the quotes in the wrong place! I can format the date and time strings earlier in the code at initial capture, using the octothorpe?

Thankyou for your suggestion but this captured the string name in the record. i.e. '& strHistory &' here is the actual code: sql = "INSERT INTO tblHistory ([Date],[time], UserAdd,History, ProjectID) VALUES ( " & dDate & ", " & tTime & "," & blnUserNote & "," & strHistory & "," & strProjectID &...

thankyou, I will try that

Hi, I am using an SQL statement to insert a 'User Notes' string into a record in a table. However, if the strings contains a (; semicolon) or (' appostraphe) it messes up the SQL. I put this into the onKeypress event to try to capture/combat it.. If KeyAscii = 59 Then MsgBox "Prohibited...

Thank you...

Hi I have a simple form with a single unbound text box which captures a 'user note' string and theoreticaly could be null when the command button 'on click' is fired i have put the code: If Me.Text1 = Null Then GoTo cont: ' ' ' ' more code here! ' ' ' cont: MsgBox "No User Note Entered...

had one of those 'cant see wood for trees' moments!!!

Thank you once again RG!

Hi, I am trying to use an 'INSERT INTO' sql statement to write values to a table. I sucessfully used this statment in another part of my database to write a new record. I have copied the code and substituted the values, fields and relavent strings, but now i am getting a syntax error. The...

thanks Bob... will do!

thankyou for the hint: syntax is : DoCmd.SetWarnings (off) thanks again...

I have just created an append SQL string that adds a new record, sql = "INSERT INTO tblAncilleries ( ProductID, PartNumber, ProductDescription ) VALUES ( " & strProductID & "," & strPartNumber & ", " & strDescription & " );" DoCmd.RunSQL sql How do I suppres the dialog box - see jpg? Thanks

thank you for a fresh way of thinking and helping me solve this..!!!

thankyou will try it out...

copy and paste all your 'if statements' into the 'on current' event

I am trying write to a table the resuts of a selection from a combo box using the following SQL. can anybody please help me with the correct syntax for this as I cannot get it working, and it's throwing up a syntax error. Thanks Dim sql As String Dim strPartNumber As String Dim...

I found a sample database that allows you to resize on the fly... not yet tried it out yet... http://www.access-programmers.co.uk/forums/showthread.php?t=112753 will try to implement this when i get time...

Hi I have a form with a subform, the subform is in datasheet format. How can I populate the underlying table of the subform with the data selected from the combo box on the main form? basically each selection from the combo writes a new record to the subforms table. I can capture the data...

Thank you..

Hi, I want to open a subform programatically with a 'linkcriteria' filter. However, What i am experiencing is just the subform opening without the main form. How can I open the subform on the appropriate record and the mainform as well, as one?? Thanks