Search results

Thank you. Crystal

Thank you Professor Pat for your suggestion and the code below seems to work. SELECT Investments01_tbl.Stock_Name, Investments01_tbl.Currency, Investments01_tbl.Trade, Investments01_tbl.Investigate FROM Investments01_tbl WHERE (((Investments01_tbl.Currency)="CAD$")) and...

Thank you for your question Plog We would like to print a report for all Stocks which are either marked Purchased or marked Yes, if the Currency is CAD$. Crystal

Thank you for your question CJ, below is what I have tried. SELECT Investments01_tbl.Stock_Name, Investments01_tbl.Currency, Investments01_tbl.Trade, Investments01_tbl.Investigate FROM Investments01_tbl WHERE (((Investments01_tbl.Stock_Name) Is Not Null)) OR...

Person needed to update a Web Scraping Program using Beautiful Soap. I am not sure if this is the proper forum to post this project. Nicole

Could I please receive assistance with this Query with 4 criteria’s? If Stock_Name “Is Not Null” And if Currency is "CAD$" and or if Trade is "Purchased" and or if Investigate is "Yes" Then all of these matching records will be printed. Thank you. Nicole

Thank you Doc Man, Pat and CJ for your suggestions. I will place the Access 2007 databases onto a separate Computer. Can the Access 2007 database be linked to the Access 2003 data files? Your suggestions are appreciated. Nicole

Can we have our Access 2003 programs and our Access 2007 on the same computer? Or should they be on different desktops? Thank you. Nicole

One of the students in our office made some changes to our Access 2003 Database and now we get this error message when we try to modify a form. "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later." Your...

Jdeaw // P.E.R.F.E.C.T. Thank you for your help and your suggestion works. As a habit I have always used Null. Nicole

Thank you June7 for your suggestion which I have tried, please see the attached updated database. The reason I have used the word “Grouping” is because my boss would like to see our daily report for all Records marked YES and all records marked PURCHASED. Previously, we printed two separate...

Could we please receive a suggestion on how to customize this query so that we can print a custom repot? A = if Investigate = Yes and B = if Trade = Purchased Then a report would be generated for those records. It is possible for a record to have both Yes for Investigate and Purchased for...

We / I appreciate your assistance in helping us solve or problem. Would changing the field from a Comments field to a field size of 250 eliminate our continual errors? Nicole

Thank you for your response. The table that we use is 19,268 KB and many of the fields and data have been removed from the uploaded file for an easier preview. Only one volunteer has access to this database at a time. The comments are part of a data entry sequence and the person would only be...

MsAccess 2003 periodically shows the following errors in our two Comments fields; ######## or Record Is #Deleted The table we are using has 36 fields of which 2 of the fields are comments. The above error message occurs occasionally. when entering data through a form. We weekly run these...

P.E.R.F.E.C.T. Majp, I / we appreciate your suggestion. Crystal

Can I please be advised how to correct our rounding error? When we copy the value (using K) in A to the field B the value gets changed. Could I please be advised as to what I have done wrong? Thank you. Crystal

Thank you all for your suggestions I enquired from my friends on what they liked and tried the programs in the following order. LogMein / TeamViewer / RemotePc and am now using RemotePc which is currently meeting my requirements. https://www.remotedesktop.com/ Nicole

Thank you for your suggestions.