Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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