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!

Recent content by bsupport

  1. bsupport

    How do I not show duplicates

    Ok, I think I understand what you are trying to show. Just to let you know, these tables need to be normalized, but I won't go into it now. For a quick form-fix: 1. Create a query using the fian table and the field fian_no only. Make sure your query includes the keyword DISTINCT. 2. Create a...
  2. bsupport

    How do I not show duplicates

    Mtlca401, Question: Why bother with table 2 when you only want unique values from table one? If you don't care about the data in the fields of the duplicated records (last three fields of table two), then why have table two? What is it you really are trying to display or trying to do on your...
  3. bsupport

    Pass subform name as variable to Module.

    Foolio12, Thanks for your assistance, I really appreciate your response. I have found another thread, thread702-461372 that solved my problem. I used her suggestion to initialize a global and it worked great. Again, thanks [bigsmile], Bsupport Who takes 7 seconds to develop, 7 mins to...
  4. bsupport

    Pass subform name as variable to Module.

    Foolio12, Ok, I guess I am not being clear enough. I need the [ctlNameOfTheSubFormControl] to be a variable, not the actual name of the control because the sub procedure and function routines where I will use it and will pass different subform names. Thanks. Who takes 7 seconds to develop...
  5. bsupport

    Pass subform name as variable to Module.

    Foolio12, So, to pass the subform name frmSub, I would use: name of variable that holds name of main form: frmMain name of variable that holds name of subform: frmSub name of control on subform: startDate Forms!frmMain!frmSub.Form!startDate Is this correct? I will go try this and get back...
  6. bsupport

    Pass subform name as variable to Module.

    I need to pass the name of a subform or form, (reference different subforms or forms, depending on what procedure I'm running) to a SUB in a module. Can anyone help? [sadeyes] I have tried searching the Access forums and the Faq's with no luck. All of those reference a particular subform, I...
  7. bsupport

    Strings, proper case, & stripping spaces

    Judgehopkins, See this link for enumerating through the all controls on a form, http://www.mvps.org/access/forms/frm0004.htm. You could remove all Case statements except the one for "actextbox". Then, under "Print out the array..." remove the first two...
  8. bsupport

    How do I not show duplicates

    Mtlca401, See your Help File in Access for "UniqueValues Property" (and I quote): Prevent duplicate records in a query based on fields in the design grid. Open a query in Design view. Select the query by clicking anywhere in query Design view outside the design grid and the field...
  9. bsupport

    FoxPro programmer moving to Access...???

    Thatguy, Try these on for starters, Free and on-line: http://www.mis.bus.sfu.ca/tutorials/msaccess/tutorials_main.asp http://www.functionx.com/access http://www.fgcu.edu/support/office2000/access http://www.itlearningmaterials.com/access Hope this helps. There are other goods ones but I...
  10. bsupport

    OUTLOOK2002(XP) New,Reply etc BIG PROBLEM

    beerhunter2, On my desktop, I run Office 2000 PRO in a Windows XP environment. Thanks for the post about the Microsoft Knowledgebase article #320757. This fixed the problem I have had for months where every time I tried to run a Office 2000 Pro application or use the Help screen, I got the...
  11. bsupport

    Problem with Command Button - Very Frustrating!

    BLBurden, I used the code described at the below attached link to create a button to send email messages in Access97 and again in Access2000 and mine works great. Of course I modified it to my particular specifications, but I'm sure if you review the code, you might find out why your command...
  12. bsupport

    Embed a report in a form?

    Spiralmind, Check out this link. It might help. http://support.microsoft.com/default.aspx?scid=kb;en-us;209990 Who takes 7 seconds to develop, 7 mins to document, 7 hours to test, 7 months to fix will always blame the clock. s-)
  13. bsupport

    Probably a simple combobox question..

    Thatguy, could you be a little more specific? if I read you right, you have: Table 1: Main Table 2: Category Field 1: Main.Primary Key Field 1: Category.Primary Key Field 2: Main.Category Field 2: Category.Description You want: If Category.Primary Key matches...
  14. bsupport

    Transfer information from subreport to main report

    Sarsta, See Microsoft Knowledgebase article #209099, http://support.microsoft.com/default.aspx?scid=kb;en-us;209099 ,or article #208835, http://support.microsoft.com/default.aspx?scid=kb;en-us;208835, these might give you some assistance. Who takes 7 seconds to develop, 7 mins to document, 7...
  15. bsupport

    Bound Rich Text Box On Report

    Celtc, You might look at Microsoft Knowledgebase article #210589 which shows how to prevent printing blank lines in a report through the use of the CanShrink Property and Code. See http://support.microsoft.com/default.aspx?scid=kb;en-us;210589 Who takes 7 seconds to develop, 7 mins to document...
See more

Part and Inventory Search

Back
Top