Search results

Hmmm... that doesn't sound right. It sounds like you have some other issue happening b/c when I tested the sample code I posted earier, I didn't have that happen. One thing you could try is to add a step to check if DaysAval is Null and if it is run the code; if not, skip it. This would cause...

I don't think you need code at all. In design veiw of the form, from the PROPERTIES window, lock the three fields in question (PROPERTIES -> DATA tab -> LOCKED = YES). This will lock those three fields for manually changes, but will still allow you to change the value of the controls via your...

I have a very limited knowledge of VB, but to open a form in VB (not VBA), the call is: FormName.Show You don't have to use a DoCmd call. Does this answer your question? jamie

What is preventing you from filling in the days manually at this point? Are you getting an error? Here's what I would do: -------------------------- Private Sub Form_Current() If (FullTime) Then If [Years_of_Service] >= 7 Then Me.DaysAval = 30 ElseIf [Years_of_Service] < 7 >= 5 Then...

Maybe I've misunderstood what you are trying to do, but I think you need to use the AfterUpdate event of the LastName field. It should read: Me.ChildLastName = Me.LastName Is this it? jamie

Thanks for your reply! Everyone's suggestions got me to where I needed to be! My problem was two fold. First, I didn't have my variable set up right. It needs to be: "Public frmFormName as Form" Second, I was setting the value improperly. I was using: "frmFormName = Screen.ActiveForm" I...

Thank you both for the replies... I'm grateful you waded through the short novel I posted. Unfortunately, I don't think I explained myself very well. Let me see if I can clarify. First, to answer Jack's question, each parent record can have only one contact associated with it, but a contact...

Hope someone can help... I'm about to go insane! Here's the scoop... I've got a subform that appears on several parent forms. The subform shows the name and contact infomation of an individual related to the parent record. The parent record has a field called Contact_ID which is what the...

You can use the OnDirty event of the Customer form to update the DateUp field when someone changes any info on the form. It's would look like: Private Sub Form_Dirty(Cancel As Integer) Me.Dateup = Date() End Sub js [This message has been edited by jstutz (edited 07-09-2001).]

I guess my first question is why do you have the same checkbox in three tables? I should think you wouldn't need that. It's very possible that I'm not thinking out-of-the-box enough, and perhaps there's a really legit reason for needing this. It just seems to me that this breaks table...

Now I don't know... here's some posts I found... maybe they'll be helpful http://www.access-programmers.co.uk/ubb/Forum1/HTML/002199.html http://www.access-programmers.co.uk/ubb/Forum7/HTML/001213.html js PS-Sorry.

I just tried to find the post without any success, but in a recent post someone had similar problems. If memory serves, the reply to the problem mentioned that Access, when running queries, filters, etc. only "deals" with dates in US format. I think you might be running into a similar problem...

For the Car -> Cars and Truck -> Trucks, make the following mods to the properties of your Combobox on the report: ON THE DATA TAB: Control Source= Classification Row Source Type= Value List Row Source= "car";"Cars";"Truck";"Trucks" Bound Column= 1 ON THE FORMAT TAB: Column Count= 2 Column...

No prob!

Are the two fields you are using for Building and Location a consistant length? If so, since your update works if you set the values of the two fields manually, instead of trying to auto-update the address from the combobox, use the combo box to populate the two key fields and THEN call the...

Check your Regional Settings in the Control panel of your computer. Sounds like your Date format has gotten changed for your entire computer. Under Regional Settings is a tab called Date... that's where you can change it back. js

I've been having some problems w/ ActiveX Calendar controls recently and wondering if anyone else has had similar problems OR better yet knows a solution. In a nutshell: I have a couple of DB's originally dev'd in Access 95 using ActiveX Calendars on some of the forms. The controls are used to...

Thanks!

I am writing some code that updates a group of tables by deleting the old ones and then creating new ones using some MakeTable queries. My question is this: Is there some code I can use to determine if the table already exists? Basically, I want to add an If/Then statement that checks to see...

Great! Thanks very much! I knew it was simple, but could not remember how to do it! Jamie