Recent content by bsupport

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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-)

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...

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...

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...