Search results

Thanks for your insights. I learned about relational databases using Filemaker. For some reason I cannot get the hang of how relationships work in Access. It is probably just terminology but I am not comfortable with what I am doing with Access. I will take your advice and reconfigure my db to...

I am back again. Trying to understand the commentary. For everyones info, I do not know enough VBA so I use the Wizard at this point in my learning Since I started this thread I have created a Query that puts the Service and Supplier organized a2z. Generally I am trying to show records related...

Thanks for your reply.Yes, it is unfortunately drawn out. I am challenged for time. I tried to provide meaningful information by striping out my DB and posting it. When I go to the Stratas_F_C (Strata Form Continuous) and put a button within a record I am able to open the Stratas_F document. So...

Pat Hartman. Is that what you do? Shout at people who don't hear you. I read the you are a staff member. You should temper your ego.

WHEN PEOPLE START USING UPPER CASE IT IS LIKE BEING SHOUTED AT. On the other hand, when people use sentence case you feel like you are in a conversation. The administrators should force all formatting into sentence case with underlining for emphasis.

Here is a redacted DB. On the stratas list form hit the button you get the related record. On the Stratas Form Detail in the Contracts section - I cannot set up a button to take me to the related record. The data resource is the Contracts_T. Since this button is within the record I thought it...

Hello JonXL Sorry but I am painfully new to Access. Me.ID. How does that help?

It is not opening the related record.

If I create a continuous form and then put a button on the record row to open the related record in a form it works. When I try to do this with a continuous form as a subform it doesn't. Furthermore the button wizard does not open. Is there a common understood reason for this? Thanks

Thanks for your instructive message on searching access forums.

Thanks for the reply. I will work on your approach.

Bob As a novice to Access, it is not clear to me how better to tag this question - being brief and to the point. In my opinion there is a general problem with user forums on this front, such that searching the forum is ineffective. So yes, what is the best way to put the question so that others...

I have 5 managers and 40 buildings, What is a good way to create building portfolios, but then also make it so these building can be move between manager if necessary, swapped or assigned., so the portfolios change. I want to make this front end so each manager only sees the buildings in their...

Yes, agreed. I searched the internet but not by the words specific or the error message -"no unique index found for the referenced field of the primary key". I found an article that explained to me that the One of the one to many needs to be unique, so I index the property, Yes (no duplicates)...

I am trying to create a one to many relationship between T_Buildings/BuildingNr(short text) and T_Residents/BuildingNr(short text). When I try to create this relationship I get an indexing error message. What is Access telling or asking me for? Not to index or Index (duplicates or no...

Arnelgp Thanks for the reply I have to admit that being new to access your code is completely above me. If i were to go and try parse your code to understand what you are doing where would you tell me to look? The Microsoft Access site was not that helpful.

Thanks So a solution I think it to separate any expression with * Provided the expression is in the same order as the calculated field it returns the anticipated result Regards

I have a calculated field called SearchItem : [ownerID] & [BuildingNr] & [ BuildingName] & [OwnerName] The Code on the Search btn: Me.FINDER.SetFocus Me.FilterOn = False Me.Filter = "[SearchItem] Like '*" & FINDER & "*' " ME.FilterOn = True Me.Requery When I populate the FINDER field with one...

If one has a contact list of 1100 companies grouped by service category it is useful to see a datasheet or list view, and a form view side by side. Then you can select from the list and see the company and employees in the form view. What is the best selection of controls to achieve this? One...

I have tbl_Contractors.. I created a query to sort the table by the ServiceCategory and Company. The query is the row source for a list box. I am using this as a navigation tool. A ClickOn event populates the form fields; txt-seviceCategory.Value = lst_ServiceContractos.Column (x) One field is...