Recent content by marlan

Nearly 4 years later... I was shocked today to find out ByRef was the default for passing an integer in VBA. Just for the sake of the argument, as far as I remember C language, when passing an argument the value is copied, and the compiler determines weather the value is of an address...

Hi, and thanks for all your replies! We've solved these issues for now: #1 - this Before_Insert code was some legacy code, I just had to work around. #2 - I found ODBC link to SQL Server is read only when linked to a table with no Primary Key (I usually have one...:oops:). Add that to some...

Hi all you experts, I've bin developing acc for quite a while, against acc back end. Lately, I've bin hired by a company that develops access against SQL server. A few differences I've noticed: When linking a table with an autoincrement PK field, the autoinc value is yet not created by the...

Is there a way to get this Information using VBA?

Hi, and thanks for your replies! I wrote this access VBA code, that results wrong for me: Public Function SizeOnDisk(pstrPath As String) As Double Static fso As Object Set fso = CreateObject("Scripting.FileSystemObject") ' Set fso = New Scripting.FileSystemObject - will not compile...

Hi, We've received a user request to save on DB, and display on a form , some file's Size On disk, as displayed in Windows browser. the FileLen() function returns the file size, without the Winnows (or NTFS) overhead. assuming this info is used a lot in windows, is it saved any ware? can it be...

This seems to have been the issue, Thanks a lot!!

I'll try to, though it's not my data

Thanks for replying, The sort is manual (Right-click -> Sort A to Z), long after setting the record source.

Hi All You experts! A section in my system is there for linking products from the same category: There is a maidisplan Products table, and other Tables with lists of products in other countries named by convention CountryNmaeProducts. All these tables are linked by a CategoryID field. In the...

Hi guise, thanks a lot for your replies! It is an issue of version managing, and in this case we thought of this as a one time job, for getting our current version situation. We'll just have to do it in an other way.. Thanks again!

Hi All you experts! I am trying to, programmatically, receive a constant values defined in a VBA module, in other applications - all *.mde files.

Thank's all for your replies, It is the main network directory the organization works with, implemented as directory P:\ on all work stations. It usually works, so i don't think it's ftp protocol. I don't know if it SMB, but multi users don't cause any special issues, so I think the protocol...

Hi, I have a system running in a large organization, 1-3 users, FEs on each work station, BE on a LAN network drive. Using Acc2002 mdb files in Office 2010-13 environment. The user occasionally gets a few unexpected error messages. - Some are about the BE file format, indicating file...

Hi all you experts, I have some software by a client with 2-3 users, each copies the FE to his work station (regular PCs, I have VDI access to the network too), and access the same BE on the LAN (or Virtual LAN). all files are Acc2003 mdb files running in newer Office environments. part of the...