Search results

  1. C

    Help with Basic Starting Point

    I have been tasked with creating a report to basically match what I am showing in the Excel Spreadsheet image below. This is a spreadsheet built by someone on another team and I have to create a process to update the information using Access. The spreadsheet below is using all vlookups to...
  2. C

    Prevent Buttons From being Copied

    I have a spreadsheet that has several buttons on it. Users are going to try and copy all the data from this spreadsheet and paste it to a new sheet in another spreadsheet and it's going to copy the buttons. These buttons will not work if they are copied to a different tab. Is there a way to...
  3. C

    Change VBA to work on Active Sheet

    I am using this code to format some borders on my worksheet. The worksheet name is "District". How can I change the code to work on the active sheet? One reason that I need to do this is because users are copying the worksheet to other files and it copies the format button with it so I need it...
  4. C

    Rearrange Name

    Worked perfect. Thanks a bunch.
  5. C

    Rearrange Name

    I have this code that backs up a table and names it: HH:MM:SS PM MM/DD/YYYY STRs I would like to change it so that it saves as: STRs MM/DD/YY HH:MM:SS PM Now would be "STRs 12/18/08 12:29:51 PM" DoCmd.RunSQL "SELECT STRs.* INTO [" & Format(Time, nnhh) & " " & Format(Date, mmdd) & "...
  6. C

    VB works on 2007 not on 2003

    It works, it works. Awesome. Thanks so much.
  7. C

    VB works on 2007 not on 2003

    I have attached my DB. Maybe that will help.
  8. C

    VB works on 2007 not on 2003

    Good instructions, thanks. I followed them but it did not say I had any missing references. What now? :)
  9. C

    VB works on 2007 not on 2003

    Not sure what you mean by references. I have had my boss try it and it fails for him too. He is on 2003. My coworker tried it and it worked fine. I can't figure it out.
  10. C

    VB works on 2007 not on 2003

    Anyone know why this would work fine in Access 2007 but not with Access 2003? I get a Compile Error: Constant Expression required I get it on this line Set qdf = dbs.CreateQueryDef(strQName, strSQL) It highlights "strQName" Any help would be greatly appreciated. Option Compare...
  11. C

    Export text file with VBA

    That code worked great. I did some more research and found this code and got it to work also. It provides a few more options such as: 1. allows for multiple recipients and you can add them to the cc: and bcc: 2. does not require the user to allow the email 3. it allows you to email files from...
  12. C

    Export text file with VBA

    I tried using this. It seemed to be as basic as it gets. But I get an error message that says. The "sendusing" configuration value is invalid. Public Sub email() Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "Example CDO Message" objMessage.From = cbdfw@yahoo.com...
  13. C

    Export text file with VBA

    I don't mind at all. I have done a lot of searching and I try what I find but most of the time I can't get it to work on my own. Not that I have completely failed. It's normally something small that I miss because I am a newby. That's why I started this thread with a sample of the code...
  14. C

    Export text file with VBA

    This is working good. I would like for the file to save to the desktop of the current user. I have used this "C:\documents and settings\%username%\Desktop" before but it does not work. Public Sub save() Dim path As String Application.DisplayAlerts = False path = ThisWorkbook.path & "\"...
  15. C

    Export text file with VBA

    Is it possible to have this file automatically email via Outlook 2007?
  16. C

    Export text file with VBA

    That works!! I have have an extra row at the top. Can we have it save the worksheet without the top row? Row 2 has the column headings.
  17. C

    Export text file with VBA

    I'm getting a syntex error on this line. path = thisworkbook.path & "\" thisworkbook.name
  18. C

    Export text file with VBA

    I can do that but then they are in the file with it named CSV. They won't know how to get back to their original file. I'm not trying to be difficult. This has to be seemless (the best I can). I have one button that combines all the tabs, deletes the blank rows and now I want it to spit out...
  19. C

    Export text file with VBA

    With the text files, I can combine them using this dos command. copy c:\txt\*.txt c:\txt\combined.txt That way I don't have to import each file individually.
  20. C

    Export text file with VBA

    I understand that I can have them save the file as txt. I would like to create a button that will save the file for them. Trust me, some of these folks will mess up even trying to save the file as text. I thought that I would have it export the file for them and then maybe have the file email...
Top Bottom