Search results

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. :) .

Haha..this has been going on so long my friend that I forgot exactly what I did to this DB Sample. :) In any case....here is your DB back to you modified. Uhhh...Yes. Good thing I wrote Txt file of what I did :D THE UPDATE FORM - Changed the Reference to Microsoft Outlook 11 Object Library...

Well Craig...I really can't help you much with this one then. It must be something within the Access 2007 Runtime module(s) that's causing this to go a little wonky. You may need to take this up with Microsoft. .

It seems as though you do not have the Windows Image Acquisition Automation Library v2.0l Library referenced within your VBA Editor. Read the earlier posts. .

Next time you get the Error, write down the Error Number. Enter code into the Form's OnError event to handle the errors you want: Private Sub Form_Error(DataErr As Integer, Response As Integer) Dim Msg As String Select Case DataErr Case WhateverTheErrorNumberIs...

What was the Error you received? This could very well be helpful in this case. .