Search results

Kiwiman That is correct re: code executing on Form_Close. I have another form that opens so I can add additional locations as they arise. When it closes I would like it to requery the box it is associated with. I am trying your suggestion now and I will let you know. Thanks Also. I...

Ok... I tried the link you suggested. I still can't get it to work. Main form = frmMainData Sub form = frmSubComponent control on frmSubComponent I would like to requery = cboLocation Form I close that activates this requery is frmAddLocation I have tried the following: Private Sub...

Do you have any look up tables that you could use to populate the band names etc? IE tblLUBand 1.band A 2.band B etc tblLUVenue 1.venue A 2.venue B This would allow you to use a combo box and store the number in the appropriate field.

Hmmm..... That is an idea I didn't think of. Trying it out now.

Hello all... Here is what I have. A report with various calculations: Here is the layout: YesNoTypeHeader YesNoType txt field TypeHeader Type txt field GenderHeader Gender txt field Count of Gender YesNoFooter Total Females with abs sum Total Male with abs sum Total Adds both up Report...

I found this a while ago.. Hopefully it can help you out. http://www.fmsinc.com/tpapers/faster/index.html

Rich,,,, Thank you very much fo rthe Abs(Sum. Worked like a charm.

Ha.......... Didn't even know I did that... It isn't me, it actually going to that unit. That is funny.... MStef.. Thanks again for your help. R~

Thank you very much...... Trust me I know I have a lot to learn. Hence the reason I am here. Do you think I should start over on this one? Thanks R~ PS, who is DSB?

Can anyone take a look at this? I still can't get it to work.

Hmm.. I took out the cboPhase to try and make it a little easier. I cannot get this to work? Anybody have any ideas?

Combo Box Filter Subform? Hello.. I have looked and searched but still can't find what I am looking to do. I have a form with a subform: frmMainData and frmSubComponent. Each form is based off a different query: frmMainData = qryLocationPhase and frmSubComponent = qryComponent I have...

Ok..... Great. That is what I was looking for. Thank you very much for your help!

Congrates bob.... I know you have helped me out plenty of times in the past and just doing a search I see your posts all over the place!!!!! Well deserved! Thanks again!

Banana.... Ok that is what I was thinking. Do you still think I would need a junction table to tie them together? Or do you think the orginal way I had it would work out?

Thank you both for the input. After talking with my other co-workers on this project, each item, if called for will have an IPAddress and a MAC Address. If you have an IPAddress you will have a MAC Address, not one or the other. On the flip side, all items will also have a serial number, but...

Something like this: tblComponent MainID ComponentTypeID SerialNumber tblJunction ComponentTypeID AddressID AddressComponentID tblAddress AddressID IpAddress MACAddress Something like this?

I don't mind having Null values, but if this is a no no then what would I need to do for that?

Banana.. For this project, everything will have a Serial Number, but not everything will have a MAC or IP. IE ComponentType LCD Monitor Serial Number ComponentType Mac Mini IP Address MAC Address Serial Number

George.. Would you put the IP Address and MAC address in the same table or would you split those out into their own table? IE tblIPAddress IpAddressID IpAddress tblMACAddress MACAddressID MACAddress Or tblAddress ComponentID MACAddress IPAddress Thanks again for your help.