Search results

George... You are correct, how would I go about setting up a many to many relationship in this example?

The macro issue is big. I have also found another issue. If you have a form with a tabs, and the tabs are set to "transparent" so that they pick up the background of the form, for me what it did was show the background of the background. Not the background of the form itself. Very weird...

I actually have two types, I have site and location. Location being the physical placement, IE basement room 1a, where site is Norwalk Building. So I know I will have a minium of two sites per location. So yes, I will have many sites to one location. IE Location: Norwalk Site: Basement...

This is what I ended up doing. Let me know what you think. See attached.

Not all items will have a Mac Address or IP Address, They all will have a serial number thou. Hence the reason i was thinking about having this table: ComputerID (Type of computer) LocationID (Location of the Computer) IpAddress MACAddress SerialNumber

Instead of repeating the serial numbers, ipaddress and mac address could I setup a table for each one of those? SerialNumbersID SerialNumbers IpAddressID IpAddress MACAddressID MacAddress Or would you put those in one table ComputerID (Type of computer) LocationID (Location of the Computer)...

Setting up a database, need some input Hello all.. I am putting together a database that will log the items that are at a location. I am looking to log the following: Location Phase Now for the rest of these items I can have more then one at each location. IE Location: X Phase: II...

Brian.. With a little more tinkering I was able to get it to work. Thanks a bunch!

Brian... I put in what said in the criteria and I am getting the following error: "Data type Mismatch in criteria expression". I checked the fields are set to date just to make sure.

Brian.. Yeah I know.... This is the only one I could find that was related to what I needed to do. Thanks for the update and I will let you know how it works.

Brian.. I tried what you mentioned and it didn't work. I inherted a database that has two fields: DateFrom and DateTo. I put the <= SelectedDate in the DateFrom >= SelectedDate in the DateTo Both are on the Criteria Line. Is there something else I should be doing? I tried this...

Missingling Thank you, that is just what I was looking for.

Brian.. Thank you very much~!

Hello.. This I think is easy, but I can't put my finger on it. I have a table of processes 12 of them. In the query I have them by date. What I want to do is to be able to show all 12 processes even if there is no info in them. I have a completed button, but if there is no info in the...

I actually took that form out of the tabbed part and made it part of the regular form. So I think that is going to take care of my problem.

Yes it is still broken. I have the subforms in a tabbed form.... I can't get the update form to requery the combo box...

Ruralguy.. Thank you for the requery on the getfocus, worked like a charm for me!

I looked up the control, at least I am hoping I did.. tabctl26 I put that in the mysubform area and the code turns red... So I don't think I did it correctly. forms!frmEventMainVer2!tabctl26.form!cboEventTypeVer2 'Me.frmEventSubForm.Form.cboEventTypeVer2.Requery

Ken.. I have the following for the sub Source Object: frmEventSubForm Link Child Fields: EventID Link Master Fields: EventID The subform is in a tabbed environment. I forgot to mention that.... Thanks

Hope the title makes sense. I have a form with a subform (frmEventSubForm). I have a control on the frmEventSubform (cmdAddEventType) that opens another form (frmEventType) so that the user can update the event type. The combo drop down I am trying to update is cboEventTypeVer2 on the sub...