• Weyrman



    Viewing 15 replies - 16 through 30 (of 184 total)
    • in reply to: Excessive time when editing forms #1467815

      Do you mean that you are going into design mode of the form and then clicking on the subform that is embedded in the main form? If so that is a real puzzle….

      Yes, this is exactly what I mean. Sorry I didn’t get back earlier.

    • in reply to: Excessive time when editing forms #1466716


      Each user has their own copy of the FE. The form shows only 1 record at a time and only a max of 10 records in the subform. Only 13000 records in main table.

      Tell me more about indexing, it seems to be one of my knowledge holes.

      Also, when I say form editing, I mean form creation/edit mode, not live record data editing.

    • in reply to: Access 2007 switchboard issue #1462317

      Thanks Pat,

      As you know that did it :clapping:

    • in reply to: Access 2007 switchboard issue #1462260

      Where about did you put it?

    • in reply to: Access 2007 switchboard issue #1462256

      here is a trimmed down copy of the front and back end. You will have to relink the back end tables. you will see that the sub menu options don’t work even though all the code is there.

    • in reply to: Need help with code #1454927

      I found an excellent code module here that creates a bat file that closes then reopens the database that ran it. By simply adding lines to it that copied the DB from the “server” where the latest version is kept before reopening it allowed me to achieve what I wanted, And how!!!

    • in reply to: Need help with code #1454504

      That’s actually what I have right now but I thought it would be nice if I could get it to be fully automated. 🙂

    • in reply to: How to run Google’s Android OS on a Windows PC #1446933

      Installed the latest version of Virtualbox 4.3.10 and Android 4.4 loaded fine!

    • in reply to: How to run Google’s Android OS on a Windows PC #1444224

      I always enjoy the column, but I have a 6 month old AMD computer with Windows 8 on it, and my installation fails after I choose to Install Android x-86 to Hard Drive. It just reboots over and over to the same screen. I can’t get to the partition selection screen! I’m about to give up on the VM.

      I have the same problem. I am running win7 64bit with virtualbox 4.3.8 and iso 4.4-rc1. 4.3 as stated in the article I can’t get to download.

      The last command on the screen is Kernal panic – not syncing: Attempted to kill init! exitcode=0x0000000b

    • Wendell,

      Yes, sorry about using the wrong terminology, I have subforms shown as datasheets that only link the .sourceobject specified when the tab is selected. What I need is the best point to unlink the .sourceobject so that it is unlinked before moving to the next record but doesn’t unlink when I click in the subform. I will look at Ian’s suggestions.

      I am running an Access backend.

      Thanks Ian for the addresses, the recordexit event seems to be what I want. I will look into it at work on monday.

      Indexes.???……..Ummm………looks like they will be my next big step towards the deep end. 🙂 My source query pulls from at least 2 tables so any help, explanations, suggestions will be most welcome.

      Regards, Allan

    • in reply to: Properly reading the recordset #1438292

      I worked it out!

      Set rst = sbfItems.Form.RecordsetClone needed to be Set rst = me.sbfItems.Form.RecordsetClone

      and I also needed to define my variables

    • in reply to: Closing an unattended form #1400681

      Yes they do, but we still get occasional locks when people are trying to access the same record

    • in reply to: Outlook 2007 multiple accounts for viewing purposes #1309080

      its more only for incoming mail, he wants to be able to keep up with what requests for quotes are recieved by the sales people

    • in reply to: Subform filtered by 3 combo boxes ? #1280768

      Thanks for that, but I notice that the order that the combo boxes are used has to be concreted in place. I could do it that way but I was hoping for a more dynamic sort of filtering where it wouldn’t matter as to which order the combos were selected in.

    • in reply to: Override a form’s opening condition #1280118

      Thanks Alison, that does just what I want. My programming skills aren’t that great to start with and I don’t do it day to day. Its a case of “I’m pretty sure it can be done but just don’t know the specifics” but I usually understand code once I see it.

    Viewing 15 replies - 16 through 30 (of 184 total)