Date Problems on VBA Forms

[georgiboy]

I have posted an example sheet with this in action.

Hope this helps.

[WillieC]

Hi guys,

I've been trying to work out how to use a command button on a form to open another userform. I can't for the life of me work it out.

Can anyone help???

[georgiboy]

Do you mean like this?

Hope this helps.

[Bob Phillips]

Hi XLD,

If you still have the file I sent, you'll see that there are two textboxes that say Mat Date and Act Date. Is is possible that when a user clicks on these that a calendar automatically "pops up" for them to select the date?

That's what I was alluding to earlier, and I would just make it non-visible until you enter one of those textboxes, then use ActiveControl to trap it.

[WillieC]

That's what I was alluding to earlier, and I would just make it non-visible until you enter one of those textboxes, then use ActiveControl to trap it.

Would you have a piece of code that I could insert? I can't get it going.

Cheers again for all your help

[Bob Phillips]

Can you post your workbook again, I have deleted it?

[WillieC]

Removed

[WillieC]

Hi there,

So far the form is working well. I have come across just one problem. When testing the form with more than one user, if they both clicked ok to store the data it come with conflicting interests. How can I program my form so that more than one user can put the data onto the spreadsheet at the same time?

[WillieC]

Morning, XLD. Any joy with my question?

[Bob Phillips]

I thought you had overcome the problem, that is how I read the last post post of yours, and you removed the file.

[WillieC]

I had resolved the previous problem. The one I have come across now is that 2 users can't enter the same data at the same time. If they both click ok at the same time then a conflict error comes up.

[WillieC]

Hi there,

I've uploaded the file again in the hope that you or somebody else can help, XLD.

Basically what I need done is for two or more users to be able to click OK at the same time and for the data to go onto the worksheet instead of getting conflicting errors.

Apologies for being a nuisance but this is doing my head in lol

[Bob Phillips]

Sorry, there is no point in hoping that I will help, I avoid shared workbooks like the plague and have no idea of how to solve the problems that they create.

[WillieC]

No worries, XLD, hopefully someone else can help.

Thanks for all your help so far. You've been a star

[WillieC]

Another question for you guys if possible.

How do I have it so that if a certain option is chosen from a combobox then other fields are greyed out and can't be used??

[GTO]

Presuming you are using the combo boxes as drop-down lists (no editing), you should be able to use the change event of the combo box and trap either the val (if single col box) or better yet, the list index.

[WillieC]

Presuming you are using the combo boxes as drop-down lists (no editing), you should be able to use the change event of the combo box and trap either the val (if single col box) or better yet, the list index.

Sorry, GTO, what do you mean? I'm quite a newbie when it comes to VBA

[GTO]

...How do I have it so that if a certain option is chosen from a combobox then other fields are greyed out and can't be used??

Hey there WillieC,

Presuming you were asking as to disabling another combo/text/similar control based on a certain value (option) being chosen, I was just answering that this is possibly a couple of different ways.

Here's an example that disables the 'AddRemove' box anytime that "Mat Form" is chosen in the 'WhereFrom' box.

Mark


[VBA]Private Sub cboWhereFrom_Change()
If cboWhereFrom.Value = "Mat Form" Then
cboAddRemove.Enabled = False
Else
cboAddRemove.Enabled = True
End If
End Sub
[/VBA]

[WillieC]

Hey there WillieC,

Presuming you were asking as to disabling another combo/text/similar control based on a certain value (option) being chosen, I was just answering that this is possibly a couple of different ways.

Here's an example that disables the 'AddRemove' box anytime that "Mat Form" is chosen in the 'WhereFrom' box.

Mark


[vba]Private Sub cboWhereFrom_Change()
If cboWhereFrom.Value = "Mat Form" Then
cboAddRemove.Enabled = False
Else
cboAddRemove.Enabled = True
End If
End Sub
[/vba]

Hi Mark,

That's worked perfectly. Thanks very much mate.

Just two other things that I could do with some help with.

1. When more than one user is using the form, if they click on OK and Save at the same time, a conflict error comes up as the form tries to enter both sets of data into the same row. Any ideas how to solve this?

2. When a user opens the Form, I'd like Excel to minimize so that the form will appear on screen and can be used without having to have Excel in the background.

Thanks again for all your help

[WillieC]

Hey there WillieC,

Presuming you were asking as to disabling another combo/text/similar control based on a certain value (option) being chosen, I was just answering that this is possibly a couple of different ways.

Here's an example that disables the 'AddRemove' box anytime that "Mat Form" is chosen in the 'WhereFrom' box.

Mark


[vba]Private Sub cboWhereFrom_Change()
If cboWhereFrom.Value = "Mat Form" Then
cboAddRemove.Enabled = False
Else
cboAddRemove.Enabled = True
End If
End Sub
[/vba]

Hi Mark,

That's worked perfectly. Thanks very much mate.

Just two other things that I could do with some help with.

1. When more than one user is using the form, if they click on OK and Save at the same time, a conflict error comes up as the form tries to enter both sets of data into the same row. Any ideas how to solve this?

2. When a user opens the Form, I'd like Excel to minimize so that the form will appear on screen and can be used without having to have Excel in the background.

Thanks again for all your help