Recent content by RickDB

I have used the following site search engines: Yahoo Search, Google Search, and even gave Zoom a try. The thing is, I am not happy with ANY of them and I know there has to be better tools out there. The problem is finding them! Doing a search for search / search engine / site search / search...

I am trying to pull my information together for printing and also sending attachments. I have a field whose type is set to memo. I have created 2 select queries, one pulls all of the information together except for the memo field, the other pulls the OrderID and the memo field. I then created a...

Yes, I had OrderID in there, I just did a fast copy and paste from another thread for illustration purposes... Thanks You!

Thank you!

I was wondering if there is a comprehensive way to set Outlook appointments from a db? If not, that's what I figured. It's not like Outlook and Access are bundled together into some sort of suite of software where it would be handy for a set of tools that allow you to do such things...

Someone posted this in another thread: But that is not it (at least it is not working for me) When that is placed into the query as criteria, Access changes it to this: [forms]![frmCustomers].[sfrmOrders].[form]![course date]

I'm going to have to send payment for all the times you've helped me out in the past week (if it is of any consolation, the db we use has drastically improved in the past week). The field OrderID is there, and I made a second additional field named txtOrderID in my trial and error run... Yes...

No love on that sample for what I need :confused: It seems some of the most basic, simple things really need to be cause for serious headache when it somes to access. Hopefully 2007 has some improved intuitive tools for implementing these basic features.

I have also tried [Forms]![sfrmOrders]![OrderID] with the same results. Also, I have tried pointing the query directly to the table storing the OrderID, and the query that is the recordsource for my form (just for kicks). All with the same results. Evidently I have a serious misunderstanding...

Hey all, I have been looking everywhere on a search form and its related queries / tables for a missing value / error that causes this pop up: The report opens fine once that parameter error is cleared, and I cannot find what it is refering to at all. Does Access have any tools to help me...

Hello, I am running a append query from a button. In the query, I have set the OrderID criteria to: Whenever I try to run the query from the open form & subform, an Access 'Enter Parameter Value' window pops up. I would like to use this Criteria for many different features in my db...

I need 2 option buttons created individually, as an option group has proven utterly worthless to me for what I need. A simple Yes / No pair that toggle back and forth when clicked. I would use an option group, but you cannot define an On Click Event Procedure on an Option group button, and I...

So is it best to just get over the people who insist on typing memos with caps lock on? :eek: :D

How's it going all, ProperCase has been a great friend in my db, but I was wondering if there is a way to use ProperCase to clean up Memo Fields. I know this will cause problems with proper nouns and such, but has anyone devised code for this? Thanks!

Good, I was afraid someone was going to lay some smackdown on me about normalization... I made seperate table for Quote / Orders because they seemed like 2 seperate entities to me at the time. Thanks!