Search results

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

Shamed to say:o, this process in not by code, but Ctrl/F Find tool built in MS Office / Access, so the Option Compare statement is not relevant.

Thanks Dave for your reply would it error, or just not find? The data this text is copied from is imported from XML using Xpath and DAO.Recordset, or from Excel, using TransferSpreadsheet. I assume these non-visible control characters were not imported in these processes (even though the...

It works fine in another folder. I think that takes us back to the initial question: how could I detect if the 'invalid argument' Error is a computer, Network, network drive' or file error? The next question: If it is a file error, how would I fix it? (assuming all the data is in tact, as for...

As for now it is 1 user, it could go up to 5 users, each having his own FE. Only the FE. the BE is in a network drive, part on a large office. C&R was the first action I've done, for both FE and BE. Let me add some more on the files structure: 1. New version of FE is distributed by putting...

I was offline for the weekend, thanks for staying tuned The user says restarting the app didn't make a difference, so HE restarted the computer, witch has made a temporary difference. I'm wondering if it is a corruption issue, or a computer/network/network drive issue. Does it sound like...