Recent content by CyberLynx

Great Job wiklendt. I'm certain your solution will help many others in the time to come. Thanks for posting. .

I see now what you are trying to do. You want to add a Description to the Table within the Database Object Window. Off hand....I'm afraid I can't help you. The code I posted is for changing the properties of a Field within a Table. Obviously no good for what you want to do. But this now...

To answer your question......No. I don't have a clue what situation you have there nor am I sure of exactly what you are trying to do. I can only assume at this point and to be honest that is sketchy at best. Is this for a Audit Log of some sort? History? What exactly are you trying to...

I'm not sure in which Form Code Module your sub procedure resides in but if your intent is to go to a new Record in the Form name Line, have the User fill the record then Close the Form named Line and open the Form named HPSB Home Screen then you can't since the Form Line will be closed right...

In my opinion, if you want to dynamically change the Code for a control during runtime then the best way to do it is by using Functions. For example, let's say you have code now contained within the OnClick event for a Command Button named CmdButton. And for argument sake let's say this code...

Most likely your Form is Corrupt. There is no repair for this that I know of other than deleting the Form then copy and paste in another from a backup .mdb. First check the References within the VBA Editor. Make sure none are indicated as MISSING. If there is then reestablish them and then try...

Try this: Dim strFilterCriteria As String strFilterCriteria = "" strFilterCriteria = strFilterCriteria & "[irregular] = " & Me.filterirregular.Value If Len(strFilterCriteria) <> 0 Then strFilterCriteria = strFilterCriteria & " AND " strFilterCriteria = strFilterCriteria & "[popup] = " &...

nIGHTmAYOR, I found your article to be very enlightening and I will definitely be playing with it when I get time. Thank you for sharing your thoughts and solutions and for participating as a Solution Provider within this Forum. Keep up the good work. .

For what you want to do you will need to do it through Conditional Formating. How many specific Conditions do you want to deal with? Conditional Formating can also be set with Code but it can get quite involved if you want to go beyond the current three conditions available to set. Changing...

It's just that hard coding a name into your code is rather odd. Normally you would reference another control which contains the name to compare to but to each their own. Try this: If Me.JobNo = 4999 And Forms("frm_Vehicle")("VehicleTimesheetSubFrm").Form.Driver.Value = "Persons Name" Then...

In my opinion to do what you want you will need to pull up a Recordset of the Parts Ordered based on the Customer ID and the Order ID then format the Fields returned from that Recordset into a String variable which you would then ultimately apply to the TextBox. By formating I mean alignment...

Martin, it still isn't quite clear what you want to do. Is it that you want to populate the frm_homepage with Records that were entered by the User Logged in? This would of course mean that each record that would populate the Form must contain a reference to the User. More detail please. .

Working with a Sample DB of your situation would be helpful here. .

Enie meenie minie mooe I'll take em all by the toe. Use them all if you like. Allow the option to do so if you desire. You have personally listed off three alternatives and this tells me that you can see the possible benefit to any one of them. It's all a matter of how versatile do you want to...

You would probably find better success if you supply your Sample DB with some fictitious Data. I personally don't want to fill all that in and I don't have the time to figure out where to start. But hey......that's just me. :) .