Search results for query: *

Thank you! Depressing news on EG and debug - but the how to search for errors tip will be invaluable I'm sure!

Under help I found a debug environment code. The example code in help starts with: data tours (drop=type) / debug; Debug (in help) says it allows you to step through the code to watch variable results. VB and VBA have similar debugger environments so I was excited to find this! But when I try...

Does debug work in Enterprise Guide? I get an error in both the learning edition I have at home and the server version at work. I can't find any information that says they don't work together. Thanks in advance!

Thanks to both of you. The except did work. I finally got proc compare to work on my larger dataset(s) by modifying code generated by using the task list in EG from a smaller working compare.

Can someone point me in the right direction! We are retiring a server. I am transfering code to the new server and modifying sources. I need to compare the results of the data created from/on the old server to the new server. I used the compare task in SAS for a smaller data set - 55...

Thanks to both of you...I've had several 'DUH' moments as I'm so new to this! The only other issue i'm having is since its character I get an error in the log that its an invalid data type - but it does do the conversoin. There must be a way to convert character to numeric first to avoid the...

I'm almost brand new to both sas and sql - hopefully this is easy! I've got an effective date field coming from a mainframe data file. It was created in mainframe sas as a character field. Value is yymmdd. I want to convert this to a sas date format to use the various date functions for...

I just created a 2000 dbase...it runs great if I copy it down to my local drive but if I'm running it off of the network it takes 3 minutes to do just about anything. We're converting to 2000 from 97 and I've never had a problem with 97 on the network. Does anyone have any ideas why this is so...

THANKS...mine doesn't work if your balance contains zero but your's does! ie 522.25 works with mine but 522.00 only gives me seven characters instead of nine...

answered my own question!! code is: strBalanceSc = Mid(rstOCR!Balance / 10000000, 3, 9)

I have to convert a number to a string; of course that's the easy part...then I need to make the string 9 characters long with leading zeros: strBalanceSc = (rstOCR!Balance * 100) Right now the answer to this is "59925" I need 000059925. Any ideas?? Thanks! Lora

Is it better/more efficient to write queries with SQL in a code module or to write queries in the query tab? I have an application that has many queries 45 so far and will probably have at least an additional 50. I'm calling the queries from a code module. This could be a preference issue(?)...

Hi, is there a way to create control arrays in Access? I just took a Visual Basic course and want/need to use a control array of command buttons but can't find a way to do this? Thanks Lora

A 'real' windows programmer could probably explain this better than me ;-D I took a windows programming class last semester and one of the things the prof showed us is how much CPU 'space' just capturing the mouse coordinates takes..demonstrating that especially clicking and dragging can...

We have an OCR machine which reads a scan line created/printed with a PCL font. This prints fine on a Win 95 machine. No one has had any luck getting it to work in NT. Loading the font is simple but in win 95 you can edit the font and change it to swiss instead of roman. Is there anyway to do...

whoops, asViewNormal...

FYI if anyone has this happen to them...I think i solved this. I kept crashing on my print statement, every third or 4th time i requested it...I did not include the acNormal, eg, DoCmd.OpenReport "rptCBSVoucher-111", acNormal, at the end of my statement as acNormal is the default...

I'm using access 97, and now it appears that my other forms are crashing the app, appears to be the print process as i even crashed trying to reprint my code... I hadn't put this on the network yet so it was/is just me creating testing when the issue started So are you saying my whole database...

Hi I wasn't sure which access forum to put this in! but looking for ideas...i have a pretty basic access button which runs an event to clear a table, run some queries to populate/create some tables for a report then display and print the report (in other words pretty basic stuff!). I keep...

Any idea on how to code for file saving...i know this is probably easy but i've never done it!...i need to back up a bunch of files that i am downloading from the mainframe monthly.  i need to create a directory with the months name and save all the files to it...THANKS!