Search results

Thanks, but I don't think that's the answer I'm looking for. I am attaching a sample db to show you what I mean. Please open the sample before continuing so you can see how everything is set up. On the frmPUC, you will see there is a ClosingAtty field that is a drop-down. This comes from the...

Thanks to both of you. Not a vb programmer...sigh...need to learn when time permits

I am so confused and need help! Creating a properties listing database for a real estate client. Have tblPUC (properties under contract) and another tblAttorneys. In tblPUC there is a lookup field called ClosingAtty which is looked up from the tblAttorneys in order to create a drop down list...

Sean, Thank you so much once again! I'm the student, you're my teacher. Once I learn about something I don't forget it, so I'll be using this string expression again. I have just never learned about the Carriage Return and Line Feed codes before!!! Never taken on a course on Access or VB, so...

As per client request.... I have a form that has his closing attorney information in it (for real estate transactions). The form has your general atty name, firm, addr, city, state, zip, phone, cell, & email fields with a few other fields. The name of the firm will be linked on another form...

Same problem here...but client has to have lookup field. However, it is the field with the lookup that I'm posting the criteria in. This is a real estate properties database and the Offer Status field is a lookup from the choices I created in the Offer Status table. When I try to run a query...

My client wants the email field in a table to automatically open his gmail account and post the email address in the To: field, so he wants the field to be set as hyperlinked. I don't think there is really any way to do this, but if there is could someone please enlighten me on how? Thanks in...

Thanks, yes. I have been working on this database for the last 15 hours. I'm getting bumfuzzled and that completely slipped my mind!!! Such an easy solution! Sometimes I try too hard to complicate things. Thanks for your help!!!:o :)

This is driving me nuts!:banghead: Records are exported from Excel to Access. Excel contains formulas for up to 200 records. (This is updated daily with data so no way of knowing each day how many rows with formulas are needed). I have two worksheets - GAMLS, where the original data resides...

Got it! Thanks! Worked beautifully!

I have a database concerning real estate. Many objects. One table (and subsequent form) is information on properties. Another is notes on that property. The reason I didn't simply add a Notes field to the main properties table is that the client wants a date for each note. So I created...

Thanks for the info!!! Very helpful!

I built my switchboard and its items from scratch by using Forms. Could NOT get the Switchboard Manager to work like I needed. Now I'm working on building the user permissions and logins. Another question, I may have to ask in a different forum... This DB is going to eventually reside on...

Using Access 2010. I have never had to give permissions before so I'm completely clueless. All my Chrome searches have produced answers completely over my head, usually involving VB, something I'm very newbie at. I need to have different users have rights to different objects (basically...

Thanks Pat. That's an option I didn't think of. I may have to give that a try, too, because it would be less work than creating my own switchboard, although I already have that done. Still, there will be other dbs I'll have to create and this is good to know!

Hey Paul, I solved my problem by creating my own switchboards via forms. Actually found that while it was a lot of work, it works a lot better and gives me more control! My first thought using the wizard was to just hide those labels by making the fill and text colors the same as my...

Thank you, Paul. I could do it in earlier version, so I don't understand why I can't in 2010. Seems like 2010 took a lot away from the general Access programmer, not VB. There's a work around I can do, or I may just possibly create from scratch. :) Lucy

I swear I'm stumped. Created a switchboard for menus for users. Have done this thousands of times. Using 2010 now. When the switchboard is created, it has pre-set labels in the form header [label1, [label2, etc. These labels do have text in them [Just me database] (based on database name)...

I'm completely new to VB but see that I'm going to have to learn it in this version of Access (2010). Older versions you could basically write the macros as you wanted them but now you're limited to the macro commands in Access. Sigh. Thanks for your help! I've been developing databases for...

Thanks! Got it! The delete query worked great! Just what I needed. I'm not using code to import...very, very novice level at VB. I'm doing a macro to import the SS then delete those null records. After that, I have to append to another table, but I will include that in the macro also (if...