Recent content by markjenkinsrf

Roku: Thanks again for your input. I used some of your suggestions to solve this problem. Main issue was after opening the 2nd form based on new criteria, CBSite and CBLocation, the query was no longer matching the 1st form opened. The only reason to open the 2nd form was too change to a...

Roku Here is the Layout Query SQL from my DB SELECT ChannelBank.ID, ChannelBank.CBSite, ChannelBank.CBLocation, ChannelBank.CardLocation, ChannelBank.InternalCard, ChannelBank.PortNum, ChannelBank.CktNum, ChannelBank.T1Num, ChannelBank.ChanNum, ChannelBank.TermLoc, ChannelBank.TermBlock...

Roku: Thanks for the response. The Allen Browne (my misspelling the first time) seems to be the defacto method of of creating multiple instances of the same form. It uses Collection method to keep track of all the open forms. And it's working fine. I think your thinking is correct, need to...

I am trying to open multiple instances of the same form, using the Allen Brown method. I have a master form that contains the Brown prorgamming, which will sucesfully open many copies of the desired form. This form called Layout, uses a query, LayoutQuery, for its Recordsource, this query has...

I agree it's a messy form, huge number of textboxes. It does work if I use all 4 criteria, but not 2. I think it should work with the 1st 2 criteria built into the query, but I think the query is not updating before the textboxes are searching for their values. I need to figure out how to make...

I have some questions concerning the use of Queries and Dlookup. I am creating a db that stores the settings of a type of telecomm equipment known as a channel bank (CB). Cb’s have lots of variables that can be programmed and I am trying to keep track of these in my db. The CB is question has...

High all, I'm a new member from Portland Oregon, USA. I am normally a RF engineer, but have been creating a db in Access to keep track of telecomm gear for Utility customers. I've done some Access programming around 6-7 years ago, and have returned to it recently. Amazing how much you forget...