• Weyrman



    Viewing 15 replies - 31 through 45 (of 184 total)
    • in reply to: Access 2007 CurrentDb.Execute problem #1256492

      Thanks John,

      Done and done! Problem solved.

    • in reply to: Help with vb equation for trig values #1256020

      Can someone help with this then?

      Cot A = 1/Tan A = B

      I have B, what do I do to it to get A? (in radians)

      I need A in radians to then put it into the second equation above to get J

      A= 0.090757121103705 Radians

      Cot A = 1/System.Math.Tan(0.090757121103705) = 10.9881501380931

    • in reply to: Lost: 300 gigabytes of valuable drive space! #1239917

      As an aside to Fred’s last comment

      And isn’t this a strange topic? A few years ago, 4GB seemed vast. But now we’re routinely bumping up against its limits. Yow!

      I can remember years ago at the local computer club when an average PC ran on 4Meg, someone brought in their computer to show off Myst and the general poo-hooing that went up about the “decadence” of have 64Meg of memory JUST to run a game!

      It really makes me smile every time I think about it.

    • in reply to: Help with booting issue #1227686

      The laptop is a Toshiba see here with a multi card reader. I have tried it with an Olympus and an SD card and it does the same with either card

      EDIT: Just noticed that the laptop thinks that the card reader is a disk drive

    • in reply to: Help with booting issue #1227680

      I have stumbled onto the cause (but not the reason) of the original slowdown. it is related to the card reader.

      After getting UBCD4Win and copying off all the desired files and backing up settings, I then reformatted and loaded windows (note: learned that some windows keys are tied to particular sp release disks) in loading all the various drivers I discovered that when I removed the flash card from the reader the system started pausing as it originally did. As soon as I re-inserted the card it reverted to normal. I then rebooted the system and removed the card and found that the boot slowed down as in my original post until I replaced the flash card, upon which the boot picked up again and completed loading.

      Any Ideas?

    • in reply to: Multiple Firefox profiles [nice trick] #1215857

      Here is a ready built firefox extension that allows you to change profiles or load a second one as well

      Profile Switcher

      I found it while browsing for something else. Talk about serendipity!

    • in reply to: Maths Question #1208610


      Many thanks, your maths was spot on!


      I’ve never played with solver before but thanks for the suggestion.

    • in reply to: OLE Server Error in Access 2007 – HELP!!! #1192223

      Thanks Hans, it works fine

    • in reply to: OLE Server Error in Access 2007 – HELP!!! #1192173

      Umm, thanks Hans but the coding is a bit beyond me. Could you write the code for a button to open a file picker window to select a file to be opened and read by the code?

      This what I need to emulate:

      lblDetails.Caption = "Counting Records"
      Me!ProgressBar2.Max = 1
      Open CommonDialog1.FileName For Input As #1

      Thanks in advance.

    • in reply to: Dealing with open documents #1180243

      Thanks Gary! Just the type of hint I was looking for.

    • in reply to: Tab Key behaviour #1162442


      Thanks, that’s what I needed to know.


      It’s a case of trying to keep the boss happy if possible before having to tell him that you can’t do it.

    • in reply to: Dealing with a missing value (Access 2003 xp sp3) #1143091

      Thanks Hans,

      I built a new query combining both sources as you suggested and it works fine.

    • in reply to: How to turn off edit mode (Access 2003 xp sp3) #1136446

      Thank you Hans

    • in reply to: How to turn off edit mode (Access 2003 xp sp3) #1136444

      John, I see what you mean. I’ll try putting the emp number as a default value

    • in reply to: How to turn off edit mode (Access 2003 xp sp3) #1136441

      Hans, A slight diversion in reference to your post of using

      CurrentDb.Execute “DELETE * FROM tblContTimeCards”

      Is the syntax right to replace a query with the following SQL

      DELETE tblOT.*, tblOT.jdate
      FROM tblOT
      WHERE (((tblOT.jdate)=DMax(“tblOT.jdate”,”tblOT”)));


      CurrentDb.Execute “DELETE * FROM tblOT WHERE (((tblOT.jdate)=DMax(‘tblOT.jdate’,’tblOT’)))” ?

      I am delighted with the above code that you showed me as I have been attempting to streamline my DB and being able to replace a few queries with 1-liners is great!

    Viewing 15 replies - 31 through 45 (of 184 total)