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!

  • Congratulations SkipVought 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. docmeizie

    add totals from different subforms...

    Close to working but not quite. My form is set up like this: Person Entry form --> Main form (Personal Information) History/Permit Check form --> Subform 1 (Day they came in and whether permit is issue to purchase items) Item Entry Form --> Sub Subform(Subform 2 within subform 1)(Items bought...
  2. docmeizie

    add totals from different subforms...

    I have a database where I keep track of items registered by individuals. The database keeps track of each day the person comes into register items. Each day the person comes in, they can register one or more items. So basically i have a form with a subform that contains a subform. I can get...
  3. docmeizie

    Mediaplayer, mp3's, and code to use them in access

    I have an extensive music database that I created, I'm a aspiring DJ, but I am also a serious VB, VBA coder. What I want to do is intergrate mediaplayer(or some type of player) into my project so I can select a file to play and it plays the file. I don't want mediaplayer to pop-up or anything...
  4. docmeizie

    Subform not showing records...

    I gotta give you a star for that. I overlooked the fact over and over again. LOL That is something I know should be set to no. My Duh moment for the week. Thanks If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv [pc1][shocked]
  5. docmeizie

    Subform not showing records...

    When you open up the form without the main form the information does not show either. All my relations are correct, there is data in the key field, and my child and master link field are correct. If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom&quot...
  6. docmeizie

    Subform not showing records...

    I got a Main form Address and Two subforms nested on the mainform. One is Certificates and the other is Violations. Address has a one to many with Certicates and Violations. The Violation's Subform data and records show correctly, but the Certificates Subforms doesn't show anything. I go to...
  7. docmeizie

    MATCHING COLLECTION DATA WITH ORIGINAL TABLE IT CAME FROM (CAJUN, AHEM

    Okay this looks like it just may do the trick. There are three ways the teams could be split up by talking to the person I am doing this for. One way was to just split the teams into two smaller divisions if over eigth teams registered (now its down to six teams). Method two was to randomize...
  8. docmeizie

    MATCHING COLLECTION DATA WITH ORIGINAL TABLE IT CAME FROM (CAJUN, AHEM

    That's no problem, take your time. If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv [pc1][shocked]
  9. docmeizie

    MATCHING COLLECTION DATA WITH ORIGINAL TABLE IT CAME FROM (CAJUN, AHEM

    This question is more directed to CajunCenturion since he helped me with the original code; but any input, idea, advice from others is more than welcome. Well Mr. Cajun if you remember you gave me some very helpful code to create a Round Robin Scheduler for this Softball league I am making a...
  10. docmeizie

    Switchboards Pro's and Con's

    If you are going to have different levels of activity for set groups of users, then you may want to create your own switchboards. Reason being, you can customize them for each group level. If you have taken a look at creating groups of users then you can designate which forms and data that...
  11. docmeizie

    VBA vs. VB6

    Yeah thats exactly what I meant, "control" must have been absent that day since I was not in control of anything that day. If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv [pc1][shocked]
  12. docmeizie

    VBA vs. VB6

    1 difference I noted that is noteworthy for this discussion is the fact that you can not do arrays in VBA versus VB6. Now I know from first hand experience this can be kind of troublesome in Access if you have a set of controls that you want to do the same thing. In Access you have to code...
  13. docmeizie

    Variable not passing

    Hmmm. I think you may have a better chance using a collection to get all your files in one place, then tie the combobox to that collection. Give me some time and I can show you what I am talking about with a code set. If I take a peek in your Windows, to fix a problem, does that make me a...
  14. docmeizie

    Combo box not showing row source values

    Why do you need all those columns for the combo box? A good rule of thumb is to only use what you need when building a record source for a control. I think that you might want to build a query for that control using the query builder(the ellipse next to the record source line). Only add the...
  15. docmeizie

    Variable not passing

    Where is your SELECT statement for the sql located? I am not the greatest SQL coder but I don't see a SELECT statement to initiate an SQL query. Or are you trying to connect to a table? Need a little bit more clarity on what exactly your are trying to do and your coding.... If I take a peek...
  16. docmeizie

    Number field accepting non-number characters

    Make sure to check your format and input mask also. If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv [pc1][shocked]
  17. docmeizie

    How to export a table in access to excel via command button

    How would you go about sending a table from Access to excel via a button on a form? I know it can be done but the process eludes me as of now. Any help would be greatly appreciated. If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv...
  18. docmeizie

    Is it possible to tack on an existent control to tab control???

    Well I am doing some revising to a database and was wondering something. I have controls on a form already, but I want to add a tab control so that I can add some more controls to the form and then add the existings controls to the tab control. Is this possible? If so then how? I would...
  19. docmeizie

    Question about coding with .net....

    I was looking into start coding with vb.net. Well I heard from an instructor that .net takes some part from VB and some from C/C++. I have studied both as seperate entities. I was wondering what was the most outstanding change in VB.NET from VB 6.0??? Also I would like to know do the codes...
  20. docmeizie

    How do you handle combo boxes?

    So basically you want the user to be able to type in the GST number and it automatically will go to that record right? And you also want to edit the number?? Do you mean edit as in change or edit as in add a new number? If I take a peek in your Windows, to fix a problem, does that make me a...

Part and Inventory Search

Back
Top