Search results

A man arrives home one night and proudly announces that he has bought some Olympic Condoms. "And tonight I am going to use the Gold!" he touted. "Why not wear the silver and come second for a change?" his wife replied.

Try using the Spinner button activeXcontrol

Will have a look when I get home tonight.

Did you search ??? Try the sample Db's here.. http://www.access-programmers.co.uk/forums/showthread.php?t=118820 Dave

You should have the SKU and brand details in one table and the models in a related table, then bring to 2 together with a query.

Can you post a sample of where you are at ?

The trouble with what yo are doing, and the way you are doing it, if no criteria is met in the first subform then no records are returned.

The next update..... In the Print order form we now have a listbox. The LHS column shows the sort order. If you add, then remove, then add, then remove items when selecting on the first form the sort order wont be sequential, but is an order. I left this column shown, but I suggest setting its...

Getting back the the Db, I added the buttons as I mentioned before. The example I had didn't really do what I thought. I also have an example of how to dynamically move items up and down a list, rather than having to go through and number each item. I will TRY (not sure how I will go) and...

Microsoft must have finally realised they were a ridiculous waste of your time. :rolleyes:

On the web subject - if you search for Data Access Pages (Accesses version of a web page) you wont find much info. I have tried several times, but the look very ordinary. As for the multi select, I put arrows inbetween the list boxes. I have an example here somewhere. Dave

Or you could just press F7

Where would you be without me.. :p When you have a form open, right click on the menu bar at the top and select customise. Select the Commands tab In the Categories listbox scroll down and select Records In the Commands listbox (RHS) scroll right to the bottom and find spelling. Drag and...

If I read correctly you want to search the OPIS field?

I would use a union query and a bit of code. Very difficult to explain, but once shown, it all comes clear. Can you post a cut down version of your Db and we will have a look. Dave

From the command button error handling simply put: On Error Resume Next. and delete the error handling at the end of the sub. In the reports On_No_Data event put: On Error GoTo Err_Report_NoData MsgBox "There is no data for this report. Canceling report...", vbInformation, " MsgBox...

If you search here for mouse scrolling you will find that most people are trying to stop the mouse scrolling, so I am suprised that yours doesn't work??

I'm hear'in ya buddy :)

What compile error? Check for missing reference - differences between the stand alone db and your Db. Also check for copied functions (IsLoaded etc) If you have then in twice the Db will spit it. Dave

Of a form, or report? DoCmd.OpenForm "frmName", acPreview, , "Criteria Here" DoCmd.OpenReport "rptName", acViewPreview, , "Criteria Here" Dave