Search results

  1. C

    Using result of a dlookup...

    I'm try to get the result of a Dlookup below so I can use the result later. In debugging the code. I have made sure that the P3rdBUSID and MatterID have both got the correct Values expected. Its just that strContIDLookup does not get the result assigned to it? Am I doing something...
  2. C

    Reference text field from form in a query

    I have a query I for mailmerging, Its working great but now I need to add the contense of a text box on the form that I'm running to add it in to the merge information. (the information is from a dlookup ran on opening the form and works fine) I've tried adding a reference in to query its...
  3. C

    Login Form...

    I'm setting up a database and have made a rather large mistake! I've completely forgotten about a 'login' feature to pick up user details... Before you all have a go! I know I'm kicking myself enough already. I have a employee table with all various information and can add a login ID and...
  4. C

    Closing Form from Subform

    In my Main form (frm_Matters) I have a subform (frm_Others) in that form I have a button which opens a new pop up form (frm_Other_Business) but I then need to close the form that it came from (I.e the Parent form 'Matters'). I've used the code I usually use when opening / closing forms but as...
  5. C

    Cascading List boxes help

    I have a form where I need to select a business from first listbox then display the contacts for the business in the second listbox. I've been looking at cascading listboxes / combo boxes but everything I've found so far does not fit my requirements as its usually based around a single field...
  6. C

    'read only' form but need an active list box?

    I have a form that I want to display the data but not allow additions / deletions / Edits etc.. But also on that form is a list box that I need to have 'active' so I can select an option from the list box to carry on to a different screen or use the selection open word. My issue is that on...
  7. C

    Controlling a sub form or Tab control?

    I have a job sheet created with the basic headers required, then depending of the type of job selected I want tab controls for the data they need access / complete. This is due to Some jobs needing different data entering for letter merges or creating reports etc... What / how do I control...
  8. C

    Swap data between fields in different tables?

    I have assigned to a contact an email address in a 'contact' table. I then have a table for additional email addresses (some of our contacts have home / work / other email addresses), this works fine with the default address always appears in the contact information and the additional emails...
  9. C

    Error 2585 on closing a form

    I have a list box (In a pop up form) where I can select a record and open it in the management form for viewing / editing / etc. Below is the code thats works for the double click event (on the list box) and a command button I've added to the form. Dim strWhere As String If...
  10. C

    Filter a listbox in pop-up form from another form

    I have a form where I enter in either Contact or business details, I can then add multiple email addresses to contact or business by updating a table with the additional email addresses and using the contact or business 'ID' of the record to associate them to email. (I hope I explained that...
  11. C

    Save Button Not working as planned

    Below is my code for a 'save' button. It works except for one element, When I click the button the message appears as expected, then saves the record as directed but when it returns to the form it goes to the first record? Private Sub cmd_Save_Click() Dim Response, Msg, Style, Title Msg...
  12. C

    Table with links to other key ID fields?

    I have a few tables now with business's, contacts and employee's. I want to set up some 'project sheets' for a few little projects we have. I'm not sure the best way to put this together or the correct terminology so I can investigate further. I want to set up a project table with basic...
  13. C

    Use a Field from a sub form

    I have a simple Form with a sub form linked in. The main form has a business name visable and hidden the business ID (which is also the primary Key). The sub form Lists the relevent contacts to that business. The form its self works fine, its a datasheet in datasheet view but edit / deletes...
  14. C

    Table with lookup entires issue

    I've setup a business database for companies we deal with, using Access 2010 I will eventually put the 'database' on a SQL server and use forms to access it from a users perspective. As part of adding the business types I want to make sure that when someone enters the data in the field they...
  15. C

    Open a different form using current record

    I'm new to Access 2010 and creating a business contact DB so eventually people can merge letters from it. I've started by putting a data input form together and various forms to update which all work fine. The next part I'm struggling with though, When I create a new business I then want to...
Top Bottom