Search results

  1. June7

    Displaying values in button captions

    Why would you have a button with no text? Why not a caption something like: "Change Project"
  2. June7

    Displaying values in button captions

    I don't really understand the desire to have a dynamic caption on a button but if you must, VBA is the only way. Yes, OnOpen or OnLoad is appropriate. Did you try? Caption is just text, not calculatable expression as in a textbox ControlSource. Otherwise stick with a textbox that acts as a...
  3. June7

    Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form

    Do users really need to see ID_Activity before record is saved? Could save record and then populate field with the ID. If Me.Dirty Then Me.Dirty = False or DoCmd.RunCmd acCmdSaveRecord Or an UPDATE action after record is committed. UPDATE ActivityT SET ID_Activity = ID WHERE ID_Activity IS...
  4. June7

    Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form

    Yes, I did say 'ignore' the autonumber. One issue to be dealt with is that of multiple simultaneous users generating the same value and causing conflict when trying to save. In my db the identifier is generated and record immediately saved to reduce opportunity for conflict. Since there are...
  5. June7

    Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form

    Can't you define non-autonumber field as primary key in parent table? You can still have autonumber field in table but ignore it. I have designed dbs that do not use autonumber as primary key field. I use a vba generated unique identifier. DMax() is often used to increment a non-autonumber...
  6. June7

    Open form and filter the subform

    Okay, did you see post #2? Why embed Friends in a parent form to begin with? Open it standalone and can use DoCmd.OpenForm "Friends", , , "PersonIDRef =" & Me.PersonId"
  7. June7

    Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form

    Exactly what do you mean by 'server', why would a server create data? Why would migrating to another server mess up relationships? My office changed server hardware twice and that did not impact database relationships.
  8. June7

    Open form and filter the subform

    The WhereCondition criteria can only apply to form that is named in the OpenForm method, not its subform. DoCmd.OpenForm "FormB" Forms.FormB.Friends.Form.Filter = "PersonIDRef =" & Me.PersonId Forms.FormB.Friends.Form.FilterOn = True Might find this of interest...
  9. June7

    Multi Field Selection

    Why do you ask for VBA? A query would use OR operator in criteria to apply filter on all 3 fields. However, I agree with others - db structure is not optimized.
  10. June7

    Solved Can't Pass On Form Value to Report

    Data can be pulled by direct reference to form controls or passed by OpenArgs. Using VBA to set report controls with that data is an option. You've already been given example of VBA setting report label controls. As for chart elements, simplest is to populate textboxes that overlay chart. VBA...
  11. June7

    Solved Help with handling of Null

    Why don't you use the code suggested in post 51? What is not clear about the suggestion?
  12. June7

    Solved Help with handling of Null

    If Not salesRST.EOF and Not salesRST.EOF Then salesRST.MoveFirst Review http://allenbrowne.com/ser-29.html
  13. June7

    Solved Help with handling of Null

    Okay, maybe put query back to the original and handle the Null in VBA .HTMLBody = Replace(.HTMLBody, "%Call1%", Nz(clientRST![Phone_Call_#1], "") No, the VBA SQL has FROM Client.
  14. June7

    Solved Help with handling of Null

    Use apostrophes in place of the quote marks when embedding in VBA SQL statement. Sorry, I should have clarified that before. Nz([Phone_Call_#1], '')
  15. June7

    Solved Can't Pass On Form Value to Report

    As majP suggests, OpenArgs is another way. If you want to avoid VBA, expression in textbox can parse the string with string manipulation functions. Directly referencing form controls requires form to remain open until report renders or is printed. Passing with OpenArgs eliminates that requirement
  16. June7

    Solved Can't Pass On Form Value to Report

    One way is to use textboxes as 'labels'. Expressions in textboxes can reference the form controls. Textbox can overlay the chart to act as title.
  17. June7

    Solved Help with handling of Null

    The query sql could handle null to replace with empty string or some text: Nz([Phone_Call_#1], "") AS C1, Nz([Phone_Call_#2], "") AS C2, Nz([Phone_Call_#3], "") AS C3 FROM Client Not entirely clear to me where your code is having issues with Null. Keep in mind for future development: strongly...
  18. June7

    Solved Help with handling of Null

    If you want to substitute Null with empty string, try Nz(fieldname, "") or fieldname & "" I don't disagree with the advice for normalization but db design also involves a balancing act between normalization and ease of data entry/output. "Normalize until it hurts, denormalize until it works."
  19. June7

    vba editor not changing to new textbox.

    Yes, property sheet makes sense. Glad you got it fixed. Odd glitch.
  20. June7

    vba editor not changing to new textbox.

    Don't think I have never observed "vba editor will change it's focus to any textbox etc that is selected on an access form". Why would you expect this behavior? It really makes no sense.
Top Bottom