Search results

  1. V

    Combining Reports into 1

    Good afternoon, I currently have a button that prints 1-n reports in PDF format. I know how to combine those PDFs into 1 using VBA if I have the exact number of reports being printed. Some weeks I will print 1 and some weeks I can print up to 6. My question is: Can I make an array count...
  2. V

    Freeze moving rows

    So I have an Excel spreadsheet that has 4 title rows that I want to freeze when they are at the top of the screen when scrolling. For easy lets say my title rows are 1, 100, 200, and 300. When I scroll down the spreadsheet I want row 1 frozen until I hit row 100 which I want to take over as...
  3. V

    Print Value from a subform

    I have a subform that has 1 item in it, the Validation date of my item. On the form the subform is linked through item and displays the date properly. I have a button that I am using to send out an email but want to include the date value in the email. I cannot use Me.value because it is in...
  4. V

    Solved Pass a worksheet through a function

    I have : Set xlApp = CreateObject("Excel.Application") Set xlWB = xlApp.Workbooks.Add Set xlSh = xlWB.ActiveSheet I want to pass that through a function that fills in the rest of the information into the spreadsheet depending on if its a leap year or not. currently : If...
  5. V

    Solved Combobox Selection for a form

    I have a form that is linked to a table that has over 1000 entries. I want a combo box on the form to select which entry the form shows. I do not want to use a list box because I don't have much space and would rather a combo box. Text box is out of the question because people can't spell.
  6. V

    Solved Data from another form pop up

    Ok this is a weird one stay with me. I have a data entry form that captures all the data for everybody. This is saved to a table called Roster. Each section has their own macro button to open a form with their specific peoples data. There are 2 variables that designate when a person leaves...
  7. V

    Function in a loop

    So I have 2 functions that return a specific cell location in Excel. One for a start date and the other for the end date. Once I have these 2 dates I will create a range with them to fill it with a color. My current loop looks like this: Do While rsLeave.EOF = False Set rRange =...
  8. V

    Display List items in TextBox

    I am trying to display multiselected list items into a text box. Dim result as String Dim varItem as Variant With Me.lstType If .ItemSelected.Count <> 0 Then For Each varItem In .ItemSelected result = result & .ItemsSelected(varItem) & vbNewLine Next End If...
  9. V

    List Box

    I have a multiselect list box in my form and I have a button that prints what is selected to PDF. I want a message box to pop up that states to ensure the selected number is not already open in pdf view. MsgBox "Please ensure that CNF " & me.lstBox.Value & " is not already open." doesn't...
  10. V

    Is there a better way?

    I have a button that creates an Excel document. I want it make it flow better and to adjust for leap year. It has to flow October through September and have the FY as the name of the tab your on. My current code is just 1 sheet and very long, there has to be a way to make it more streamline...
  11. V

    Highlighted Search

    I have the following code in my database that searches through all my records for certain keywords and prints out a report that has each record that has the keyword in it. I want to highlight the keyword in the report to make it easier to find in each record. Is this possible? Dim dbCurr As...
  12. V

    Update Query doesn't Update?

    I thought that creating an update SQL that it would add to the existing data in the table but it instead overrides the data with the new data. Private Sub cmdComment_Click() Dim strComment As String strComment = "UPDATE Leave " _ & "SET [Comments] = '" &...
  13. V

    Data Entry not working as Intended

    I have Form Soldier Data, with subform Leave. Subform Leave is set to data entry and has parent child with ID so they link. When i open Soldier Data the subform still has the record last submitted instead of being blank. Is there a way to set default blank or maybe have on open it sets the...
  14. V

    Should work but doesn't

    This was working last week and now it is not and I am stumped as to why. Nothing involving these fields have been changed except I removed clearing the boxes after the SQL runs. Private Sub cmdComment_Click() Dim dbCurr As DAO.Database Dim strComment As String Set dbCurr =...
  15. V

    Query with option of 2 fields

    Is it possible to query off of 2 different values? I have a table that has 2 date fields, 1 for when they leave the army and 1 for when they leave the duty station. Is it possible to pull a query that gives me everyone that is 180 days from either of those 2 dates?
  16. V

    Numbering

    I want to put the numbers 1 - 7 accross a single row in an excel spreadsheet using VBA. I also want to put Monday - Sunday repeating through a single row till the end of my columns. i have column D to ND formatted If I start the coding With xlSh.Range("D2", "ND2") I am at a loss as to...
  17. V

    Create Excel from Access

    I am completely out of my depth but have been tasked to create a specific excel spreadsheet based on a query in my database. I need to Excel spreadsheet to have the 1st 2 columns filled with the names of everyone in my org. Then i need the top row of the spreadsheet to have the months in order...
  18. V

    Only 1 record from subreport

    I have a report created that pulls an individuals admin information and a sub report on there that should pull the most recent test results. For some reason it is pulling ALL the test results for the individual. I tried to turn can grow to no but that's not right. Is there a way to show just...
  19. V

    INSERT SQL

    This is my first attempt at an INSERT SQL statement: DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO [Leave] ([Control Number])" _ & "values ('" & Me.txtControl.Value & "')" _ & "WHERE (((Leave.[Start Date] = me.txtStart.value) AND ((Leave.[End Date])=...
  20. V

    Clearing Data Entry

    I have a subform with a few text boxes I have set the form to data entry, but i wan the form to clear the data to input new data after saving. Do I have to make a VBA code with a button to save or is there a properties box I can change to clear the text contents to input new data?
Top Bottom