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

    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) & "...
  5. 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...
  6. C

    Export text file with VBA

    I have some code I would like to try and use to export data from my spreadsheet to a text file so I can import it into Access. Can someone help me put it in my spreadsheet and make it work? The vb and the spreadsheet are attached. Any help would be greatly appreciated. Thanks in advance.
  7. C

    Excel List/Database

    I have used some code I found on the web to create a form for data entry (attached). I just changed it enough to see how it worked so don't expect much. I was wondering if anyone knows how to add some navigation buttons to the form and a way to select already created records so you can edit...
  8. C

    Converting Sub to Function

    I really have no experience with modules and code but i have tried to use code that others create. I am trying to use this code to enter in the username into a table when the user runs a particular macro. I was told that I have to convert this sub (?) into a function. This was my original way...
Back
Top Bottom