Search results

Nope your understanding is correct, I have no doubt the issue is on my end. I attached a zip of my db for you. I was hoping to figure it out on my own, but clearly I am getting stuck somewhere.

Thank you MajP. That gave me a good start. The "Workgroup Updates" subform on the right is just text boxes filled by a query, based on a dropdown selection. I was able to setup the hidden textbox, but how can I tell it OnCurrent to also re-run the query behind the "Workgroup Updates" subform?

So I'm not an expert and have been looking into the master/child fields, but I'm having some trouble. I understand how this would work with the text box containing a single value, but how would I force the textbox value to update based on the selected record? To be clearer, if I select start...

I apologize if this is a dumb question, but would that update all fields in the "Workgroup Updates" form, or just the Application Role Name? I only ask b/c my goal is to display all information of a workgroup record that is tied to the specified role name.

I have a form setup with two subforms, as shown below: I am trying to set it up to where the subform on the right, Workgroup Updates, changes to different information when cycling through the records on the left. Just by the look, they are tied together by "Application Role Name" (in this...

Thanks all! I decided it wasn't worth spending so much time on and just changed "Progress:" to "Run Query" to provide a bit less flashing.

Thanks everyone! The_Doc_Man's suggestion did the trick. I appreciate all the help (as always!!)

I am trying to export data from a recordset to an Excel template. This Excel file has macros that assist my users in managing the data they receive. I have no problem doing a straight TransferSpreadsheet to a new Excel file, but I have been unsuccessful in getting the data to the existing...

I have thought about that and could, but my query can take a little time to run, and I'd like to give my users something so that they know it didn't freeze or break.

I am attempting to override the default "Run Query" status bar that appears with my own to show overall progress. Set rs1 = CurrentDb.OpenRecordset(sqlStr) If rs1.RecordCount = 0 Then Resume Next Else...

sqlStr = "SELECT table1.[USERNAME], table1.Roles, table1.[APPROVE/DENY] " & _ "FROM table1;" Set rs1 = CurrentDb.OpenRecordset(sqlStr) rs1.MoveLast rs1.MoveFirst Do While Not...

Yes, they both share a field called "Username". I'll try Update instead.

I have a table that is populated with users and their associated roles to certain applications. I receive spreadsheets from their managers with either an Approve or Deny. The spreadsheet fields match the table exactly. My question is: how can import the responses to existing user field instead...

Thanks theDBguy, that did the trick! I knew I was on the right track, but couldn't work out the syntax.

Yup, that does help. I'll test it out and post an update. Thanks!

Where would I put that? Before I assign .SelectedItems to the variable fileName or after? And would I replace var with fileName in the code you provided?

I have the following code setup to import a file, eventually files, and move the selected file(s) to a new folder. Everything works great. I am trying to figure out how I can apply the "TransferSpreadsheet" and "FSO_File_Move" pieces to each file selected. I've thought about For-Next statements...

It did. And I'll have to apologize. Apparently, due to the number of spreadsheets that are created, it takes 3 minutes to cycle through them all. So I guess I don't have an issue except for being impatient (which was already a known problem). Thanks @theDBguy

Yes, the output Excel files do get formatted correctly all the way through the looped recordset, but it seems like Access hangs at the end. I have some code after that will create emails and that piece won't run. There are no error messages that pop-up either. Everything does work fine if I...

Yeah, your suggestion did work, but my boss vetoed it lol. But at least I know something new that I can apply later on