Recent content by marlan

  1. M

    Solved Parameter prompt When sorting a form, after changing forms RecordSource

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

    Solved Parameter prompt When sorting a form, after changing forms RecordSource

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

    Solved Parameter prompt When sorting a form, after changing forms RecordSource

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

    Solved Parameter prompt When sorting a form, after changing forms RecordSource

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

    How can I get a Constant value from in an mde file?

    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!
  6. M

    How can I get a Constant value from in an mde file?

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

    How does MS Access work with BE on a LAN that sits in the cloud?

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

    How does MS Access work with BE on a LAN that sits in the cloud?

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

    SameFE, Same BE, one a qurey user works fine, another gets "data type mismatch in criteria expression"

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

    'invalid argument' Error, when preforming a search (ctrl+f) in a form

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

    'invalid argument' Error, when preforming a search (ctrl+f) in a form

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

    'invalid argument' Error, when preforming a search (ctrl+f) in a form

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

    'invalid argument' Error, when preforming a search (ctrl+f) in a form

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

    'invalid argument' Error, when preforming a search (ctrl+f) in a form

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

    'invalid argument' Error, when preforming a search (ctrl+f) in a form

    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
Top Bottom