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 derfloh 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: *

  • Users: MaggieLeatherman
  • Order by date
  1. MaggieLeatherman

    Run time error - 2001

    Thanks for all your help! I did have a syntax problem. It's working ok now! Maggie
  2. MaggieLeatherman

    Run time error - 2001

    I've been getting Runtime error '2001' , You cancelled the previous operation.... on the following code: If Not IsNull(Me.BSRId) Then Me.txtUnits = DLookup("UnitsACM", "GAMaterials", "[bsridfk] = Me.BSRId") End If Does anyone know what this means? Thanks, Maggie
  3. MaggieLeatherman

    Force Capitaization in text box

    Thanks, MAggie
  4. MaggieLeatherman

    Force Capitaization in text box

    I know this is simple but... how do you format a text box to only have capital letters... Thanks, Maggie
  5. MaggieLeatherman

    Entering (C) results in @

    Thank you so much! Maggie
  6. MaggieLeatherman

    Entering (C) results in @

    Hello, my client needs to be able to enter "(C)" in a text box but on exit, it converts to "@". Is there a way to control this? Thanks so much, Maggie
  7. MaggieLeatherman

    Update combo box as result of another combo box

    Project #’s consist of “yr-proj#” For example: 07-690 or 06-700 There could be 40 or more projects to pick from so I’d like to first narrow down the list by ProjYr. Depending on the year chosen from the cboProjYr combo, this will only show the projects from that year only. I have 2 combo...
  8. MaggieLeatherman

    Parse name into 3 fields

    Thanks so much! Maggie
  9. MaggieLeatherman

    Parse name into 3 fields

    Hi, I have a field called IWname in an old Access DB which contains the fullname ex.(Smith, Irene A.) I need to break up this field into EmpFirst,EmpMI,EmpLast.. Can someone quickly on what to do? Many thanks, Maggie
  10. MaggieLeatherman

    Position a form and resize it

    Hello, I've been resizing a form and moving it to the middle of the screen. After I close it and then re-open it, it's back in the original position and size.. How do I control this so my application looks the way I want it? Also could you direct me to other threads that discuss application...
  11. MaggieLeatherman

    Syntax error in critera expression

    Hi AceMan, Thanks for your help, I have so much trouble with syntax in criteria! Maggie
  12. MaggieLeatherman

    Syntax error in critera expression

    ...DoCmd.OpenReport stDocName, acPreview, , "[BuildingIDFK] = " & Me.txtBuildingID DoCmd.OpenReport stDocName, acPreview, , "([Percentasbestos] like '*%*' or [Percentasbestos] = 'ACM')" But I need the criteria together in on OpenReport command. Below I put both the criteria stmts together from...
  13. MaggieLeatherman

    Duplicate a Record

    Hi The Missinglinq! Thanks for all your help. I have another question regarding your first post with the code.. Will you explain this? How do you make this work? 'Prompt to enter new Room Number Me.RoomNumber.Value = "Enter New Room Number" How do you make a prompt for the user to enter the...
  14. MaggieLeatherman

    Duplicate a Record

    Thank you so much for this code. I know it will work... Now another important part that I negelected to ask... How do I add the matching Detail records in the subform? In other words, Main form (frmArea) has a subform (subMaterials) When I duplicate the records from frmArea I also want to...
  15. MaggieLeatherman

    Duplicate a Record

    Hi, I have an input form where the user would like to duplicate all the information into a new record and then only change Room Number. This would save data entry time since much of the data is the same except for changing the room number. I'm not sure how to accomplish this task... Thanks...
  16. MaggieLeatherman

    How to know if a form is open

    What code do I use to find out if a form is open. I need to use this information in an IF statement... Thanks, Maggie
  17. MaggieLeatherman

    Control Page# when the Report Group Header changes

    Hello, While looking at your example, I don't know where you got the numbert ex. + 9, How did you know how many pages to add to [Page]? I guess I would need to control this based on a group change, ex: whenever the SRNumber Group changes, i'd need to start the page count over... I'm still...
  18. MaggieLeatherman

    Subreport to print in columns when another group header present.

    Thanks for your reply. I'm so bogged down now that I haven't had time to try this.. It seems so complicated and I'm not sure where to start... Thanks, Maggie
  19. MaggieLeatherman

    Control Page# when the Report Group Header changes

    I have a report with a Group Header on SRNumber. When I run the report, on the Page Footer it shows Page 1 of 15. I need the page # to reset every time the SRNumber changes and show this on the botton of the page. For example: SRNumber = 501-4 Page 1 of 2 etc. " 501-12 Page...
  20. MaggieLeatherman

    Subreport to print in columns when another group header present.

    Hi, I have a report that groups on SRNumber. The SRNumber header section is working fine.. in the SRNumber Footer section I have a subreport that groups on AreaID with a detail section... I need the subreport to print in columns "down and across". It prints correctly on its own but as soon...

Part and Inventory Search

Back
Top