Search results

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

Yup, that simple action.. These errors have occurred a few times in the past few weeks, in the last occurrence both CTRL/C and CTRL/F were of words in English, written in simple Latin letters. When occurs, the user restarts the computer

Hi all you experts, in a Acc2003 project running in a client's location in Acc2010, he searches for a value in part of a text field a main form. This value is usually copied (ctrl+c) from part of a field in one of 9 sub-forms. These sub-form have about 20K records each (not all loaded at once...

Colin, is the Nz function in VBA and Ace the same function? would compiling issues be a good solution for function errors in queries?

Bumpkin, What about the references? VBE - Visual Basic Editor. That would be my guess, try that before going to the decompile - compile option.

Hi, My friend and colleague offers his Acc2003 product in a Windows server using Remote Desk-Top, serving dozens of clients. After making sure you have enough CPU and web connectivity, it works just fine

I have managed to delete a few 'invisible' characters prier to the file name, and it works now... Thanks fot your support!