Search results

  1. E

    Export macro woes

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

    Export macro woes

    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.
  3. E

    Export macro woes

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

    Export macro woes

    no I didn't.
  5. E

    Export macro woes

    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...
  6. E

    Update query that allows for user input

    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...
  7. E

    Update query that allows for user input

    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...
  8. E

    Dates are throwing off my query

    I think that may have cured it.
  9. E

    Dates are throwing off my query

    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...
  10. E

    Dates are throwing off my query

    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...
  11. E

    Update Query error

    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...
  12. E

    Update Query error

    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.
  13. E

    Update Query error

    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...
  14. E

    Update Query error

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

    Update Query error

    Thank you. I appreciate it.
  16. E

    Update Query error

    So I'm working on making an update query for a trouble ticket log (more or less) and I'm trying to set the status based on the ID number of the ticket. My table is set up like this Table name = tlbTSLog first column = ID (pk) second column= Submitted (date/time format) third column= Date...
  17. E

    Location Query

    thank you very much. I appreciate you pointing me in the right direction.
  18. E

    Location Query

    I am writing it as a function because I don't play with sql much and I have no idea what I'm doing. I'm looking for guidance on how to define the query.
  19. E

    Location Query

    Ok, So I am doing some research and I think it may look like this. Public Function qryCreateKML() dim strSQL as String strSQL = "Select 'Latitude','Longitude' FROM fcc_info_tbl" _ Would that be correct in naming my query "qryCreateKML"?
  20. E

    Location Query

    would my query look like this? I think i may have over thought the complexity of this. Select Latitude, Longitude From fcc_info_tbl
Top Bottom