Search results for query: *

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...

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...

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

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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