Search results for query: *

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

Sorry, I should have told you to uninstall then re-install. Glad its working for you know. Have a great year! Who takes 7 seconds to develop, 7 mins to document, 7 hours to test, 7 months to fix will always blame the clock. s-)

Sometimes this means your Access application is missing a wizard or your code is missing an END statement i.e. END WITH or END IF. Try re-installing wizards. Who takes 7 seconds to develop, 7 mins to document, 7 hours to test, 7 months to fix will always blame the clock. s-)

Glad you found a solution. Sorry you weren't able to access the other sites. I was at all of these sites the day I responded to your thread. They are live. Hope you have a wonderful year! Who takes 7 seconds to develop, 7 mins to document, 7 hours to test, 7 months to fix will always blame...

I've done this also, but I had to insert the selected items into a new table to store them, then I created the filter using another SQL statement on the New table. I saw another solution in a Access book I have. If you have not found a solution after the New year, I'll send you the one from my...

Check out these websites for connection strings. Note that the first two provide screen shots. http://www.iisfaq.com/articles/307.asp (good walkthrough) http://www.haneng.com/lessons_17.asp (good lesson) http://www.able-consulting/ADO_Conn.htm (lots of strings)...