Recent content by gsdude

These easiest way i know how to filter by multiple fields is using this method here I'm using a date range for one field but you can add as many Criteria as you want to it, and Im also using combo boxes to filter data. Dim Criteria1, Criteria2, Criteria3, SearchDateRange As String Dim...

Ok, The people taking the test/exams are employees, before we send them to a different location, they must have 1 or multiple test completed before arriving at new location. We only email our office , where they take the exams. Each of our locations require them to take either 1 or multiple...

Hello, Hopefully someone can help me with this. I'm using this database to submit a form and emailing it. It was simple how i was using, I had a table and depending where they where going the requirements where put in the form and emailed. Well now I run into a problem where they might already...

Thanks for the help, I was able to make it work, by simply making my original code into a function and then called it within the loop and seemed to work fine, for whatever reason it would not work just by simply put the code directly into the loop.

I tried your suggestion, but when i ran the code all it did was run the first supervisor in the recordset. Which came out fine. Is the problem my code that opens an excel file and fills in the data?

The dropdown is from a Query of Active Supervisors This is the code I run when I Press the button. Private Sub cmdSigninSheet_Click() Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Dim rst As dao.Recordset Dim lngCount As Long Dim Directory, OldPath, NewPath As String 'Start Excel...

Hey I'm trying to see if its possible to run some code for each record in a query. This is my scenario right now, I have multiple employees and each are assigned to a supervisor. For each Supervisor I export the list of employees to an excel sheet template. (signin sheet) Right now I have a drop...

Hey everyone, I Just started working with access, learned some basic stuff with youtube videos and such. Learned from this forums as well, and hoping to improve my skill with access/vba.