Search results

To me, 2007 was used as soon as it was available as 2007 supported jpg images, 2007 basically handles images in their native format. Waited a long time for this feature, although a applet sufficed from 1997. Simon

Oddly, A Terminal Server does precisely that with a long Session Timeout. Each user has a Front End and can use this account remotely as well. If that swap PCs the Session will be resumed and previous instance dropped. Simon

I understand that the emphasis of 2016 was the web features. I don't think much was changed on the desktop. Here's what's new: https://support.office.com/en-gb/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496 Simon

With SQL Server procedures, similar to a Function, are used to hide the data, as the biggest fear is a SQL Injection. The SQL DBA sole responsibility seems to be performance tuning. Data is valuable but it needs to be reported and even more importantly being able to test data integrity...

Persistency is pretty standard for FE/BE deployments. Filtering is even quicker. Simon

Hi Phrygian, Yes most of the solutions will involve VBA. It is quite a single process. In short Associate an Image to a singer using a Unique Singer Reference (ID). Then create a mechanism to dump (render) the image into the screen. On Current all you are trying to do is to get the Image...

Hi Traci, The trick to to filter before Form. I have over a file with 350,000 records, maximum records per LOT is about 200. By filter on SLAP, LOT and Date there are no major performance issues. Simon

The file format accdb is 2007-2010 or 2007-2016. There are probably some more features but recent developments are on the web application side of Access. I when from 2007 to 2016 without any major problems. Simon

I used to used dbpix for Access 97 but NEVER stored a single image within the database. With about a GB of images I could access these images with no footprint. I didn't realise there still products advocating storing images in databases. Simon

Above 2007 will handle jpeg images so I have used the picture element and referential logical to the images. I did have to rewrite the Image Management Scripts. Simon

The idea of filtering is that you can you fuzzy logic rather than explicit values. The two examples gice "Ti-64" and "Ti-6246" have different properties and the data shown reflect those properties and then you test the record and control the events your want to run. Simon

What version of version of Access are you running. I have had to use an ActiveX component on pre Access 2007. The (25,000) images used COULD NOT be stored and were held on a server and NOT locally. Simon

I simply use DIR as I know where to find the files and filename is associated with an ID. I then have a flag, in my case for an image, and set it to True if found or False if not. Simon

Of course. All you are doing is separating the JET (mdb) or Ace (accdb) database engine from the Access application aspect of the application. The only downside is version control mentioned above but that is far outweighted the benefits of splitting FE/BE. Essentially all you are doing is...

Financial Periods or Weeks differ from pure Calendar based calculations. I create a Week Master with Start and End date and lookup via VBA using the transaction date for the Week Number, in some cases, Period No and then Financial Year. First day of the year is in late March or early April. Simon

You could try: SqlServer: create a view to emulate the Access Query. Link the view rather that the individual tables. Index InvoiceSalesSlip with SQL server. Simon

Try Like [Forms].[frmChooseProducts![cmbSupplier] & "*" Alternatively you can use VB and first test if the Supplier combi is populated and only have a Lookup with Supplier when available. This is a little bit complicated. On the Product Combi you will need to requery cmbProduct On Entry. Simon

Is this a space delimited export. The came things happens with commas for comma delimited exports. I cheat and create a query adding a "|" pipe to the end of each field and specify the delimiter upon import. A bit time consuming to set-up but beats having to mess-out with the output. Simon

Try using a Function, all you are doing is adding a filter to the call: Function XYZ() dim loginname as String With CodeContextObject loginname = .loginname DoCmd.OpenReport "XYZ", acViewPreview, , "[loginname] = '" & loginname & "'", acWindowNormal End With End...

Try using Len(NRESULT) > 0 This a bit of a catch-all but quite useful as times Simon