Search results

Rhett, I am working on it also. I will let you know if I figure this out. Thanks...

Rhett...did you ever get your issue resolved? I am having the same problem, where my query is bringing back duplicate rows. I have a table that includes 3 options in one field. If one employee has two or three of these values and a value from a field in another table that I am joinging, the...

Ansentry, actually, the file I sent was the wrong one. I had a few that I created as I was testing different ways to make this work. I have actually, been able to make the auto populate work from your examples. The only thing that I was perplexed with was that in your example, the description...

Hi. Please help!! I've almost gotten a handle on this auto populating. Can someone help me once more in how I can auto populate a combo box with 3 values. Each value will update 2 fields in a datasheet form. So when you select "Apple", from the drop down list, it would autopopulate "Sweet" in...

Hi. I am trying to restore my database back to mdb from txt. Can someone tell me how to do this? Thanks...

Sorry. Wasn't able to attach for some reason. I updated this example the same way I did my original db, but for some reason, now my autopopulating is not working. I'm trying... Thanks for the patience.

Hi. Thanks for the response. Actually, I created SecurityID, autonumber and added primary key. Then, I created another field name, secCatID, as a Number. I linked one of the tables, PSRoles to tblSecurity2 by SecurityID, autonumber to secCatID, Number. Then queried on both. See example db.

I finally got the auto populate to work on my subforms!!! It took awhile, but after closely viewing the database example by Arsentry, I was able to figure it out. Hopefully, for this next question, it will not take me as long. Although, now, I believe I have the basics. However, there is one...

Hi Ansentry, thank you so much for your assistance and input. I am just getting back with you because I have been playing around with the db and comparing your setup to mine. It seems that I have a learning disorder :), as I am not grasping this. I changed my tables to include the personal...

Can anyone help me determine why the fields on a subform would not show when the subform is in view mode? I have had this issue for a few days. I actually deleted and recreated subform. Can my database be corrupt? Thanks for the help...

Ansentry, the main form is called frmEmployees. The first 3 tabs – Hardware, Telecommunication and Security are the subforms in which I am having the issues. At first, all my forms were created from tables. However, I re-created the frmTelecom1 from a select query, qryTelecom and was able to...

Hi Ansentry. Yes, my tables were a mess. I did clean that up and make sure what was used for emplid was written the same way for the all the tables. And made sure I had the primary keys set. I did not use emplid for all of my tables because there was only a need to add emplid to main tables...

FINALLY!! Believe it or not, but I finally was able to make the auto populate work. I joined two tables to create a select query. I created a form from the query and then on the field that I wanted to autopopulate, I pulled in the select query for the row source, just as was suggested...

Hi. I linked the tables (by employee id) that I was using as my subforms to employee's table (mainform). Created query and selected fields from all the tables. Ran the query, but did not get any employee information. So, I knew something was wrong there. However, I saved qry as qryEmplAll...

Jibbadiah, thanks for the input. If you had a chance to look at my db, you will see that I have all tables attached to forms. When you say use queries, instead of tables, am I just changing these tables to queries? Thanks...

Hi Neileg, thank you for the feedback. This is new to me so bare with me, when you say "object name" should not contain spaces or punctuation, are you referring to field names? And from which form? Also, for the queries, am I just linking tables together in a query for the forms? What about...

OK, I figured this one out. ansentry, if the offer still stands, please see attached database. I actually chopped it up some by removing a lot of the mainform fields. I thought that would make the database more compact. Shows, how much I know about Access - huh. OK, On the mainform...

Hi any suggestions how to get this you, guys. I have exceed the amount to load, 485. I have tried deleting some of the forms and tbls. I am using powerdesk to zip. Thanks...

Hi, I have been trying to download file all morning. File exceeds forum's total. Still working on it. Thanks...

You're correct, neileg. So, I def did not go that route. All my lookups are created from select query. Thanks, for the info.