Search results

  1. B

    Using Forms to Update tables

    Will it force all three choices or only the one in the text box? I need all three to go to the table.
  2. B

    Using Forms to Update tables

    I have about the same problem as Naia. I need to create a form that will update three different table, but the user doesn't know what the number is pertaining to specific items. (the primary key) (These tables are being used to feed cascading combo boxes.) So he would like to be able to to...
  3. B

    Active X controls Date/Time Picker

    I downloaded the example and will work with it for awhile till I get it figured out, but check back. Knowing me I will have lots of questions. Thank you for all your help.
  4. B

    Active X controls Date/Time Picker

    Never mind I got it to work. I just had to delete out the old Date/Time picker on the form and ad a new one to the form. Thanks Very much appreciated.
  5. B

    Active X controls Date/Time Picker

    Ok I got the file registered and it said it was successful but when I go to run the application it just gives me the error MouseMove you entered as the evnet property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports. What did I...
  6. B

    Active X controls Date/Time Picker

    I think you are the one who recommended using the calendar guy program that was not an active x control and I downloaded the whole package but I still never figured out how to get it to conform to the way I needed it and unfortunately I have to present this thing tomorrow and it won't run from...
  7. B

    Active X controls Date/Time Picker

    I downloaded the active x control for the microsoft date and time picker. Where do I put the DL_MSSCOMCT2.cab file to get this control to work on my laptop?
  8. B

    Active X controls Date/Time Picker

    Ok obviously I am not getting it because when I try to run it (just the form not on the actual form that produces the reports) after I imported it all I get is The expression On Open you entered as he vent property setting produce the following error: User defiend type not defined. So what is...
  9. B

    Active X controls Date/Time Picker

    Will that work for a begin and end date? The date is the criteria to run the queries that run the reports.
  10. B

    Active X controls Date/Time Picker

    How would I go about doing that if this form is on a DB that is on a network and needs to be available on any computer it is accessed from? The form I created is suppose to be as easy as possible. All reports and charts are run from buttons. I need a way to have the user pick dates to run the...
  11. B

    Active X controls Date/Time Picker

    I have two boxes on my form that use Microsoft Date/Time picker. A begin date and an end date. How do I make sure that those controls work no matter what computer the program is run from?
  12. B

    Using a query to produce another query?

    Thanks. I got everything working and producing the data I was hoping for. (So far :) ).
  13. B

    Date Criteria

    Worked wonderfully. Gave me the results I was looking for. Thank you.:D
  14. B

    Date Criteria

    I have created a form that runs queries based on a begin date and an end date that the user enters into combo boxes (named begin and end). The name of the form is downtime graph. I want to use this code as the criteria in the queries so is reads the dates entered on the form, but it doesn't...
  15. B

    Using a query to produce another query?

    I need to create a query that will take the results of another query and produce data. The first query shows a bar chart of items showing downtime. The new query needs to take the item with the most downtime and produce a report that shows the reasons for that downtime. The downtime changes...
  16. B

    Charts in a Report

    I have a form that needs to produce reports showing only charts of data. What is the best way to input the charts into the reports so that when the user clicks on the button to produce the charts it updates everytime the report is run. Right now I am using queries to run the report charts and...
  17. B

    How do I use a pivot chart to display information

    I am creating a form that the user clicks on a button and needs to be able to pull up a bar chart showing the results of the query. How do I use a pivot chart? I have never used one and it needs to display things like the most to the least downtime minutes per department and I don't know how to...
  18. B

    Date Range Form

    The table that all the information is coming from has the line the, the machine center, the categories and the minutes that the line is down. The users want to be able to pick a set period of time (which constantly changes) like 3-1-07 to 3-15-07 and find out how long each area was down (line...
  19. B

    Date Range Form

    I need to create a form that a user picks between two date ranges that will run a query to total the number of minutes that each area on a particular line (line 1 or line 2) is down. That information needs to be put into a bar chart and then the user needs to be able to run another query about...
  20. B

    Cascading Combo Boxes

    Would you have an idea how to create a form that shows a bar graph and that would allow the user to click on one of those bars to dig even deeper to get more information pertaining to that particular subject? Does that make sense?
Back
Top Bottom