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!

Register Log in
  • Congratulations derfloh 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. huskerdon

    Can you start a custom app when a camera is connected?

    tedsmith, Thanks for your response. Apparently what I was asking can't be done. I'm using MS Windows Image Acquisition (WIA) library and VB code to get the pictures from the camera. If the camera shows up in My Computer as a portable device, you can right-click and go to properties. Then on...
  2. huskerdon

    Can you start a custom app when a camera is connected?

    Hi - I've written a custom VB app using WIA, to automatically download photos from a Kodak C875 camera and create thumbnails. The app automatically copies the photos to 2 network locations, so I don't want to use the XP wizard. Everything works great, and to prevent the Camera and Scanner...
  3. huskerdon

    " ... .mdb is not a valid Win32 application" message?

    PHV, No, this was in a remote office, and I was only there for a short time. This was not the reason for being there, so didn't find out about until I was leaving. I'll try a repair tomorrow. Thanks
  4. huskerdon

    " ... .mdb is not a valid Win32 application" message?

    Hi, I know this is not really an Access issue, because I've done a search and found that it happens a lot. However, this has me baffled: A user has a desktop shortcut to an Access database, and when you double click it, you get the message "xxxxx.mdb is not a valid Win32 application." You...
  5. huskerdon

    Show group totals in Report Header?

    CosmoKramer, Thanks for the suggestion. That worked great! Sometimes the solution is easier than we think. I modified the "qryDueDateCount" query mentioned above to this: SELECT DISTINCT tblRetailer_Info.Due_Date, Count(tblRetailer_Info.Due_Date) AS CountOfDue_Date FROM tblRetailer_Info...
  6. huskerdon

    Show group totals in Report Header?

    misscrf, Thanks for replying. What you suggested won't work, because it will just show the Due_Date value for the first record, and I don't want to sum the date field. For example, say I have a table with 29 records. 10 have a Due_Date of 9-25-04, 7 have a Due_Date of 10-1-04, and 12 have a...
  7. huskerdon

    Show group totals in Report Header?

    Hi, I did a search, but didn't find anything similar to this - so here goes: What I would like to do if possible, is show totals from a group footer in the Report Header. I've set up just ONE group using the sorting and grouping section. It is grouped on the Due_Date field. I used a text...
  8. huskerdon

    Delete query question - using Alias to find duplicates ?

    PHV, That did the trick! Have a star. I've been using Access for 8 years and have never used "Exists". Guess I need to read about that. Thanks for your help, Don
  9. huskerdon

    Delete query question - using Alias to find duplicates ?

    PHV, Thanks again for your response. When I open the new query (based on the first query) in datasheet view - it DOES return the 2 correct records. However, when I try to actually run the delete query, I still get the message "Could not delete from the specified tables." What causes this...
  10. huskerdon

    Delete query question - using Alias to find duplicates ?

    PHV, I think that's close to what I need. I tried your code, replacing "yourTable" with the actual table name "tblHist" and adding "tblHist.*" between "Delete" and "From". When I try to run it, it's asking for paramter values. Do I need to specify the table name (tblHist, A, or B ??) before...
  11. huskerdon

    Delete query question - using Alias to find duplicates ?

    Hello, There may be a very easy solution to this, but I've been stumped on this one. I have a table with thousands of records, and somehow, there got to be (kind of) duplicate records. Below is just a sample table using similar fields. The HistID field is the PK, and ItemID is the number of...
  12. huskerdon

    Removing Close Button from Main Access Window?

    RoyVidar, Thanks for the thread. I had already tried experimenting with the SetWindowLong api using GWL_STYLE, etc. It removes the "X" but also removes the Min and Max buttons. I need the Min button to stay on the main window's title bar. Is there no way in code to trap the click in the...
  13. huskerdon

    Removing Close Button from Main Access Window?

    Hi Access experts, Just a quick question - I've been looking all over trying to find an answer, but haven't so far. Is there any way to modify the Control Box for the Main Access Application window ("Omain") ? I'm using the FindWindow and SetWindowPos api's to limit the Main window to 1024 x...
  14. huskerdon

    Scroll down a subform automatically

    Sorry, that should be Me.subformname.Form.controlname.SetFocus where "subformname" is the name of the subform container on the main form, and "controlname" is the name of the control on the subform that you want to show.
  15. huskerdon

    Scroll down a subform automatically

    What kind of control on the subform are you trying to show? The 2 suggestions you've been given work just fine on tests I've done. If the control is a command button, text box, combo box, check box, etc., then simply setting focus to it should automatically scroll down so that control is...
  16. huskerdon

    Quarter-to-Date hours

    shwin, Check out the DatePart function. You can do a query to limit the recordset to records where the quarter of the selected record = the current quarter. Use the interval "q" to return the quarter (1 - 4) ... where DatePart("q",[fieldname])=DatePart("q",Now()) Hope this will give you...
  17. huskerdon

    Scroll down a subform automatically

    hgrafen, I know most programmers will bad-mouth the use of SendKeys, but in this case it should do the trick. In code, you just need 2 lines to set focus to the subform, then use the Page Down Key with SendKeys - subformname.SetFocus SendKeys "{PGDN n}" ' where n is the # of times to...
  18. huskerdon

    List Box Alignment

    dcurtis, Thanks for the suggestion of using 2 text boxes. That would work, except in the cases where the text boxes would require scroll bars. In that case each of the two boxes would scroll independently, and would not be in sync. BTW, this is the code I used to populate the text boxes. I...
  19. huskerdon

    List Box Alignment

    Hi, Is there an EASY way to change the alignment of data in a list box. I have a few simple, bound 2-column list boxes on a form, and would just like the columns to be right-justified instead of left-justified. They're just used to display data, and not used for selecting anything. It...
  20. huskerdon

    incremental numbering

    directorz, For a completely different approach to the numbering issue on a continuous form, see thread702-843719, and then look at the response from ZmrAbdulla on 5-19-04. This worked great for me! huskerdon

Part and Inventory Search

Back
Top