Search results

  1. P

    Access 2003 - There was a problem etc

    Not solved so far unfortunately. If there was a clear explanation of how to solve this for Access 2003 under Win 7 64 bit using the registry then I make be prepared to give it a go but nothing I've seen so far looks very convincing.
  2. P

    Access 2003 - There was a problem etc

    Coorrection - I don't think it's the CSV creation after all. 2 reasons 1. I tried a home made function to create the csv but that didn't help 2. I tried commenting out the whole csv bit - and that didn't help either !! "hangs head in shame"
  3. P

    Access 2003 - There was a problem etc

    Thanks for the link. I had seen that but mostly about Word. I hadn't noticed it was 5 pages though so I'll give it a more thorough reading. Decompile/recompile etc made no difference
  4. P

    Access 2003 - There was a problem etc

    Here's the line:- DoCmd.TransferText acExportDelim, "", "tblTemp_Requests", "m:\lcs\kram\lcs-req.csv", False
  5. P

    Access 2003 - There was a problem etc

    No API's and it's 32 bit. But thanks for trying :-)
  6. P

    Access 2003 - There was a problem etc

    I frequently get the error message "There was a problem sending the command to the program" but despite searching repeatedly I cannot understand it or solve it, yet it appears to be common. So I'm putting it on here to see if anyone here can help. I have an application written in Access 2003...
  7. P

    Update Continuous Subform

    Self solved. Every time I displayed the form I started by creating a temporary table and then ran the form. I simply emptied the underlying table instead of trying to delete it. Then refilled with fresh data, then requeried. Works a treat.
  8. P

    Update Continuous Subform

    I hope there is an easy answer - I have a form which contains a continuous subform. The subform gets its data from a table which is bound. I want to have a button on the form to update the data and then re-display it. But I get the error that the form cannot be updated because the table is...
  9. P

    Calculate no of working days excluding bank holidays

    Just found this thread and Mile-O's function, which is brilliant but has a tiny error. In the CorrectDate function, the vbBoxingDay case, the last line should end with a 26 not a 25 - I think!! ie Case vbBoxingDay If Weekday(DateSerial(Year(dteTemp), 12, 26)) = 7 Or _...
  10. P

    Data validation usint On Exit event

    As the title says, in a simple Username and Password screen I'm trying to use the OnExit event to run code to validate the password both for nothing entered or incorrect entry. It all works fine and I use Cancel=true to keep focus on the 'Password' field. EXCEPT if the user presses the 'Cancel'...
  11. P

    Bypass Shift Key

    Don't worry - sorted by trial and error
  12. P

    Bypass Shift Key

    In Access 2010 I'm setting and unsetting the bypass shift key property - set to true for users and set to false for me, the developer. No problem but what I can't figure out is how do I work out whether it is set or not? Can anyone help please?
  13. P

    Database deployment - is there a way..

    I run a multi-user application on a local network with an Access 2003 front end on every machine and an A2003 backend on a fileserver, and all is well. We also have remote users who want to access and work on the the same system - as though they were in the office. This may not be the only way...
  14. P

    Show a "loading" message while database is opening

    It sounds like an issue with something which is running at start up. so can I suggest you try temporarily disabling the logging function that you are running and seeing if that makes a difference. Dave
  15. P

    Hello from Suffolk

    Hi. I've been creating database programs using Access for about 15 years and have made a living at it - can't complain. I'm now closing in on retirement but before I go I have one big task. My biggest, and only, client is still on XP and Office 2003, with the backend data as an .mdb on a file...
Back
Top Bottom