Recent content by docmeizie

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

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

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

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]

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

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

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

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]

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

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

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]

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

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

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

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