Search results

  1. M

    Tabs within Tabs

    Before I dive deep into this question with details, can I create a Form_B that has a Tab Control with sub-forms, and then on one of the Form_B Tab Control Pages have another Tab Control? Thanks
  2. M

    Cannot Save as

    I am trying to save a db as another name. I get the error message; ! Could not find field 'kf_82_Services_ID' I do believe Access might be say, "you have a reference to this field that no longer exists" . Could this be right? How would I find this reference? Thanks
  3. M

    Tables - Multiple Instance - Why do this?

    When building relationships in the relationship window, it is possible to add multiple instances of a table. Generally they look something like this; Contacts_T_1, Contacts_T_2, Contacts_T_3., ect... Why add multiple instances of a table? Are these instances related. So for example if you have...
  4. M

    Background Color on a Continuous Form - based on Boolean

    I have a continuous list with a field (boolean) [Completed]. When I check it the conditional colour changes. This produces a visual sort of task completed. It only works if background colour of my [Background] field is 'Solid', not 'Transparent'. So I need to write an Expression that says...
  5. M

    A list within a list

    Here we go again :) I have a form with a subform in a parent child relationship. The subform is a list of tasks associated with a building. (wash the windows, fix a hole in the wall kind of thing). I want each task to have a collection of notes - short texts. This way I can make notes of...
  6. M

    The object doesn't contain the automation... timestamp

    I have, [Tasks_T].DateRequested and set the default to Now() to create a timestamp on record creation. THe Tasks_T has a Subform. When I created a new record in the subform.... the error. How do I fix this error? Is the object is DateRequested ? Can I code this instead on the subform? I...
  7. M

    Joining More Than Three Tables

    A strataplan is a building I have 4 tables 1. Infosheet_T (Infosheet_T is a record of services provided for the strataplan by contractors) Field: kf_StrataPlan_ID, one to many relationship with kp_StrataPlan_ID : allows me to relate the infosheet with the strataplan record (this allows me to...
  8. M

    Reestablishing Record Source

    I have made a lot of fundamental mistakes putting my first db together. I am trying to correct these and my thought is to delete my queries and rebuild the relationships. Is there a flaw in this idea.
  9. M

    Command Button to Select Records based on a set Criteria

    So far in my attempt to build a database my search buttons execute code based on the content entered into an unbound text box. It would be much simpler in certain circumstances to have a button that selects all the records based on the string value of a field. You can see my thought in the...
  10. M

    Stuttering Loads

    I have a continuous form. I put: DoCmd.SetOrderBy "[StrataPlanNr],[ServiceLines]" to sort the form when it loads. There is something wrong with this code. Q1: What? Q2: Is there a depository of documentation from Microsoft or others about the syntax for such statements?
  11. M

    Search Button

    I am coding a search button on a form based on a Query. If I want my search to return on the value of one of the table fields does the code need to refer to the Query or the table? The on click code Me.SearchText.SetFocus Me.FilterOn = False Me.Filter = "...
  12. M

    Lookup Value List Keeps Growing

    I have a lookup on a foreign key that associates a strata to a task. So I use the lookup to provide a strata plan nr. It seems with each new record I create and assign a strata plan nr my value list grows by one value of that nr. Is there a known cause for this?
  13. M

    Button asking for a parameter

    On the advice of a fellow forum member I starting to normalize my database this weekend using kp and kf. One of my buttons that navigates from a list form to a record form now shows a window that says,"Enter Parameter Code, Contractor_T.ContractorCode". What is it asking for? How can I code the...
  14. M

    Query about Queries

    When one creates a query from two tables what determines which fields one includes in the query?
  15. M

    One book or Resource on Access

    Very new to access. trying to learn the basics. What is your recommend on the best beginners resource?
  16. M

    Button on Subforms - showing related records

    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
  17. M

    DataBASE Design - Assign Customers

    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...
  18. M

    Solved Relationships - Indexing

    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...
  19. M

    Filtering with a Calculated Result

    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...
  20. M

    Best Design Approach

    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...
Top Bottom