Recent content by elite311

Wow I was thinking this would be so much more difficult, I'm still learning VBA but it worked awesome. Thanks so much

I'm trying to have a calendar load on todays date and call the click event when it loads. I'm using the calendar to populate some text boxs and when a manually click the date it works fine. Now I just want todays date to be clicked and selected automatically so the text boxs are populated as...

Any ideas on this? I tried using a Query and got it to kinda of work but just with one date. I need it to work accross a date range and not sure how to do it.

I'm looking for some help, I haven't been able to figure this out and I have searched the fourms for the answer already but haven't come up with anything. I have a form that I have put the Calendar control v.11 onto and under that calendar I have 4 text boxs. (1)-Tech name (2)-Tech cell number...

Ok I see your point :) So basically a Market is the territory the Tech/Driver covers. Tech does service calls after hours where the driver handles delivery issues after hours. Basically I want to make a schedule for the after hours crew at the office to use and incorporate it into my current...

I would create a query and use that to populate the price. So make a new query in design mode and add all the fields you want to use to the query by draging them down. Then in the query design under criteria enter [Forms]![Order]![CboBoxname] where CboBoxname is the name of the combo box on your...

Table design for on call schedule, whats the best way? I'm working on a database for my company that shows service and delivery information and I'm trying to incorporate the on call schedule to the program. I made a table with the columns Market, Techname, Date, and want to use the calendar...

Thanks! The DLookup thing sounds very interesting I will read more on it. But seeing as I know nothing about it. Can the DLookup be dependent on what is selected in the TechName list box? then only show the TechInfo for the selected Tech? I am not quite sure how to use that function. I am...

I tried that but the problem is you cant wrap the text in a list box so instead of the text wraping down to the next line it just cuts off at the end of the feild size. I was thinking if I had the list box and made it not visible then I could use a text box to display the info from the list box...

I have a form that is displaying info about a tech from a table when the tech is selected from a list. I have everything working fine except the info feild. This field has alot of info written in it on the table so when I use a list box to call it up I only get a little but of the info...

Worked perfect! Thanks again for the help, I really appreciate it!

That worked perfect! thanks so much for the help. I was stuck thinking it had to be done all though VBA and not a query. I was looking at the one you created and changed it a bit to read the market number from combo 1 aswell that way it only shows techs in that market that can do the activity...

I've been working on this all night again, is there anyone that can help me on this? please

anyone have any ideas? I just can't figure this out

In the T_Service_Actvitities table it lists the activitys and the techs are linked them them if you open the table and expand the record it shows what techs can to what activity