How can I add a new line (record) to the .tab file by exporting data from FM 5.5 without overwriting the .tab file.
I would like to create a log file which will show all records created in FM even they were deleted later.
Can I do it?
Your help will be appriciated.
Thanks.
Why doesn’t this line of code work?
Do Until RsMath.EOF
CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=" & RsMath.Fields(“photo_blob”) & " where PhotoBlobTable.ssn= " & RsMath.Fields("SSN")
RsMath.MoveNext
Loop
PhotoBlobTable.photo_blob...
Why doesn’t this line of code work?
Do Until RsMath.EOF
CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=" & RsMath.Fields(“photo_blob”) & " where PhotoBlobTable.ssn= " & RsMath.Fields("SSN")
RsMath.MoveNext
Loop
PhotoBlobTable.photo_blob...
Why doesn’t this line of code work?
Do Until RsMath.EOF
CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=" & RsMath.Fields(“photo_blob”) & " where PhotoBlobTable.ssn= " & RsMath.Fields("SSN")
RsMath.MoveNext
Loop
PhotoBlobTable.photo_blob...
Why doesn’t this line of code work?
Do Until RsMath.EOF
CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob" & RsMath.Fields(“photo_blob”) & " where PhotoBlobTable.ssn= " & RsMath.Fields("SSN")
RsMath.MoveNext
Loop
PhotoBlobTable.photo_blob and...
I need to create Stored Procedure using Table Name
and Field Name as variables
If same one knows, please, help me with syntax.
I would greatly appreciate your help.
I need to create Stored Procedure using Table Name
and Field Name as variables
If same one knows, please, help me with syntax.
I would greatly appreciate your help.
I need to create Stored Procedure using Table Name
and Field Name as variables
If same one knows, please, help me with syntax.
I would greatly appreciate your help.
I have two Access dabeses, inside one of them I have access report and I need to connect second database to that Access report in the first database. If anyone knows
how to do it or give me reference on what to read I would greatly appreciate your help.
Please help me!
I have a main report and 3 subreports and all 4 reports run off of separate stored procedures. BUT they all require the same parameter to run. Currently, I have 4 parameter prompts to run the main report and the 3 subreports and have to select the same parameter 4 times.
From...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.