Search results

Why thank you, JDraw. Knew how to create and save the image, just didn't know how to get it in here! Learn something new everyday. As you can, this setup is NOT optimal, so I think I'm going to have to go to tabs. Don't have experience with tabs, so I will have to figure out how to link the...

Call me dumb, but I don't know how to post a screen shot

Thanks Simon and Dave. I think I am going to use the tabs for this one even though the client didn't like the way that looked. It looks a lot better than a long string of names in one field, so I'm just going to tell him it's the only way it can be done. He won't know any better and it is the...

Tried that...client didn't like the way it "looked"

Hey Dave! Thanks for responding once again. You've become my go-to-guy! I like the clarification about Gemm, btw! lol This database is obviously teaching me new things that I haven't had to use before. A challenge, but a masterpiece in the end! I have (sort of) come up with a solution, but I...

I have a subformClientOffers on my frmAllProperties. On the subformClientOffers is a field called Outside Agents. This field allows for multiple values to be selected. The subfrmClientOffers is in datasheet view. While the field Outside Agents DOES allow me to select more than one, they...

Is it possible to have more than one subdatasheet attached to a table?

Oh, if I only knew VBA.... I'm so frustrated and at a standstill at what I thought would be a simple operation to extract desired data. I am working on a real estate database and trying to create a query of three tables that I can then use to create a report based on the criteria I provide...

I've searched and can't find an answer. I have a table (tblClientOffers) with a subdatasheet (tblNotes). Works fine. I have created a form of tblClientOffers in datasheet view and placed it as a subform on another form (frmAllProps). I would like to have the subform have the subdatasheet...

I have a subform in datasheet view on a main form. Below the subform are button controls I've added for the user to Search, Add a New Record, Delete a Record, or Close the form. These buttons are specific to the main form. My problem is that once I click into the subform, it won't release me...

Thanks for the suggestion, John. I couldn't find any way to have it open to an add new record mode.

I have a subform for notes on another form. Is there any way for the subform to display with a new blank field at the top for adding a new record? Currently, the user has to enter the date of the note and the note itself. I have them arranged in descending order so the most current note shows...

My ID field is an auto-assigned number. Is there any way to restart the auto-numbering at number 1?

I finally accomplished the task with a bit of a work-around...queried the tables for the info, then created form based on query. Works great!

Thanks for your response mikejay. Unfortunately, this did not work. ?? Should work but doesn't....data relating to PUC stays the same no matter which property is selected. Putting thinking cap back on....any other suggestions?

Real Estate Database Two tables -- tblAll Properties and tblPUC (Properties Under Contract), subsequent two forms -- frmAllProperties and frmPUC. If a property has been placed under contract, then a user should open the frmPUC and be able to select the correct property from the drop down of...

Thanks John...It DID work...I made a typing error!

I did that, but there's something I'm missing because I can't get the data to show in the field. I can add the wiring instructions to that same field on the form where we added the contact information, but that's not ideal. I needed the wiring instructions to show in a separate field from the...

May I ask another question? I also need to get the Wiring Instructions field on the frmPUC. I've tried adding the Wiring Instructions to the query and then setting the column to 3, but I'm not having success, so I apparently still don't know what I'm doing. Can I write multiple expressions...

I want to thank you so much for your help! I guess it was a communication problem...I didn't understand what you were saying until I saw the actual coding. ! I appreciate you writing the code for me. That helped a lot, but with me, I have to see it, understand it, know why I'm doing it and...