Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fredzeppelin

    Combo Box shows blank but is populated

    Thanks for the pointer, that seems to fit the symptoms. (I did search prior to posting, and came up empty)
  2. fredzeppelin

    Combo Box shows blank but is populated

    Several years ago I wrote an Access/VBA app for a client. Been working fine since. Was written in Access 2002, clients' IT upgraded to Access 2003, SP3. Of the entire app, there is now a single malfunctioning ComboBox. The box simply lists the 1st/key column of a table for selection. Currently...
  3. fredzeppelin

    Trouble - copy data to new record

    Ok, the light dawned while I was sleeping, and your experiments verify it. The snippet works fine only while the subject Form remains open. Close it and the changes are gone. Can't save design changes from Form View. Probably makes sense to *real* programmers. That doesn't fit my situation...
  4. fredzeppelin

    Trouble - copy data to new record

    First, thanks .... very much Second, you said: ... just some of the fields, and it doesn't have to work after close/reopen (that's a bonus), but during subsequent adds. Third, No I don't need to return to the specific record. I just want to change some combo/list/text box default values on...
  5. fredzeppelin

    Trouble - copy data to new record

    Simple need: to fill-in a form-based new record with data from the previously added record. The FAQ's lead to this: Private Function SetDefault() Dim ctl As Control Set ctl = Screen.ActiveControl ctl.DefaultValue = """" & ctl.Value & """" End Function then bind the function to...
  6. fredzeppelin

    Create report from Form recordset/clone

    Once I puzzled out the relationships between the report design phase, the base query and the Me.Filter, this did exactly what I needed. Thanks muchly ....brad
  7. fredzeppelin

    Create report from Form recordset/clone

    If I don't need a recordset, that's fine. I intend to DoCmd.OpenReport. What I don't know is how to get the data from the open form fields to the 'recordsource' of the report. When I try to design the report, I'm only permitted to use Tables or Queries as the recordsource. I see what you...
  8. fredzeppelin

    Create report from Form recordset/clone

    My example left out 'set' as a typo. I had not yet made the reference to DAO 3.6 library. So, Dim rsTemp as DAO.Recordset Set rsTemp=Me.Recordsetclone works, and I have my data universe in rsTemp Now, How do I : a. base a report on it? , or b. assign/dump/link it to a table, on which I can...
  9. fredzeppelin

    Create report from Form recordset/clone

    I have a form. It's quite complex and has multiple selection criteria. The point being, when the form is open, its recordset constitutes the universe I would like to create a report from. The only way I've been able to succeed in this: 1. Open the form hidden ...Display "WAIT" 2. Assign a...
  10. fredzeppelin

    Detect Subform with No Records

    Whoops, I tried the FAQs again with different key words, and found a suggestion. Create a recordset from the subform linkfield criteria and count it. I'll go try that..... thanks again
  11. fredzeppelin

    Detect Subform with No Records

    Situation: Form with subform, linked parent/multiple child with referential integrity enforced. Processing with pretty deep code. On occasions, the subform has no retrieved records(rare, but expected in one specific situation). Subsequent assigning data to field of non-retrieved record fails...
  12. fredzeppelin

    query based form - detect no records

    Perfect. Exactly what I was looking for. (and once I knew what to look for, the doc's were helpful as well) thanks muchly Zameer ........brad
  13. fredzeppelin

    query based form - detect no records

    Because: 1. When the form is based on a query that has a user parameter entry as a criterion for a field. Select Foo from tblBar WHERE (((tblBar.Foo) Like "*" & [Enter search target ] & "*")) Dcount() fails, and I expect it to, because the search target is not specified. (tho' the error...
  14. fredzeppelin

    query based form - detect no records

    I'm trying to reliably (of course) determine if a DoCmd.openform returns no records. The forms are query based, some of the queries have embedded [enter parameter ?] criteria, and some are driven from form fields. 1. A method I discovered here in this forum recommends using...
  15. fredzeppelin

    Form not 'halting' to accept input

    Wow, lots of great feedback and good ideas. I think I have a much clearer idea of how this works. I've had this confusion that an openform was like a call to an independent subroutine, yet I know that the code that follows the call executes, cause I manipulate the open form all the time...
  16. fredzeppelin

    Form not 'halting' to accept input

    1. I can't find acDialog documented anywhere, except that it's a 'windowmode'. I did find a whole bunch of gibberish by a guy in Canada, saying how different and complicated it was, and mere mortal programmers probably didn't use it right (lol). 2. On the other hand, I've done a bunch of...
  17. fredzeppelin

    Form not 'halting' to accept input

    You said: I'd put in code in the on-click event that then goes back to the 'calling code' .... Yes, Exactly what I want. So what code do I put there? In other languages, this is called a subroutine return. How do I do that here? I don't even know how to search for it. ==== Yesterday...
  18. fredzeppelin

    Form not 'halting' to accept input

    I have a form with 2 controls. A combo box that has a row source in a table, nothing fancy, just the only field, all records. A continue button. The on-click event is set to basically no-op. When I open the form programmatically, it opens, and doesn't wait for any events, it just returns...
  19. fredzeppelin

    IIF() in query criterion

    Duh! Thanks, works like a champ. ...brad
  20. fredzeppelin

    Passing a Variable to a text box in a Report, possible? Easy?

    I came searching for exactly the same topic and problem. Using dhookom's suggestion, I attached this code to the Report Header OnFormat event. (Note that I'm using a label rather than a text box, but the ideas's the same. Ignore the Select Case logic. This worked fine. Private Sub...

Part and Inventory Search

Back
Top