Search results for query: *

Thanks PHV. That is one I did not try. I knew Cancel wans't right...I just never thought of something that simple.

Great...I found the problem...I forgot to change the "Else" portion. That was very helpful...thank you.

I figured it was something like that...however, I tried that and it is still sending the text boxes way off. The measurment I have is from the Properties menu

Well, I actually errored in my subject. What I really need is when this particular text box equals "T", then I don't need this other text box to display and I want to move another in it's place. So I used OnCurrent for that, and on the text boxes after update event I used Form_Current. I am...

I have never tried changing the position of a text box on a form which is probably why I am doing it wrong...I simply tried the following: On Current: If Me.textbox = "T" Then Me.textbox1.Visible = False Me.textbox2.left = 1.333 Me.textbox2.top = 1.8333 Else Then...

Thank you.

Can somebody help me figure out why the dropdown portion of the following code gives me the error: "You can't reference a property or method for a control unless the control has the focus." This code works for me on other combo's, and it actually works for this combo, but it gives me that...

Nevermind. I found the problem.

I have a query where I use a simple "Like [Enter Number]" to open a form. What is the best way to approach when no record is returned? I just want to put a message box saying there is no record matching that criteria...then cancel. I've tried OnOpen and OnLoad, but thats not working. Any help...

Bam...that was it Melagan. Thanks for all your help. It wouldn't even catch that in the immed window for some reason. I don't know. My head is spinning now.

I like that method. I am still getting the same error. I can't find where in this string I am going wrong. I narrowed it down to strSQL2, but I'm stumped...the error is telling me number of fields is not matching the string, so I can only assume I have a comma in the wrong place and I can't find...

Okay, there was a problem with my dlookup string that I fixed. Now I am getting the error "Number of query values and destination fields are not the same" Here it is: Dim strServerName As String strServerName = DLookup("ServerName", "tbl_Servers", "ServerID ='" & [cboServerID] & "'") & "')"...

You guys are a lot of help. I am close. I am trying to run 2 different "INSERT INTO" commands in the after update event, and it just doesn't work that way apparently. I get an error "2001" that says "You cancelled the previous operation." Here's the code I am using: Dim strServerName As String...

I just yesterday got a lot of help on this, and learned a bunch, but I guess not enough. See Thread705-1391485 I am trying to add the last string, but obviously DLookUp is not the proper format, or I am doing it wrong: DoCmd.RunSQL "INSERT INTO tbl_Activities(EntityID, ActivityDate...

Great.

We'll, I guess one more thing...I do I trap and disgard the "About to append" warning?

There it is...thanks so much.

Boom...that was it. Now I actually forgot to add one more item...that is "Activity Code" which is "WE" which is "Work Order Entered". I added it as follows, but I am getting the old "Missing Operator Error", and SQL is foreign to me. It is just a text value. DoCmd.RunSQL "INSERT INTO...

Ok, I am getting s "Syntex Error in INSERT INTO statement" Does it look right? DoCmd.RunSQL "INSERT INTO tbl_Activities(OrderID, ActivityDate, ActivityTime, EmployeeID" _ & " VALUES (" & Me!txtOrderID & "," _ & "#" & Format(Now, "yyyy-mm-dd") & "#," _ & "#" & Format(Now...

Only because that table already has date and time as 2 fields.