Recent content by Scootman

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