Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rafe

  1. rafe

    Time Stamping

    I stamp my records (documents) too. to track document flow thru the beauracrappy that i work in... you may want to update your stamp by setting Me.Time = Time() 'Or Now() to get date & time in the AfterUpdate event of the Me.Confirm control. You can use either a macro or VBA. Hope this gets...
  2. rafe

    Change Control on Subform

    Certianly is (Good question) Check out the "FormatConditions" property under help. It's just slightly more complicated than the usual property settings. There are samples too. Happy coding!
  3. rafe

    Change Control on Subform

    I've got a question for you... Are you using A2K? The only version I know... If so then, look at the "Conditional Formatting..." under the "Format" menu, when you have the conrol in question selected in design view. If you don't have A2K then you need EXPERT help ;-)
  4. rafe

    is my software safe ?

    Curious? What about runtime debuggers? You've gotta decompress to run. Of course I may be way off target here. Altho I COMPLETELY agree with the time vs. money equation on this. Slow them down enuf so that it's cheaper to roll they're own. I should tell you that I've seen some 13-year-olds at...
  5. rafe

    is my software safe ?

    Well go figure... I like BOTH VB & assembler :-P Anyway... A determined hacker is going to be able to get at your formulas. There are tricks to slow them down but no way to stop them. You don't even have to be an expert. The only question is: Is the time going to be worth it? If the formulae...
  6. rafe

    List Box Question

    Chris, I do something similar... I get away without doing a table write b/c a multi-column listBox can be thought of as an in-memory table... anyway Hope the following modified snippet helps either way. Private Sub OKButton_Click() Dim SelectItem As Variant If...
  7. rafe

    Can this be done in a Query or Filter?

    Just did a mock-up SELECT [AccountNum] From [OrdersText] WHERE ([Account#] = 'Pending') AND ([Rep] IS NOT NULL); Worked just fine. Hope this helps.
  8. rafe

    Help with Query By Form to produce Reports

    Bryan, Without particulars it's kinda hard to tell just yet but you should look into "Left & Right Joins" and "Select Distinct". If you post details I'll try & help more. Sorry. Roe, Sky's the limit here. Translation = there are many way to do this just pick the one that...
  9. rafe

    MSOWCF.DLL

    mmmm... I didn't know that! Thanks! I did get to the NETWORKDAYS function in excel but it wasn't thru the *.dll. Actually, I was doing a search in my Ms. VBA help... which is where I learned of these functions. Grrrr! OK time to roll my own ;-)
  10. rafe

    MSOWCF.DLL

    Hi All, Trying to clean things up in the last few weeks of this job. So I'm a bit... well stressed. I discovered all of these potentially useful date functions that would really help speed up final delivery & blissful departure B-) Just a taste EOMONTH function NETWORKDAYS function Sure I...
  11. rafe

    calculating elapsed days while excluding work and holidays

    Found this function while looking thru A2K help... Rather than reinvent things I thought I might give it a try... however, altho it works great in Excel I haven't gotten it to work in Access yet, referencing msowcf.dll isn't helping ... i'll keep you posted...
  12. rafe

    Is there a report Guru in the house?

    Open the report in design mode Goto "Page setup..." on the "File" menu There's a "Column" tab. That should get you started. Hope this helps
  13. rafe

    Windows Explorer SLOW

    butchrecon & dball63, Back at home & w/ the problem computer... I tried the system.ini change & well... it helped some but not a whole lot. C: has 7.85GB w/ 2.65GB free. I'll keep chugging away at this end too... gotta learn... but I do appreciate your help. thanks
  14. rafe

    Windows Explorer SLOW

    Hi, My windows explorer on a Win98 system slows to a crawl. It can take over a min to move to a new directory. It's just explorer. The symptoms snowball after entering a directory w/ about 30-40 (it's at home now) subfolders and 2 to 3 other files. Each subdir has about 10 to 50 files in it...
  15. rafe

    Page size setup on mailing labels form

    Silly me... LOL ... so easy in my case. There's a Wizard for label reports in A2K! Select reports on the DB window... Select the "New" button on the top. Then select the "Label Wizard" Now hope your flavor of Labels is supported. Now where's the smiley for hitting yourself...
See more

Part and Inventory Search

Back
Top