Search results

I wanted to see if I am doing things correctly or if there is a better way. So I have a new database that I am creating but this particular database requires lots of Join tables because of Many to Many relationships I have had to setup. My question is, would there be any issues combining all...

I think subforms can look really good, its a matter of matching your main form with the subform. If you use the same formats, and also after you add in the subform you mess with the border it creates (I normally remove it) It can make your subform seemless with the main form.

To me it sounds like an Update Query would take care of that for you

This might be best asked in the VBA section, as VBA will need to be used to solve this one. Sorry I cant help much more than that :(

Well that sure looks a lot more simple than what I was trying lol! I will set it up and try some things out later today! Thank you for your help!

So you’re saying to use cascading combo boxes on a form and not to let the table situation bother me. I had a feeling that might be the solution; I just wanted to make sure. So to clarify my second post would work? I spent some time working on the after events but I found it difficult to limit...

Any tips? Do you guys need more information about my issue?

If I was able to get away with it, I would have them write some cookie stuffing code and place it on the following sites. google yahoo microsoft etc If I could get away with it, I think a million USD would be earned in about 3 hours lol.

This is what I thought might work, I think it will allow me to track everything correctly. EDIT: Yah I don’t think this will work as you can pick any site, and any region for that site.... I need to make sure the relationship will automatically track the Region and Sub region for each staff...

Hey guys! So it might just be Monday but I am having a hell of a time wrapping my mind around how to do this. I know there is a way to Keep my database down to only one Staff table but I need to link the staff to three things at this point. A Region, SubRegion and Site. I was thinking...

I dont know why its splits my code tags up sorry about that.

Sorry for the late response, I was sick for the last few days. This is what I found to fix my problem. If fTableRecordCount("tblQualification", "WHERE fk_SiteID = " & strSQL, True) > 0 Then 'a record exists, just open it Else 'we need to create a new one DoCmd.RunSQL "INSERT INTO...

I thought I would get this question, I am working with a bought UI system and it is coded that way... I wanted to see if I can resolve the issue before contacting them. I know access has temp tables of some sort... can they be used to hold the value till I can pass it on?

I thought it might be a good idea to mention that the combo box I need to get the value from is unbound

My issue is that the form i need to get my value from will be closed before I am able to take the value and pass it onto my new form. I wanted to use the following code to move the value but with the form closed thats not possible. Private Sub Form_Open(Cancel As Integer) If Not...

My solution, if anyone ever needs it: DLookUp("StateProvince","tblStateProvince","StateProvinceID =" & [fk_StateProvinceID]) Site address: " & [mainAddrLine1] & " " & [mainAddrLine2] & " " & [mainAddrCity] & ", " & DLookUp("StateProvince","tblStateProvince","StateProvinceID =" &...

Great that gave me what I needed to get google to help out! http://webcache.googleusercontent.com/search?q=cache:fxpCAd5phLwJ:allenbrowne.com/casu-07.html+dlookup+in+textbox+access&cd=1&hl=en&ct=clnk&gl=us&source=www.google.com

I did search but I can’t seem to word what I want correctly for Google to give me what I am looking to do. Ok I am sure this is really simple, I have a form and I want to display the address for a selected record, I have a text box that has the following in it. ="Site Name: " & [centerName]...

This really did help, I get it now.... I hope, I will do some testing :)

Ok I have run into another issue with the same database. I have the Qualification table where I would like to give my users the ability to add in multiple observations. I have a observation table that has two fields: · ObsComments · fk_ObsClassification What is the best way to setup the...