Search results

an itchy crotch

one must change

for the speed

Hehe, didn't mean to.. you just seem so danmed knowlegable about access/vb that i was kinda shocked to see you ask a question. My humble appology. Gomen, sugoi gomen.

which galantly increased (haha groundrush :p)

If you didn't understand what he meant, he meant this: Dim RSRecord as DAO.Recordset

Make a batch file (*.bat) with this exact contents: @echo off C:\Program Files\Microsoft Office\Office\msaccess.exe /wrkgrp "X:\YourWorkgroupFile.mdw" "X:\YourFrontendDB.mdb" C:\Program Files\Microsoft Office\Office\msaccess.exe /wrkgrp "X:\YourWorkgroupFile.mdw" "X:\YourBackendDB.mdb" Make...

Wow, the great Mile-O asking a question... shit that's new. My guess is access only, vb6 to my knowledge dosent have support for the ! operator nor [] tags for fieldnames, a lot could be missing that may be required. My suggestion is that you try making a SIMPLE addin in vb6 first and see what...

myVariable = RSRecord("myFieldname")

I have text boxes set togrow if needed in my page header, but the header will not grow to account for larger text boxes... any ideas?

high horse of

Try looking @ this:

It shouldn't

This Macro shortcut is what you make the scheduled task run, you can put it anywhere but it's neccessary to make the scheduled task that runs it automatically. The template would hold the base information, and things like dates/times would be filled in dynamically and added into the main...

Actually this is better.... Make a new table with the conversions... you know Mon AM,S1 Mon PM,S2 Tue AM,S3 Tue PM,S4 Wed AM,S5 etc... Then Join the two fields that have the mon am shit in it then include the field that holds the S# 's

In you're new feild be like MyNewField: IIf([otherfield]="Mon AM","S1",IIf([otherfield]="Mon PM", "S2", .... and so on... Kind of messy though.

Stress test: Repititions: 100000000 Case: x dosent equal y Example 1: 14.437 sec Example 2: 20.0469 sec Case: x equals y Example 1: 12.531 sec Example 2: 17.1499 sec I suppose it's because example two has to make two conditional calculations, where as example 1 only has to make 1 Test...

Probably #2, ill stress test it though, gimme a min...

Ah, your method would work just fine.

bad. So let's