Recent content by icupat

Hey, This is what I'd like to do. When I create a record on one table, I want it to create a new record on the other table taking some of the values from the original table. So i have tableA, with a related form. When I put in the "itemname" it creates a calculated value based on the...

Is there a way to show a pdf preview on your form, in such as your are able to show a jpeg/gif or whatever if you use "insert-picture"?? It seems that the only way you can view pdf's is by opening it up in the reader, but i know that Internet explorer is capable of opening it in a...

I think part of the problem is that I want the ROWSOURCE to be difference for each record. So maybe I should store the string with filenames in a "in-visible" text box and just have the an form_onload() event that sends the names into the list box?? I think that may be the best...

Perhaps you can try the code yourself. You'll neeed: A list box called "mylistbox" set to "value list" A command button called "browsefile" A text box calle "directory" A label called "myhyperlink" A image box called "imageframe2" A...

Rowsource type IS already set to "value list" and the filenames are brought in at run time through an api browser, that brings in the filenames in the windows explorer multi-select style that looks like this: c:\path\%"filename1"%"filename2" I then have a...

I was putting the filename values in as rowsource btw, if that helps.

Ok. I have a list box that's populated with filenames. Anyways, it's a value list that I'm using. However when I close the form and then restart it, it only remembers the value of the item in the list box that was selected, it doesn't remember all the other values in the list box... is there a...

nevermind. found a solution that involved a commondialog box, a list box and a some visual basic... for those interested here's the code, there's a few subs... each should be self-explanitory... one important thing is that you need to create a dummy label called "myhyperlink" and you...

Just for your info. If you go to that website (the microsoft one) it doesn't give you the code for a multi-selectable explorer window. You have to add the following to make it multi-selectable: Const OFN_ALLOWMULTISELECT = &H200& Const OFN_EXPLORER = &H80000 'put that at the top of the code...

Ok. Here's what I want to do: I've got a browse button that pulls up a MULTI-SELECTABLE explorer window. If I select 5 files, I want the list box to be populated with these five name (JUST the filename), and then I want them all hyperlinked to the proper location (pathname+filename). So that if...

Try searching for "hard drive browsing" in the "access modules: vba coding".. there's a few examples.. i think the link below should be one example: thread702-187768

hmm.. thought i had tried that, but perhaps i put too many commas.. thanks anyways. I actually think there might be a better way to do what I wanted. But originally what I wanted was one form with an employees company info, then you click on a button and goto to a password-protected form with...

hmm.. thought i had tried that, but perhaps i put too many commas.. thanks anyways.

Is there an easy way to go to a certain record without going through all the previous records?? ie. If I had a 1000 records and I wanted to goto record 499 of 1000 then the only way I can see doing it is a for loop with 1 to 499 and using the "next form" command.... which would take...

nevermind.. i hate the microsoft site, but i found help on this... it's OFN_EXPLORER that defines using the new explorer-style browser rather than the old style multi-select box for those interested.