Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Datathumper

    Problem with subform

    I have a label on a form that I want to turn the visibility on/off based on a check box condition on a subform. It seems to work fine unless there are no records in a subform, then I get an error message. Is there a simple way around this. I am a pretty basic user, so I am sure that this is...
  2. Datathumper

    Reports CAN GROW function

    Can anyone help with this one. I have a report where the fields are set to "can grow". I want to have the "excel" look (ie. each field has a visible border) when it reports. I would like to have all fields grow equally to the size of the larges one. Is that possible? Otherwize it produces...
  3. Datathumper

    Database Corruption

    I know, I know always back up the database...I didnt. I had it on a USB disk and for whatever reason (more than likely improper removal of the device), the database has been corrupted and cannot be repaired by the compact and repair procedure. I have also tried the Jet4.0 compact utility from...
  4. Datathumper

    Display status meter while report compiles...

    I have a report that crunches several queries before opening, and I would like to launch a form while it is openning that would display the status bar that is found at the bottom left of the screen. I would then like to close it when the report is finally produced. Is this possible?? Thanks...
  5. Datathumper

    Running total by month

    Question for the pros. I am trying to create a graph based on a query where two fields are summed and then grouped by month. I need to have one of the summed fields by a running total by month instead. How would I go about this? THanks in advance.
  6. Datathumper

    Dynamic filtering of a form

    I am hoping that someone can help me with a little problem that I am having... I have a combo box on a form that looks up a value from tbl_main, field "Mark No" I want it to dynamically filter the attached subform, which draws from the same table, same field as a value is typed in the combo...
  7. Datathumper

    Problem with Strings

    Hello, Here is my problem. I have a list box that you select items from and populate another list box. The second list box populates a report. This is done using a "string" coding. The problem is when I exceed a certain number of records in the list box (usually about 120 records), the...
  8. Datathumper

    Filtering a combo box with another combo box...

    Here is the issue. I have a subform on a form with two combo boxes. The first box (drawing), should filter the second combo box (weld) when a value is selected. In order to refresh the second box value when the first is selected, I used afterupdate..me.weld.requery. This works until I get to...
  9. Datathumper

    Export a report with graphs to excel

    Does anyone know how to export a report that contains a couple of graphs to excel, keeping all of the formatting and data? I can export it to an RTF and maintain the data, but I can no longer edit it (basically a snapshot). I would certainly appreciate it if anyone has any good ideas...
  10. Datathumper

    There was an error executing the command

    Here is the problem..I have a database whereby one report asks for a number of days to report by when opening. The user is to enter a number and then the report is based on this number. ...Problem is I have distributed this database via runtime files (packaged for use on machines that dont...
  11. Datathumper

    Report on expiry dates within 1 month of present

    How can I run a query that will pick the values that are dated within 1 month of the current date? Thanks
  12. Datathumper

    Moving a selection from a combo box to a list box

    I have a little dilemna... I would like to have a combo box (named isometrics) and then click a button to move that value over to a list box (named current isometrics). I would then like to be able to select another from the combo box and add it to the list box as well. OR, be able to filter...
  13. Datathumper

    Form with a subform

    Here is an easy one for you experts...(not so easy for us amatures) I have a form, with a subform which is linked by fields named isonumber (same name in both tables). Everytime I add a new record, I get a 2 records added in the sub form table...one with the isonumber and one blank. How can I...
  14. Datathumper

    Multiselect box to populate a report

    Please someone.... I have two list boxes on a form called frm_multiselect. From the left box (isometrics), you can select fields and move them over to the right box (current isometric). I then want to open a report (rpt_foreman_main) and filter the records by the fields which are currently in...
  15. Datathumper

    Sorting by a number field in a report

    Help I want to sort by a number field [wldno] on a report, but it ends up like this 1 11 12 2 3 33 4 444 5 how can I order so that it will no just order by the first number and will order by all.

Part and Inventory Search

Back
Top