Replies

I’m thinking maybe “On Lost Focus” but I honestly don’t know what some of the other options are. They will continue to work on the same form but will probably click one or more of the other buttons to review sales detail and it will get pretty crazy if they’re all open at once. I’m open to suggestions.

Thank you very much!

I have it formatted as a telephone in Access and it reverts back to the 10 digit number when merged. I’d like to try adjusting it in Word but don’t know how to go about it.

Thank you Hans. That was very helpful.

I didn’t know that you could create your own background using the AutoFormat! How cool is that!!!

Access is so exciting.
Thanks again.

Thank you Charlotte. I’ll have to look all of that up as I’m just starting out but it does give me a lot of terminology to do a search on.

Thanks again!

That is SO great! That coding sure gives you a lot of control. I would have never gotten that.

I don’t mean to keep bothering you but can you please tell me what the & Chr(34) means. I realize that it’s holding the record somehow but I’d like to understand it if you can explain it in simple terms.

I can’t thank you enough. I may actually get this project done sometime this summer.
Theresa

The sample that I have was at work. Hopefully it will work this time.

Thank you for replying Hans. You helped me with the first part of this challenge a couple of weeks ago.

The record should not be excluded but there’s a lot to trouble shoot with this stuff isn’t there! I’m open to any advise that you can offer! I just finished my class on Access and we touched on coding but I know just enough to know that I need to know more.

What I want to filter on is the type of equipment that is available in the date range selected. I’ve put a combo box on the form so the user can select the type of equipment needed and I’m hoping to filter and unfilter the equipment that is available in the selected date range from there. You were kind enough to give me the queries that figured out which equipment to exclude and which equipment is available in the date ranges selected. I hate to keep asking for help but I just can’t get past this part of the database.

I’ve attached the sample database. I don’t remember whether or not I locked the fields in the Equip that is available subform. If not, I’ll be sure and do that in the final project.

Hi Hans,
Would you mind helping me again? I know that it’s been awhile but with a full time job and a three year old there isn’t a lot of free time. It’s Father’s day and my husband is napping with my son so I thought that it might be a good time to take a stab at this again. The queries that you created for me worked great! It seems like with every new thing that I learn I have a hundred new questions though.

I put the Job information on a form (frmJob) and added a subform based off of your qryAvailable (subfrmAvailable). I can easily see, for each date range selected, what equipment I have available. Concerns/Questions/Plea for Advise

1. Once tblEquip is filled in with live data and they go to frmJob to view the Available Equipment, they are going to have to do a lot of scrolling because they have a lot of different Types of equipment. I can use the filter button on the tool bar to filter on the type of equipment that I want but when I unfilter it to select the next piece of equipment, it unfilters everything including my job. I’m left on a different record all together! I thought about a parameter query but they would be operating so blind using that, you know they would have to remember all of the equipment types and spell it correctly in order to return accurate data. I would probably end up in the same boat anyway, so I didn’t go there. With my . . . limited knowledge because I know that Access can do more than I can even imagine, I thought that I could create a combo box based off of tblType, used when setting up new equipment. It only has one field in it and it’s a primary key so there aren’t any duplicates, tblType.Type. Anyway, I thought that I could create a combo box using tblType and then filter frmJob on whatever is selected in that box. I don’t have any idea whether that will work or not because all of the codes that I tried had errors in them. It sounds like an iif statement to me but I don’t know how to write it in the correct code. cboTypeafter update – If cboType is not null then filter subfrmAvailable on the Type selected else null or show all. I don’t know how to write it so the cboType and subfrmAvailable.Type are equal or if cboType is blank than show me everything available. I don’t know how to add an attachment to show you what I’ve tried but even then, nothing has worked. Boy, is my instructor going to have his hands full in the Fall – I have a thousand questions now!!!

2. My second concern is, when I put your queries in place and then checked it against the test data that I had entered previously, I had already overbooked some jobs. Can you please tell me how to make a message appear that says, this equipment is already booked, are you sure you want to select it? Yes= accept it or No = cancel or delete selection.

I have a L O N G way to go but I’m enjoying the journey! Thank you so much for the support along the way.

I found it. Thanks!

There’s sure a LOT to learn!!!

Hans,
I have a three year old so I had my hands full last night. I’m trying to work on this during my lunch break.

Thank you for your sample database, if you had typed an explanation out on all of that, I would have been completely lost! I’m more comfortable with queries so I can hardly wait to try it out.

I have a question though. Where did the T table come from in qryAvailable?

Thank you so much! I can’t wait to try out your suggestions when I get home. Thanks again!!!

That was awesome! Thank you so much.

Another Question . . . Is there a way to save more than one page setup option? This is much better than what I’ve been working with but it doesn’t hurt to ask.

Thanks again – this is a big help.

That was awesome! Thank you so much.

Another Question . . . Is there a way to save more than one page setup option? This is much better than what I’ve been working with but it doesn’t hurt to ask.

Thanks again – this is a big help.