Search results

  1. A

    Using a variable to change the record displayed in a form

    My project opens with a parent form (with the first order summary details) and two subforms. The first subform shows the items ordered for the parent form Order. The second subform is a list of variables used to search the Orders table in the parent form. (e.g. to search for a Order Number - The...
  2. A

    Run Time error 3075 in Insert query

    Also thanks for your ideas Uncle Gizmo and arnelgp - I appreciate your input
  3. A

    Run Time error 3075 in Insert query

    Thank you The_Doc_Man So simple it beat me Thanks again(y)
  4. A

    Run Time error 3075 in Insert query

    The full error message is - Runtime error 3075 Invalid use of '.','!', or '0', in query expression 'Forms.TrustReconAll BranchesFrm.[AcctNameFld'. Below is the code INSERT INTO TrustReconRptTemp ( BranchName, AcctName, BSBandAccountNo, DayEnded, LedgerAmount, UnprocessedDeposits...
  5. A

    I have two tables. One a standard list of 15 emails and another multiple blocks of emails for different matters. I want to update table 2

    Thanks guys I was able to get the above code working with a bit of tweaking. Thanks again for your help
  6. A

    I have two tables. One a standard list of 15 emails and another multiple blocks of emails for different matters. I want to update table 2

    arnegp I have had to revert to the following but it stops with an error "Wend without a While" and highlights the Wend in the third last line. I only have 2 Whiles with matching Wends. It has to be something else. Any ideas ' Go through the StandardMatterEmails file and if an entry isn't...
  7. A

    I have two tables. One a standard list of 15 emails and another multiple blocks of emails for different matters. I want to update table 2

    Thanks Arnelgp, I have used your code but have problems with it, probably I made changes to it. Do you mind putting some comments in your code to help me understand how it is doing it
  8. A

    I have two tables. One a standard list of 15 emails and another multiple blocks of emails for different matters. I want to update table 2

    I need to make sure that all table 1 entries are in each of the blocks of emails in table tow. Table 1 StandardMatterEmails - Fields are - StandardEmailsId, StandardEmail, StabdardOwner Table 2 MatterEmails - Fields are - MatterEmailId, MatterId, EmailAddress, EmailOwner MatterId defines the...
  9. A

    How can I order a Set recIn = db.OpenRecordset("MatterEmails")

    Thank you theDBguy I created a query and worked perfectly Thanks once again(y)
  10. A

    How can I order a Set recIn = db.OpenRecordset("MatterEmails")

    The code below doesn't work properly because I believe that the OpenRecodset("MatterEmails") is in it's native order and I need it recin!MatterId and then recin!EmailAddress order Can anyone help me please Dim db As DAO.Database Dim recIn As DAO.Recordset Dim strLastField1 As String Dim...
  11. A

    Keep on getting a Mismatch

    Thank you arnelgp worked wonderfully Thanks again👍
  12. A

    Keep on getting a Mismatch

    strNewRecord = "SELECT * FROM OrdersOnlyQry WHERE Customer Like " * " & [Forms]![OrdersFrm]![SearchSubform].[Form]![SearchCustomerNameFld] & " * ";" When I execute the above line I keep getting the mismatch error The field custome on the Qry is string. In the immediate window I can...
  13. A

    My query keeps asking the user to fill in the parameter

    I actually want to delete the whole record that matches the email address
  14. A

    My query keeps asking the user to fill in the parameter

    I run the first part below (using EmailTableMaintFrm) to ask for the email address to be deleted. The user enter an email into "Me.EmailToDeleteFld I have this code in my program (EmailTableMaintFrm) Me.EmailToDeleteFld = InputBox("Please enter the Email to be deleted ", "Email Deletion")...
  15. A

    Trouble with a form with two subforms

    You are Mr Magic. It's now working fine Thank you very much
  16. A

    Trouble with a form with two subforms

    This is the links for the right hand side subfolder
  17. A

    Trouble with a form with two subforms

    The 0400 in the parent form is unbound and it's name is MainLinkFld The onClick for the Category in the left hand form is Private Sub CategoryFld_Click() ' I want the subform window on the right to display the SubCategory detail ' Change the record pointer of the parent form using the...
  18. A

    Trouble with a form with two subforms

    Thanks arnelgp, That fixes the right hand form displaying the details, now my index on the left is not responding. It's there but when I click on the SubCategory the right hand one doesn't move
  19. A

    Trouble with a form with two subforms

  20. A

    Trouble with a form with two subforms

    The module is a Help File. I have a form that displays the index of Help Topics in the left hand subform and the detail of the of the selected index topic is displayed in the right subform. This works OK My problem is that I want it to respond to in context responses. When the user is in the...
Back
Top Bottom