Search results for query: *

Thanks for all your suggestions, what I did was move my table into the user database and setup an append query that was based on any invoice numbers that werent in the user database. I spent most of yesterday deleting those test invoices that i had created. Everything seems like its in order...

I had two databases on our server, one for the users and a second for me to work on updating the user database. They were named differently and I (so did everyone else) thought it was apparent which was for which. BUT, today I find out someones been entering their invoices into my database. SO...

Hey Jebry, While yes, this textbox holds a status, my real concern is with the general concept, itself. I understand why and how you cant reference a textbox unless it has focus, but the error comes when im clearing a textbox, after ive given it the focus. (in the beforeupdate event of a...

Thanks Jebry that worked perfectly. I have another question based on an error that ive received a couple of times. When I write this type of line in textbox1 BeforeUpdate event: Me.textbox2.Text = "" I get error number 2115 which states: The macro or function set to the...

I'm having some problems setting little internal control type procedures for a textbox in Access. I have a textbox that is ONLY visible if a certain date is entered in another textbox on the same form, I need this textbox to be required when its visible. (Ive asked this question before). So...

Alright, some of that makes sense, some of it doesnt... Where/how/when do i define blnoktoclose?? ive never used a boolean, does it return the data as a number defined as the set of characters?? or what? Heres more detail on my situation, I have two textboxes with dates, if, in the second...

Hey jaz, Thanks alot for your help in my other post, setting the code in the beforeupdate event stopped it from moving to the next textbox when the criteria was met. As far as this go, maybe im a bit confused... You say set a checkbox to be checked if/when the textbox becomes visible? How...

I have a hidden textbox and I'm trying to make it "required", but only if its visible. I used the Len argument, heres my code: this is in the BeforeUpdate event If Len(Me.Processing_Comments) = Null Or 0 Then MsgBox "Please Explain Yourself" Cancel = True End If I...

The reason I hesitated with the Before or After Update events is becaused I thought the user would still be able to tab out of the textbox once he gets the msgbox, as long as he didnt "update" the textbox. Maybe I'm wrong about how these events worked, but I thought the before and...

that doesnt seem to change anything. Thanks though, Jaz I dont understand why it would move to the next textbox, is there anything inherent in the lostfocus event that would make it move to the next field? Theres something really small that im overlooking, i can feel it. either that, or my...

Something else along the same lines, I have textboxes that appear only if a certain criteria is met, such as, if a certain choice from a combobox is picked. I need to design it so if that textbox becomes visible then its a required entry, so if the user trys to tab out of it a msgbox or some...

In my form I have an InvoiceDate and ReceivedDate text box. In the ReceivedDate_LostFocus event I have this code: If ReceivedDate < InvoiceDate Then MsgBox &quot;Enter a Received Date that is later than the Invoice Date.&quot; ReceivedDate.SetFocus ReceivedDate.Text = &quot;&quot; End If The...

Hey sawatzky, Thanks for the idea with the validation rule, but when i tried it in access(table design view) it said i couldnt use another column as a validation rule, so im assuming you meant in VB, ive been trying to figure it out but dont quite understand how to set validation rules through...

OK, new thought, unrelated yet somewhat along the same lines. In my form, the users enter an invoice, received and approved date. I wanted to set it so if they entered a received date that was before the invoice date, it would msgbox them and have them reenter a date, as that would be...

hey kenG and sawatzky, The default setting for the textbox is .visible = false, the textbox only shows up on the form if the approveddate is more than a week past the receiveddate. I have that part programmed though, and the textbox only appears when the criteria is met. My problem is that i...

hmmmmm, maybe im not doing this right, heres how my code looks: If Len(Me.Processing_Comments) = 0 And Me.Processing_Comments.Visible = True Then MsgBox &quot;Please Explain Yourself&quot; DoCmd.CancelEvent End If I try it both with and without the .Visible = True and nothing happens, you...

Hey KenG, I had the condition part setup but i wasnt sure about making the textbox &quot;required&quot;. Ive never used Len, but it seems its for a number(??), i need an explanation(string), I dont know if that makes sense, if i still need to use Len, then = 0 works for string as well?? how...

How would I go about making a textbox required?? but only if a certain criteria is met and the textbox then becomes visible in the form. Should i just make it required in the table?? maybe a validation rule?? Or should(could?) this be done through coding? Maybe something in the GotFocus...

You know how they say, you learn something new everyday??? Well, thats why i come here everyday. (i try and stop by even on weekends) This is a greatly designed, run and moderated forum. I hope it(and all of us) keep it going for a long, long time. Thanks to everyone, especially the...

im not using any modules and all my forms, reports and tables use different names. I'm still rather confused. Everything worked fine yesterday. But thanks for the thought Lonnie, I asked about this on another post in this forum, but maybe someone reading this can help. I have a textbox...