Search results

I then assume you are using VBA and DAO? Simon

Also try Indexing the fields on the Footer I have a record with 50,000 entries in the subform, don't ask why, not my idea anyway by indexing the main fields I have the great performance these are numeric value fields. Simon

Doc Man I'm no spring chicken either I have just had to understand some very unusual KPI's so SQL Server was comparatively easy, you may surprise yourself regarding (3) Simon

If you are trying to do quarterly or half and yearly reporting you could create a table to with YearNo and MonthNo and extract which period or alternatively have a StartMonth and EndMonth. Simon

Find the program in Access and do your filtering in Access and export the results into Excel. Sounds like the existing program does a dumb dump. Give it some intelligence - you know how to filter in Excel so you are quite capable to doing the filtering in Access. Simon

Do both and use any filter on the Report. Screen based forms allow users to review the information before printing. Simon

Doc Man, I have a file that increments by 25,000 per month. I have been implementing Sql Server with an Access Front End. The upsizing was pretty good obviously there were issues but no show stoppers. I'm very tempted to put all the files into SQL Server and be done with it. Simon

If you where using a Search Form with the Serial Number then From with the data could be opened with just one Where Condition. Function Search_UnitSerial() With CodeContextObject DoCmd.OpenForm "Data Form", acNormal, "", "UnitSerial = '" & .[SearchValue] & "'", acFormEdit...

Here are some examples: The King of Hearts jpg: 126Kb png: 273Kb bmp: 1,030Kb All the same Size all produced in Photoshop. I can't load the png or bmp because of upload file restrictions. Fair enough. Simon

NEVER EVER use bitmaps. 60% Jpegs are preferred although pngs can be used. Bitmaps are just rubbish as there footprint is astronomical. Simon

Don't attach just use the Image Control. Simon

What the two days being used? Simon

SQL Server is great for 100 of thousands of records. I have stored about 30,000 images using 500 x 500 pixel files without any problems. The master images are over 50MB. I did introduce a Image Management System to avoid problems of 1MB or 2MB files being used and Access found these...

I don't know if this helps. It is required for web sites using Accdb files. Microsoft Access Database Engine 2010 Redistributable https://www.microsoft.com/en-us/download/details.aspx?id=13255 Simon

It matters if you are using web applications and accdb files. Simon

Forgive me if there are some typos as this is a cutdown version of 30,000 image database. Try something along the lines of : Function GetImage () Dim ImagePath as string With CodeContextObject ImagePath = .ImagePath If Dir(ImagePath) <> Empty Then...

Also try taking out an error trapping as VBA sometimes gets in a tangle and you need to force the error to occur to find it. Simon

You could trying linking Excel into Access. Simon

I never use a wizard. If you are doing a tabular form the mess that is made with more than 25 controls and a limited form width - it is not worth the hassle and besides the default width is applied to each control. This is what I do to begin and this takes time - make your first form like a...

I heard thsat ADO has being deprecated along with SQL OLE Reader. Indexing is equally important on SQL Server side. Simon