Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rutkus

    User Error: How Do I Append Tables in Different Databases

    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...
  2. rutkus

    User Error: How Do I Append Tables in Different Databases

    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...
  3. rutkus

    Textbox Peculiarities

    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...
  4. rutkus

    Textbox Peculiarities

    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...
  5. rutkus

    Textbox Peculiarities

    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...
  6. rutkus

    Suggestions for Requiring Entries

    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...
  7. rutkus

    Suggestions for Requiring Entries

    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...
  8. rutkus

    Suggestions for Requiring Entries

    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...
  9. rutkus

    Textbox Criteria on LostFocus Event

    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...
  10. rutkus

    Textbox Criteria on LostFocus Event

    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...
  11. rutkus

    Textbox Criteria on LostFocus Event

    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...
  12. rutkus

    Textbox Criteria on LostFocus Event

    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...
  13. rutkus

    Requiring a textbox, but only if its visible

    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...
  14. rutkus

    Requiring a textbox, but only if its visible

    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...
  15. rutkus

    Requiring a textbox, but only if its visible

    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...
  16. rutkus

    Requiring a textbox, but only if its visible

    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...
  17. rutkus

    Requiring a textbox, but only if its visible

    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...
  18. rutkus

    Requiring a textbox, but only if its visible

    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...
  19. rutkus

    Just glad to have found this site.

    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...
  20. rutkus

    New Error Message (wtf??)

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

Part and Inventory Search

Back
Top