Recent content by CB_DFW

  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?
See more
Top Bottom