Search results

  1. C

    getting code on subform to run before main form

    Convert your on_exit event to a function in a standard module. Call it from either the on exit event of the control on yr. subform or make a call to it from the first line in the command button's code.
  2. C

    User write to hard code

    Have you investigated the Tag property? Your code could reference that. Or you could store the value in a table field. (Yes, I know it's not good practice)
  3. C

    Remove the "Sumof" Prefix from Column Headings

    OI!TESS! NO! Tess Don't you dare pick on Pete! This guy is enduring mental agony of a high order. Imagine all the torment of having to retype five or six field names every day! Have you no heart? And, since you ask, we don't have names on our mailboxes here. We have "letterboxes", a misnomer...
  4. C

    Update Append Queries

    and this suggests that your relationships are not set up properly. Sorry to nag you, because you know your own business best, but I still don't see why you need append queries if you have the structure I suggest. What you want to send to Excel is surely a FP and its associated Raw Materials...
  5. C

    Update Append Queries

    still puzzled after all this time... Running these queries sequentially is very simple. Your button can call a function from a standard module. This sets the warnings false, ripples through your doCmd.Open Query commands and issues a message when done. But, as a fully paid up member of the...
  6. C

    Update Append Queries

    Sorry It is taking so long to reply, but our time-zones don't coincide too well. Sorry also to give you the lesson in elementary relationships, but I misunderstood both your level of competence and what you need to do. You can override error messages smply by issuing the command...
  7. C

    Open a form using a VBA Sql statement

    You're a comma short in the DOCmd.OpenForm, methinks. Also, you can use the line continuation character instead of constantly refeferring to strSQL, thus: strSQL= "SELECT......" _ & "FROM...." _ & "WHERE...." _ etc
  8. C

    Form Checkboxes to Define Query

    How about setting up combo boxes based on value lists and preventing additions. Then the parameters refer to the form and combo box name. That's the most straightforward way.
  9. C

    Horrible Scientific Notation is ruining a perfectly good table

    Well done, old sport!:D you can't apply an input mask to a linked table as far as I know, (now watch someone humiliate me..) but you can set up a telephone format in Excel under FORMAT>CELLS>Special>Telephone Number or use FORMAT>CELLS>Custom to specify your own Regards
  10. C

    Auto update next record's value on change to previous record

    Rubyred try adding DoCmd.GotoRecord,,acPrevious before EndSub It may be necessary to also add DoCmd.GoToControl "MyNextFieldThatIWantToBeIn", (substituting your own field name of course!), because it will probably step back to the first field in the previous record...
  11. C

    I'm stuck

    Tools>Startup>Application Title
  12. C

    Adding Records to a tabl dynamically

    Hmm. :( . Sounds like a base 0 type problem..... Does it make any difference if you use a DO Until ="" statement? If you set a breakpoint, you can inspect tmpName on each loop. Does the FIRST file correspond to what you are expecting?
  13. C

    Horrible Scientific Notation is ruining a perfectly good table

    Nil Desperandum Life's too short to get upset by such things. Don't despair, there is a solution. 1) Have you definitely changed the field type in Excel to be Text, using FORMAT/CELLS /Text while the column is selected and then saved the Excel file? 2) Why do you link the table, why not...
  14. C

    Running a Query(NOT Manually)

    OK. Are we done here? Just make up a small form with an unbound text box and a similar text box bound to your table field. When the doc verifies the details, use a VERIFY button to copy the contents of the unbound box to the bound one. This updates the Master table automatically, no query...
  15. C

    Running a Query(NOT Manually)

    Much to my amazement, I do understand what you're saying.:p 1) You make a temporary record and store it in a one-record table 2) When that record is verified, you add it to a master table. 3) You print a script based on the newly-added record. My next question: Why store the unverified...
  16. C

    Adding Records to a tabl dynamically

    hold on.:confused: You use Edit then AddNew. Only the AddNew is necessary. at the end, you MoveNext and immediately close the recordset. Why not open the recordset before the Do..Loop starts and close it when the loop end? Then the MoveNext is logical...
  17. C

    Adding Records to a tabl dynamically

    Please post the whole procedure-not enough to work on at present. NB-you can use WITH to avoid repetitions of rs WITH rs .edit !my field=x .Update etc End With
  18. C

    Running a Query(NOT Manually)

    Wouldn't care to fly in a plane that "just about worked", though!;)
  19. C

    Running a Query(NOT Manually)

    OK. The message you are getting is because you are doing something really evil, like trying to append records with duplicate primary key fields or no primary key fields or summat similar:eek: . Give me the EXACT message, then I can tell you what's amiss. How many records is the query...
  20. C

    Running a Query(NOT Manually)

    ....and why don't you just open the form to print it? Why use SelectObject etc..
Back
Top Bottom