Recent content by ethan.geerdes

Thanks. I'll let the person rename the file. lol

Thank you. I found it. My brain read that with spaces so it missed it in the first look. one more question, is there a way to have a variable in the form be in the file name of the document? I'm thinking like a date range.

Ok, I just went through and saved it. how do I do the macro so run the saved template?

no I didn't.

I almost have my project complete but I need to export a table. I was able to do it the way it needed to be through the export wizard so I think there is a way to specify this in code so that I can tie this to a button but need some help. In the wizard, I select the export to text feature...

I do need the user to provide the input. VBA_PHP, that is exactly what I need. How did you join the two of those together, it looked like it was through the button at the on click. I see the query is built with the "[forms]![example]![example]" that's indicating that it is the example field on...

Second question of the day, I have been able to find half of my answer. What's killing me is I used to know how to do this. :banghead: Anyways, great minds of the access programming "gods"; I want to create a simple form that allows for someone to input a number and update it to all the records...

I think that may have cured it.

Below is the sql that isn't working SELECT [Sound-exchange-report].date, [Sound-exchange-report].artist, [Sound-exchange-report].title, Count([Sound-exchange-report].[title]) AS Spins, Sum([Sound-exchange-report].[listeners]) AS TotalListeners FROM [Sound-exchange-report] GROUP BY...

I am trying to build a query that will count how many times a song plays and sums the listeners for that song during the month. I currently have this as a live csv worksheet that is linked to the access form. The fields are date, artist, title, listeners. I got the query to work correctly if I...

I figured it out. I didn't have the column specified in the combo box in the query. Private Sub Command8_Click() Dim strSQL As String strSQL = "Update tblTSLog" & _ " Set Status = 'in progress' , " & _ " Where ID = " & Me.Combo10.Column(0) & " ;" Debug.Print strSQL CurrentDb.Execute strSQL...

I am starting to suspect that the query works and it is something with my form properties. I took the where line out and it updates status of everything to in progress. I then re-inserted the line and it's not erroring out however, it also won't update the record that is selected in the combo box.

Well, I did what I thought he said, and played with the syntax a little bit doesn't fail now but it also doesn't do what I'm trying to make it do. This is what I currently have. Where do I go to find out more about the syntax about SQL in access? Thanks guys for your help by the way. Private...

I took the comma out and now I get a "data type mismatch" error.

Thank you. I appreciate it.