Search results

So I gave up and just hid the status bar from File >> Options. Thanks for the help @isladogs!

I am creating spreadsheets from a recordset as shown below. Do While Not rs1.EOF sqlStr = "SELECT Transsend_M3_Var.APP_USERNAME, Transsend_M3_Var.Last_Name, Transsend_M3_Var.First_Name, Transsend_M3_Var.Job_Code, Transsend_M3_Var.Job_Title...

Thanks isladogs! I'll give it a try in the footer.

I'm not sure I want one directly on my form, but could something like that be put into a message box that displays until recordset.eof?

I have implemented some code within my recordset to display a progress bar that will overwrite the "Running Query" message that flashes while cycling through my recordset. The problem I've run into is that while this piece does work and display... SysCmd acSysCmdInitMeter, "Updating..."...

Yes it does, I just added INTO Table C between the SELECT and FROM lines. I did a manual check of the first 150 records found with the query and did not find a single discrepancy.

I posted under a separate thread earlier, however had to delete due to accidentally posting some real user data. My issue was that I was trying to compare two combinations of data, Table A.Job Code + Table A.Dept + Table A.Role = Table B.Job Code + Table B.Dept + Table B.Role. If Table A.Role...

I'm using it to compare against a list of variant roles, however it can't cycle through when the same user is listed twice. So I need to concatenate the roles down into a single cell tied to just one user record instead of multiple.

So I ran this after changing !role to !roles and it spat out the error: "Run-time error 3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. Is there a workaround for this?

I'm going to try this and see how it works. I'll let you know.

My Transsend_IP table populates a bunch of info from AD, and I need to update this table's existing records with the concatenated Roles. This way every userID will list all their roles and AD information in one record.

I am trying to use Allen Browne's ConcatRelated function but I am having some trouble. My code is sqlStr = "INSERT INTO Transsend_IP (Roles) SELECT ConcatRelated("Roles", "Transsend_UL", "Transsend_IP.APP_USERNAME = '" & Transsend_UL.APP_USERNAME & "'", , ";") FROM Transsend_UL;" For...

I will have to do some more investigating into CDO and see if it will work for my end goals. I'm certainly not opposed to something making things easier! UG - thanks for the link. I will research through her articles and see if any give additional guidance.

Okay, that makes sense from a logical viewpoint, but how would I go about referencing the error message itself in the code? Is there a particular command?

Thanks for the welcome theDBguy! If my understanding is correct, then the errors would occur while Outlook tries to send the emails. If that is correct and I would need to add the code in Outlook, how would I go about sending that data to an Access table? As I mentioned, I am fairly new to the...

I am building a database that will send emails to users and their managers. I need to have code built in that will log information if Outlook receives an error while trying to send. I am in between beginner and intermediate skill levels with Access and VBA, so I'm not entirely sure where to...