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: *

  • Users: Scootman
  • Order by date
  1. Scootman

    Change text box properties based on listbox values?

    I meant to also say that I did give HarleyQuinn a much deserved star for his code too.
  2. Scootman

    Change text box properties based on listbox values?

    PHV, your code works perfectly, but I also figured it out at work this morning when I was looking at Remou's code (I don't have internet access at work, so I wasn't able to let you guys know earlier). Here's the code I use: Dim i As Integer Dim strdays As String For i = 0 To List214.ListCount...
  3. Scootman

    Change text box properties based on listbox values?

    PHV, I tried taking the list box's values (selected or not) and returning them through code. I also tried using strings to temporarily store the SQL query results, but that didn't work either. I'm self-taught Access knowledge and I've never done anything like this before, so I don't know...
  4. Scootman

    Change text box properties based on listbox values?

    I have a problem that's been really bugging me the last few days. I tried looking through search, but I think my problem is a bit more unique than I first thought... I have a form that contains a list box and 37 text boxes. The text boxes have the names of d0 through d36. When the form is...
  5. Scootman

    Error Message Questions for when append query fails

    Zion7, I was able to learn a bit more about the CurrentDB.Execute syntax over the past day and a half (now I can go to sleep!!!...just kidding...). Here's some data verification I added: If cmboTypeRequest = "Address Change" And Nz(Me!txtNewAddress) <> "" And txtOSO <> "r" And...
  6. Scootman

    Error Message Questions for when append query fails

    I meant to clarify: txtNewAddress is the text field on the form that appends to the NewAddress memo field in the table (its the person's mailing address) I'm actually bypassing the combo boxe's value by just typing it in as 'Address Change' (it appends to the ReasonRequest field). All the...
  7. Scootman

    Error Message Questions for when append query fails

    Zion7, I really appreciate your help and attention. With your example and with some others here on Tek-Tips (searching always helps!), I was able to get the following to work: CurrentDb.Execute "INSERT INTO [tblDateRequested-Temp](PersNo, SSNo, ReasonRequest, NewAddress, DateRequested...
  8. Scootman

    Error Message Questions for when append query fails

    Zion7, I looked at your code and I don't know if I can convert it to a version for my needs because the append query reads from another query that uses information from the form as its criteria. Its rather confusing. I thought about putting in an error handler that displays a message box (or...
  9. Scootman

    Error Message Questions for when append query fails

    Thanks for the response Zion7. All the fields that are appending are unbound on the form. Most of the fields are ones that I set depending on what was brought up from the Lookup. Since most of the records append without any problem, I can only assume that the problem is coming from what the...
  10. Scootman

    Error Message Questions for when append query fails

    Nevermind on this question/post. I was able to figure it out using the Generic Error Handler and Error Log Table FAQ. Thanks.
  11. Scootman

    Error Message Questions for when append query fails

    Well I did find a FAQ about Generic Error Handling in the Modules FAQ. http://www.tek-tips.com/faqs.cfm?fid=6245 I looked a little of it over. While its a bit advanced and complex for me (I like how the first sentence of the FAQ said 'A rather simple routine...'), I can try to figure it out...
  12. Scootman

    Error Message Questions for when append query fails

    Hi all, I looked through many posts on the forums for a solution to this problem, but I couldn't find any help. I've created a mult-user database that serves as both a look-up tool and a way for them to submit new records. Most of the records that are being submitted will get appended...
  13. Scootman

    Help Needed Appending Excel Worksheet Names

    Your code worked perfectly PHV! I simply replaced: For Each adoTable In adoTables MsgBox adoTable.Name Next ...with your code and then I created the Access table with the fields Workbook and Sheet and voila! Over the few years that I've been looking around Tek-Tips, I've seen your responses...
  14. Scootman

    Help Needed Appending Excel Worksheet Names

    Hi, I've been part of Tek-Tips for quite a while and I think I may have posted only a few times in the past. Most of the things I learn are from reading answers after searching for them. However, I couldn't find an ansewr for this one. I have the following code that's only partially modified...
  15. Scootman

    Javascript limitations, or maybe not?

    I got it working. I don't know how, but I added more and it just started working. There weren't any error messages previously. It bugs me that I didn't know what was wrong, but oh well. Tracy, thanks for the tip about database and, and iframes too. I like PHP, but have had problems with it...
  16. Scootman

    Javascript limitations, or maybe not?

    Okay, forget the "No more" part of my post above. I neglected to think that would stand out so much in my message. The one and only helpful thing I did learn from reading a Javascript book is that there are no error messages when your code has no error. There's nothing wrong with the syntax...
  17. Scootman

    Javascript limitations, or maybe not?

    Bear with me here please. Yes there's a lot of reading and I know I'm not following the tek-tip tip on how to write a "good question", but pobody's nerfect. Plus I think a good question is where somebody describes everything at once, rather than explaining it in 10 more posts. In other words...
  18. Scootman

    Two List Boxes, Need a Line Break In Descrip. Box

    Just a quick related question: Is there a limit to the number of \n instances? If I wanted to create a list of 50 to 100 items, each with \n entries for line breaks, then I'd be okay right? Sure it might be messy, but I'm used to that - I write code in Excel for a living. Thanks!
  19. Scootman

    Two List Boxes, Need a Line Break In Descrip. Box

    It works perfect...Awesome! I remember seeing \n mentioned somewhere in a function during my long searches for an answer, but it made no sense to me at the time - I ended up skipping it. I can now use this code for just about every list I want to make for my double combo boxes and triple combo...
  20. Scootman

    Two List Boxes, Need a Line Break In Descrip. Box

    I posted this in the wrong forum and was told to try the Javascript forum (since it is JS). From the code below, I want to make it possible to enter a line break in the text_array portion. Currently, it can't happen because of the way the array's setup (they won't let me put in HTML coding)...

Part and Inventory Search

Back
Top