Recent content by raymond3090

raisbecp, if you could send me the correct syntax to do this I would be extremely greatful!! I need to do this but can't figure out how.

thanks for the responses everybody. You guys solved my problem! What would I do without this site!!? -ray

hi there, is there some way for me to return the path of the directory in which the database (.mdb file) is currently stored. I need to open an excel file from within the database. I don't know where the database and excel files will be, but I do know that they will be in the same folder. Any...

I considered it briefly, but thought I'd be stuck with gaps where I hid the fields. Can I somehow remove these gaps? To me, it seems like to do that, I'd be editing the report again and I'd be back to where I am now!!

andy: in my form the users can basically select as many variables as they want that they want to include in the report. They do this using a multi-select list box. So, when they click 'Develop Report' cmdbutton, I open this report in design view, add the specified labels and text boxes for...

thanks for the reply Andy! My only question then is, where do I place that line of code? The form will be open in print preview, then when they hit the close button ('X"), I want this to happen. thanks again.

hi there, I having an extremely hard time accomplishing this, what I think should be, an extremely easy task!! I have a report that opens in print preview when a particular command button is clicked. Some parts of the report are edited/created dynamically upon clicking this button, based on...

unfortunately, the message box is huge, but not blank! It is filled with text, just from the strTxt variable!

hi there. I am trying to access the contents of a file line by line. I am using the 'line input' statement, which as I understand, is supposed to return the lines of the file sequentially. It turns out that when I use it in the following code, it actually returns much more than a single line...

thanks for the reply llkhoutx! I don't really understand what you mean though. Why would I be concerned with openreport if all I want to do is close the report without saving nor prompting to save? In addition, does openreport even have a field that allows me to specify saving properties? I...

This was a previous thread originally posted by LIndaG. I have the same problem but the replies haven't been able to help me. I tried to email LindaG to see if she was able to figure it out but I haven't received a reponse. Here's the problem (in Linda's words): Any help would be very much...

travis: thanks again for your help. I tried to do what you suggested in the previous message. The code stopped this time (at least I think it did) but the temp file was still there. I'm not really certain as to what exactly it was supposed to do ie. how it was different from the last piece of...

nevermind, disregard the above reply. Figured it out. If I had read the Knowledge Base content closely enough I would have known that I had to add the PowerPoint library (if anybody's wondering!). Thanks Travis for the help. -ray

thanks, that's pretty much what I've been trying to do (I actually want to do it in Excel but figured that Access would be the same thing). I get an 'invalid enumeration error' on the .slides.add part with the following code: Dim ppObj As Object, ppPres As Object Set ppObj =...

travis: i used the code. It doesn't delete the file and as a result it's an infinite loop. After a couple minutes I aborted the task. -ray