Search results

Hi, for this issue, all queries using table names to update will not work, I can say this is not the problem because my other insert and update queries are working, only this one isnt ='c I have tried to recreate the table and build the query on the query builder tried to run the append query...

Hello, yes this should generate an email, and at the same time I would like it to save certain information on a table with this query: Dim sqlupdpbtreas As String sqlupdpbtreas = "INSERT INTO tbl_pbcntctmissebill ( entryid_cntctmissebill, BillAmount, SubmittedbyAP ) SELECT...

Hello, I am not getting any errors :o

Hi everyone! Good day! reaching out for help as I can't seem to make the insert query work. ='c I have checked everything, this query is within a VBA code, I checked this on the query builder and it works it just does not work within the vba. It is supposed to be saving data in a certain table...

Oh I see... Because I would need to have the Field 2 to always have values though... So query is the only option

Do I put Nz(field2, field1) to the Setfield of the Macro?

Field 1 should never be changed, Field 2 is just a copy of field 1 and may change at some time... I don't want to do an update query for this as much as possible, I would like to have the field automatically populated as soon as records are added...and in the future users can change field 2 if...

It is somewhat duplicating, I just need to retain the original value of the other field and create a field which would carry the same value but there may be times that the value may not be the same anymore so users need to change it... I hope my explanation is clear?

Hello, yes I tried it, but I would like it to get the value from another field on the same table, does not work on the default value property...

Hello everyone, reaching out again for help :o:o:o I have a BeforeChange Data Macro SetField to set a default value on another field. Basically I just want the field to have a default but would need it to be editable, it should be able to be changed as needed. However I found that once I set...

Yes! That's it! The entryid_hist is set as text in the tbl_pbhistory. Thank you so much! I don't know what I would do without you guys and this forum! I hope I can give back to you guys someday... :o:o:o

Awww thanks for this, however now I am back to the initial error I was having which is the data type mismatch in criteria expression. ='c I checked and the Note field is set a text. I am not sure what else could be the problem...

Still having the same error: "The Microsoft Access database engine cannot find the input table or query "False". Make sure it exist and that its name is spelled correctly"

Hello, it is printing this error: "The Microsoft Access database engine cannot find the input table or query "False". Make sure it exist and that its name is spelled correctly."

Hi all, I have posted the sample DB I hope you can look into it, this is driving me nuts..... ='c Click on any number link > Select entry by clicking > Click "Payment Inquiry" Button. Upon clicking send: Generates Email draft Saves data to tbl_pbhistory Need to update the field Note for...

Hello, I checked that but have not tried it yet, it looks a little complicated for the task that I am trying to do, I apologize as I am unable to understand complex codes, it will take me some time to comprehend this... :banghead::banghead::banghead: but thanks for this, might be handy in the...

Good day! Thanks for the explanation, I was thinking concatenate is the joining of two strings, I thought that what I am doing in this query is getting the values from the text box so I never thought of it as concatenating. I actually tried that before and what I did is: sqlhistnote = "UPDATE...

Yes it is a control name, I apologize I am not sure what the concatenate thing is, can you enlighten me?

Yes that is the correct spelling. I got another update query as well that references form control and it works fine. Dim sqltreas As String sqltreas = "UPDATE qry_pbworkflow SET qry_pbworkflow.[FollowUpDate] = #" & ffupdate & "#, qry_pbworkflow.[ResolutionStatus]='In Process' WHERE...

Hello, I apologize here is the code: Dim sqlhistnote As String sqlhistnote = "UPDATE tbl_pbhistory SET tbl_pbhistory.Notes = [Forms]![frm_pbtreasreachout]![nots] WHERE tbl_pbhistory.[entryid_hist] IN (" & Replace(SelectedList, "|", ",") & ")" Debug.Print sqlhistnote CurrentDb.Execute...