Search results

Gggrrr..second time I've lost a message here today just after typing it.....*sigh* Anyway, I would like to know how to put a pause into the code without requiring user intervention. Resume On Error is in affect, but the program is truely working 100% correctly during step through, as I have...

I doubt that the forum would be very happy if I tried to post the code here. THe code calls on several modules and in total, the code is very long. I can explain....all I'm doing is running Me.ListCompleted.AddItem strCompleted after returning from the Function that actually writes the...

I don't know if you're trying to send an internet link of an e-mail adress link, but it would be really helpful ito know details. If you type "Mailto:" before an e-mail address, Outlook (I'm currently on XP) will convert it into a hyperlink. I tried omitting the "mailto:" and it did not...

Why are you only using .movelast on the recordsetfor you assignement of estid and newid values? If you only want to change a single record, then you shouldn't need a recordset. Also, you have an sql2 string declare and do nothing with it? Oops...forgot to add that it might be helpful if you...

I've never done that, but you might find this link helpful: Appending Text files Good Luck!

HELP! I have tried using a listbox and a textbox to display table names as they are exported to Excel. At the end of a successful export, the table name is either added to the value list in the listbox, or added to the end of a growing textbox ( I prefer the listbox, but it's not important)...

I know this is an old message, but no answer was posted. I didn't stop to actually download the zip file, but I ran into this issue borrowing a piece of someone elses code and just changed the action to .Save. There is no reason to use SaveAs, unless you really intend on offerring the ability...

Thanks....logic seems to be right. They've taken the SQL Server down for quick maintenance (5 hours ago), so I'll test it when it's up again. THANKS!!! I'm sure it will work:-)

So, at the moment you're using a form to launch Word 2003 and prompt the user for the criteria field? Is it pulled from a form? If you provide the user with the ability to provide the criteria prior to the merge, then I would assue that you can declare the parameter and then make the data...

What is the repeat or unrepeating data that you are looking for from the main table to the lookup to the second lookup? It sounds like you have data structure issues too if you're worried about duplicate entries in two levels of lookup tables. You may want to consider latering your table...

Sounds a little unclear, but you said that you're trying to find records in the WBS table where WBSL3_ID matches the WBSL3_ID. Could you post your query here. It would be helpful to see your JOIN, bucause your relationship in the tables seems like it should be handling the return record...

Are you just pushing a data update? If so, are you sending only new data to append, data updates, or a combination? Do you have access to alter their access database to create a form for them to process up import of data, are you HOPING to push it all from your end, or does your user know...

THanks! :rolleyes: Feeling silly...I think I'd tried the (strShtNm) before, but I guess I was trying so many things that I'd misinterpretted the error. I'm getting an Item Not in Collection error from...

Should be a quick and easy one...I'm trying to run through several queries to output all of them into excel on different pages. I'm able to do this with tables no problem. I can run queries with the code individually now that I figured in the Parameter pre-declaration. The issue now is...

Why not use the query wizard to find unmatching records. If you're worried about what to compare then use your intermediate table which contains the links between the two (should not just be a look up, you should have a table to actually create the relationship between the two tables), to...

Pulling my hair out :) First issue resolved. It wasn't an issue with the code in the query, it was actually the fact the the strings were compounding without resetting before each inner loop :rolleyes: So, my only issue now is why does the below code not work: Set rs =...

Word 2003 Allows you to create your query or filter inside of Word as well, so when you design the mail merge, you can implement the file number selection there. If your users have access to the database, then just provide them a form to input their "file number" and then use an embedded report...

You very clearly stated that you have an autonumber, boolean, and text field in each table, but then you said that you stored Model in the Boolean YNF2 and then you're trying to set the T1.YNF =False WHERE T1.T1ID = '" & Model.Value & "' '" & Model.Value & "' is a string and you're trying to...

Stuck Again Okay....I can't get this dynamic "fields" portion of the query to work. Can someone please let me know what I'm getting "To Few Parameters, Expected 5" ... " SELECT " & strFieldNames & ", '" & strMoreFields & "'" & _ " FROM " & strShtNm & "" & _ " WHERE...

Unfortunately the data is being written into Excel and not Access Reports. I've found a way of doing it using yet ANOTHER recordset to query for the field names for each table. So, all should be good. Sucks that this seems to be getting so complicated.