Replies

This works great! Thank you very much.

Big help – thanks!

How easy is that!!!

Thank you very much!
🙂

Hans – I can’t thank you enough!

Thank you, thank you, thank you.

I found it – sorry about that!

Before you sent over the code to open to a new record, I had put a cmdButton directly on that form to try and work around it. I’ve taken the button off now it’s fine.

Oh Happy Days! Thank you SO MUCH for the support!!!!

I found it – sorry about that!

Before you sent over the code to open to a new record, I had put a cmdButton directly on that form to try and work around it. I’ve taken the button off now it’s fine.

Oh Happy Days! Thank you SO MUCH for the support!!!!

It worked on all but the Split-Everyday tab. I don’t see anything different between that one and the other ones though.

With Allow Edits = No, I can no longer select an item or option on sfrmDirSplitEv, even though I’m trying to ADD a new record to the tab.

That’s great!!! 🙂

Don’t hate me!!! Can you help me with this part too: if they try to type in a field that already has data in it, they could get a pop up msg “HANDS OFF BUDDY” (lol) and when they close the pop up, force the cursor into some other field or a blank text box.

If I know how it’s supposes to be set up for one or two, I can copy and change the filed names for the others.

I couldn’t reply to your last inquiry. Yes, I tried to attach the database with frmTARGET on it but it was too big.

It was too big to attach so I stripped it down.

Hey, I have an idea. If it can’t be set up so that they can not change something that was previously submitted on the tab control, can you tell me how to write a different code.

What I’m thinking is, if they try to type in a field that already has data in it, they could get a pop up msg “HANDS OFF BUDDY” (lol) and when they close the pop up, force the cursor into some other field or a blank text box. Just a thought, I’m drawing at straws.

It would be great if the first record on each tab was a new record so they would start with the one that they are going to fill in instead of a previous record.

We allow members to SPLIT product with another member and code them both as carrying it. In order to submit the request to the Directory dept. we need to provide them with the member number of the purchasing shop or they won’t process it.

I had a msg pop up which reminded the Rep that they had to fill in the purchasing shop #, if it was blank. Now that it’s on the tab control, it stopped working. Would you mind looking at that for me also. I sent the attachment over on the last post.

Thank you SO MUCH.

When the attached form is opened, I would like to allow the Rep to view previous request but only be able to enter a new one.

Hans! I didn’t realize that you had replied back to me. I must have clicked it early this morning and I’ve only taken the time for new mail so it was overlooked.

I have been pulling my hair out. They sent me to an access class in the Spring but gave me very little time to apply what I had learned. Now they expect me to rebuild a new database for the team overnight. My boss has been on vacation all week and is going to think that I’ve been sitting around doing nothing but honestly, I have been trying to remember the few codes that I learned so I could apply them. I frantically went through my class book and examples and have been able to apply some of the things that I learned but I’m about in tears.

As I mentioned, I didn’t realize that you replied back and I couldn’t get anything to work so, I remembered what you had suggested at another time and I went with the tab control. It isn’t really what I wanted to do but I’m afraid that, what I KNOW that it can do and what I have the knowledge to MAKE IT do are two different things.

Will you please help me with the last piece of this feature.

I have a frm (frmDirectoryRpt) with a tab control on it. This form will need to be opened from the mainform (frmTARGET).

The problem that I have is, instead of entering in NEW request, in the past, the Reps have altered existing one. This doesn’t work for countless reasons and has been a thorn in my side. When the Rep opens frmDirectoryRpt to submit a new request, I don’t mind if they can view prior requests but I don’t want them to be able to change them.

Each tab has a frm on it (i.e. sfrmDir_SplitEv) with a subform based off of a table (i.e. tblDirectoryCodes) in Datasheet view.

Every time frmDirectoryRpt opens up it has to be linked to the JDE field on frmTARGET (JDE to JDE) but I don’t want them to be able to make changes. I’ve trying opening frmDirectoryRpt with a cmd button, with OnClick set to a macro, opening the form in Add data Mode but then I lose the link to the JDE on frmTARGET. I tried to figure out the filter part of the macro, thinking that’s might make it work but we didn’t cover that in class and I just can’t get it. I tried to set the Allow Edits and Allow Deletions to No on the frm but then it won’t give me a new record either.

I’m too frustrated to type anymore. Does any of this make sense and can you offer any suggestions. Someone tried to help me with the link thing the other day from the lounge but they went way over my head and I tried to research the suggestions that they made and just got more lost and confused.

Hans,
Will you please help me adjust the code so the input box doesn’t keep popping up if the Purchasing Shop # has been filled in? Sometimes they are selecting 10 items and although I don’t want the Rep to forget to enter in the purchasing shop code, I don’t want it to drive them crazy either.

Also, I couldn’t get the Purchasing Shop to stay on the form if it was filled in. Every time I closed the form and went back into the same record, it was hidden again.

Private Sub Split_Click()
If [Split] = True Then
Me.Parent.txtPurchasingShop = InputBox(“Enter the member number for the Purchasing Shop.”, _
“Purchasing Shop”)
If Me.Parent.txtPurchasingShop = “” Then
Me.Parent.txtPurchasingShop.Visible = False
Else
Me.Parent.txtPurchasingShop.Visible = True
End If
Else
Me.Parent.txtPurchasingShop.Visible = False
End If
End Sub

Thanks again,
Theresa