Search results

Thank you for your suggestion and after creating a new database and its forms, I am having some problems. The Query returns the results I was looking for. I cannot enter any data using the Form or Query. BUT I can edit data in each of the tables in the query separately. Could I please get a...

Thank you * * * Majp for your suggestion THAT WORKS and which I * * * appreciate. The main table in our database does have 103 fields, so I thought a new table would be helpful. The data that we use comes from MANY different sources and is manually entered into the database. I am sorry but I do...

I do appreciate all of your comments. We are trying to do 4 different comparisons for each of the stock codes at different time elements. Our table”01” currently contains 103 fields, with the Primary Key “Symbol_Stock” I thought that we could create a new table “01K” with the required fields to...

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...