Search results for query: *

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...

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!

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 ;-)

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...

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...

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...

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

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...

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 ;-)

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...

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...

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

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

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...

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...

As much as I like VB, twiddlin' bits doesn't seem to be its strength. AND OR XOR IMP NOT work OK but shift or rotate? There's always the rather unseemly using multiply & divide by powers of 2. a = a * 8 'to shift to the left three a = a \ 8 'to right shift but these are replete with pitfalls...

OK, time to learn about setting registries. & yes, now I see that my method changes with the "frontend copy" & not with "user profile." thanks

code looks fine to me (Gord?)... we're on the same wavelenght. is being on my wavelenth good? is another question ;-) But I did want to warn you that using a flag in the table to get records for reporting is a single thread solution. i've done it i know. that is: what happens if you use the...

Rick has way more experience so I listen when he posts. But, Rick, I've been using A2K & doing this w/o saving the app settings as an extra step, in fact i have to go to pains to NOT have previous defaults settings set using the above method appear at "wrong" times. Is this an A2K vs...

In the 1st control's afterUpdate event change the second control's rowSource so that the query will only select the records you want and then requery the second control. Private Sub FirstList_AfterUpdate() Me.TeacherList.RowSource = _ "SELECT Teacher From MyFile " _...