Recent content by zdas04

Thank you, I couldn't find any reason that neither my list box selection process on a form or my link to an external picture stopped working when I (foolishly so far) went to Access 2007. Converting the db to 2007 seems to have fixed the problem. David

Renardp, The "graphics" look very much like what I used to punch into Hollerith Cards using WatFor in the '70s. I don't think that graphics libraries are going to be an issue. I did get some compile warnings (the program is actually 6700 lines not 1000) but they all look like variable...

GerritGroot, Thank you, that was exactly what I was looking for. David

I recently purchased rights to an old (1972 vintage) FORTRAN program. I can run it on a Citrix server, but my license there expires next month and since the rights included source code I'm trying to compile the source locally and not have to renew the expensive Citrix license. I downloaded a...

Thanks for that. I really wanted the automatic page n of m capabilities, but I think I'll just change my numbering scheme to print the report in 10 chunks each with it's own page number prefix. When is Access 2007 supposed to be a real product? David

Thanks for the idea mp9, but it stopped 55 pages sooner with the "String" than it did with the "Variant". David

I've got a database with 1400 records in it. Each record is associated with a .jpg file whose file name is the same as the primary key of the database. These .jpg files are really small (about 30k/picture) vector drawings from Macromedia Freehand. Using some code (see below) I got from...

See thread779-1218730 for the answer. David

Jakrabit, I hate that I can only give you one star for this. That link (which I was not able to find in 5 hours in the knowledge base) fixed a problem that had been driving me right up the wall. Thank you very much. David

I've got a two-dimensional array of physical properties (i.e. AnalysisConstant(0,0) is Methane Molecular Weight, (0,1) is Methane Specific Gravity, (1,0) is Ethane Molecular Weight, etc.) that I'm trying to display on a form. My first thought was to define 105 text boxes and use something like...

ChipH, Thanks, I like the .ToString option, it seems more consistent with VB than the old CStr(format( syntax I was using. The problem I had turns out to have been that I declared my variable as "Long" when I meant to use "Double" - I hate it when the computer does just what you tell it to do...

Why are simple things so hard and difficult things so easy? I'm simply trying to display a number like 16.043 on a msgbox. What I get is 16 When I try to format it with Format(numField,"#0.000", yes, I am an old COBOL programmer) I get 16.000 . What dumb little thing am I doing wrong...

JohnYingling, I had a very similar problem as bigfoot, and your solution worked perfectly. I tried to give you a star, but I'm not sure that process worked as well. David

I've got the same problem (in Excel XP). Pasting an HTML table from a website (that I have no control over) with values like 1-5 gets translated into wierd dates. The format of the worksheet is completely overwritten, paste special gives me options like "HTML", "Unicode...

When I used to teach database theory (in a previous career) I would describe Access as a "source of data" and Excel as a "use of data". Sources of data provide a data repository and a method of data orginization as separate entities. Uses of data take a particular...