Search results

Can we please get a suggestion on how to create a query to update the same item from two different tables? The second table has four choices, but has the SAME COMMON NUMBER? We do not want to again enter the same COMMON NUMBER in the second table again. Thank you. Nicole

P.E.F.E.C.T., 100% Thank YOU arnelgp

Thank you for sending us your database, but we cannot open it because of the "Unrecognized Database Format" message. Could you please send us another database. Thank you very much

The BLANK TEMPLATE is used for the user’s research and is then completed MANUALLY. The updated research report data is then entered into the volunteer's database. Once we have help with the code, I will create more templates for our other research projects. We do not want to use a Word...

Thank you for your question, mike60smart.

Please open the database and use Ctrl + E to open up the report, that we would use or look at the report => Print_4_Pages. The actual detailed report will be used for data entry after printing and we prefer not to use a Wor Please open the database and use Ctrl + E to open up the report, that...

Thank you GP George for your question. The currently Macro previews the document and then 2 copies are printed, while we would like the Macro to preview the document and than print 4 copies.. Nicole

Could I please get a code suggestion to preview a report and then print 4 copies using the Macro = Control + E. Your suggestions are appreciated. Nicole

jdraw The volunteers had taken the data from a web sheet that we had received and a bad character was picked up. Now we enter the data into notepad and copy the data into the database.

Thank you all for your suggestions. We now enter the names in a text document and then copy it to the database. Thank you Marylyn

Thank you for your suggestions. Would using a filter such as below help to overcome our problem and if yes would the code be placed in the Table's Field or on the Form? Is Null Or Not Like "*[!a-z OR "" ""]*" Thank you Marylyn

Could you please tell me how to correct the sorting in our Access Database of Contacts / Companies? Thank you Marylyn

Thank you cheekybuddha for your note, which I appreciate. I was trying to find a solution to the reports the Charity needed completed by Dec 29th. Enjoy the holidays. Marylyn

Thank you Gasman for your suggestion, BUT for some reason they do not work on the new Access 2003 form we tried to create. We will go back to using an OLD form that works. Your suggestions are appreciated. Marylyn

Thanks Bob for your note about the cross posting, which will not happen again. I / we are under a pressure at the charity as all of their reports have to be completed by December 29th and little things like changing the field name from Yes to No are slowing us down. Regards, Marylyn

= = = Thank you The_Doc_Man for your comments. We are volunteers at a charity helping to run their office. The code that we tried to transfer to a new form does NOT work, while it does work on their OLD forms. So I will use the old forms. Thank you, Marylyn

Thank you Bob for your suggestion, we have tried to use your suggested code in our Access 2003 database without success. The error message that we get is // Run-time error’3144’: Syntax error in UPDATE statement. = = = = I am trying to; In the Field Investigate, change from Yes, => No or In the...

We have been trying to correct the code in this Access 2003 form without success and continue to have a syntax error. Any assistance will be appreciated. Thank you Marylyn

Uncle Gizmo thank you for the Link. Nicole

Thank you GPGeorge for your suggestion which we entered as below, but we received an error when using your code. Dim strSQL As String strSQL = "update Investments01_tbl" & _ "set investigate = 'No' " & _ "where Investmentl_ID in (SELECT Investmentl_ID from (" & Replace$(Me.RecordSource, ";"...