Search results

It is the best way, but I did see one where it had to be in another event, but it had to waite for a couple of functions to finish before doing the requery. Ohwell, glad I could help.

No, it is coded in. In the OnEnter event of the tab try something like: Me.TabName.forecolor=vbOrange You can us the color number that you see in the forecolor property under the all tab of the property window. Then in the OnExit event of the tab try: Me.TabName.forecolor=vbBlack I also like...

The txtbox on the subformis called PartNo and one of the txtboxes I am looking at on the parent form, main form, is called CustomerNo. If when the user tabs into PartNo and CustomerNo on the main form is Null, then I get a message telling me that and I setfocus on CustomerNo on the parent form...

You can always use the .forecolor property in the tab control onEnter and OnExit events to have it cange color and change back. And you can do that with the labels in the fields, but there you use the GotFocuse and LostFocus events. FYI4U.

Yes, again, it is just personal taste. I right align almost everything, except things I want to stand out, then left align comes into play and it does stand out, almost like a sore thumb. hth.

In the combo boxes GotFocus event put: Me.MyComboBoxName.Requery Make the name substitution and that should do it. hth.

Personally the one one the right. FYI, I would not Center Align anything. Personal taste.

Good afternoon, I have a form with a subform and in the first txtbox of the subform in the GotFocus event I have a little procedure which checks the txtboxs on the parent to make sure that there is data in all four of the txtboxes. This works great the first time and it pops up a msgbox and it...

This is almost like archiving, so I would normally go wiht an append query. The best way to do it is copy the main and paste it with a different name. Then delete the data in the new table, it is ready to go and once you redo the appends query I think your problems will be gone. Oh, if you...

There is nothing wrong with Append queries, I use them for archive old records. It is very import that the two tables are exactly the same, except for the table name, which can even be in a different dbase. You could use recordset or recordsetclone to also do the job for you, if you are good...

Interesting, I rarely use queries, but then I have a lot of code in the forms. I use recordsets to do the things I want to do. But it is always good to get other points of view.

If you decided to use the newrec then that is exact you you are getting, the second form opening to the CoID and ready to add a new record.

I would use something like this to open the second form: Dim stDocName As String Dim stLinkCriteria As String stDocName = "YourFormName" stLinkCriteria = "[CoID]=" & Me![CoID] DoCmd.OpenForm stDocName, , , stLinkCriteria This is in the OnClick event of the cmdButton. I have...

Is this a form/subform or two separate forms? If it is the form/subform, I would check the parent/child relationship in the form and subform properties. hth.

Thank you for the response. I tried that, but with the dropdown the default is not being hi-lited. I did try this and it appears to work: Private Sub CreditType_GotFocus() Me.CreditType.ListIndex() = 0 Me.CreditType.Dropdown End Sub I have not found anything that works better than this.

Good afternoon. I have a combo box which in GotFocus I have it dropdown, in otherwords open. I would like to know if it is possible to then hi-lite or select one of the lines in the combo box? In other words, set a default for that combo box, so the person entering the data could just click...

Thank you, Jet. Works like a champ.

I have a procedure which can put in a Restocking Charge, it works good but you have to type it in each time here it is: Dim strInput As String Dim strMsg As String strMsg = "Enter Restocking Charge?" & vbCrLf & vbLf & _ "Enter percentage." Select Case MsgBox("Is There a Restocking Charge?"...

You might want to replace that NIC. When they go, they just start spuing out grabage. Maybe that could be part of the problem, NIC aren't very expensive any more. hth.

A programer at Boeing explain it to me once and she told me that environ was a system command and it dated way back to the days of DOS. How true that is I am not really sure, but everything else she told me was 100% correct. That is why I mentioned to look at the users account up on the sever...