Search results

  1. A

    Multiple One-To-Many Relationship

    Hello there, I am trying building a filter using three list box and they filter down at each selection in the list box. Requirement: List box:- 1. Equipment type 2. Manufacturer 3. Model When the user selects equipment type the manufacturer list box should show only manufacturers of...
  2. A

    Date validation

    Hello, I want a vba code that checks the date and if the date is below 1-1-1990 then it should open a form. I know a bit of vba but I cant figure out how to enter the date in vba If me.dateofbirth < 1-1-1990 then DoCmd.OpenForm "helloworld" end if Also which event should I put the code in...
  3. A

    Help with making charts :o

    hello, I'm new to making charts. Basically I have a table with two columns called Order Received Date, Order Delivered Date. I want to make a Bar chart that shows the number orders received and delivered in a month. I want to do so without any additional columns. I want the columns in bars...
  4. A

    how to refer checkbox in a tabcontrol?

    Greetings, I made a tab control called TabCtl54 which has a pages named hello world and hello earth. I have a checkbox named 14 place on the page hello earth. I placed a textbox called txtbx on the form. Now I want a vba code that would change the backcolor of txtbx to yellow when the...
  5. A

    help with export excel in vba!

    Greetings I'm using the below code to export m table to excel and then open it. Dim curPath As String curPath = CurrentProject.Path & "\MaintenanceData- " & _ Format(Date, "mm-dd-yyyy") & ".xlsx" DoCmd.TransferSpreadsheet acExport, 10, "Installed Runway Equipment Data"...
  6. A

    Help with count and IIf in report

    hello My report has repeated numbers '30' '90' '180' in a column. I want to count the number of times 30 is repeated, so I made a unbound textbox and added below expression in control source. =Count(IIf([Maint Due Jan]="30",0)) this throws #Error in report...
  7. A

    opening a form from another form based on textbox value

    hello I have two tables "Employee" & "Jobsheet" which has a common column called "EmployeeID" which is unique in table Employee and has duplicates in table Jobsheet. I've also made two forms Employee and Jobsheet based on the two tables. When I click on the "EmployeeID" textbox in Jobsheet...
  8. A

    Query to filter based on minimum value

    Greetings, I have table named stock which has a minimum level for items and stock levels at each branch, so the table would have columns Item_name, Minimum_level, North_stock, South_stock, East_stock, West_stock. Now I want a report that shows items which have gone below the minimum level. As...
Top Bottom