Search results

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

Can anyone tell me how I can add new slides to a new PowerPOint presentation using my Access 97 code? It seems like it would be easy in 2000+, but I can't figure it out in 97. It has to be possible!! regards, ray

thanks for the reply travis! Before my 'kill' statement I added: MsgBox Dir("H:\temp.xls") which presented a message box with text: "temp.xls". I changed my import statements to include H:\temp.xls rather than just H:\temp. The import still works as expected, but I still get the same...

HI, I hope somebody can help with this, I'm stumped! I'm importing a bunch of data from an Excel spreadsheet. Right after I do this I need to delete that spreadsheet. I have the following code: DoCmd.TransferSpreadsheet acImport, 8, "tblFieldData", "H:\temp", True, "Field" ...a few more...

thanks matt! That works just fine!! Still stumped on the second one though. Any takers? -ray

ok everybody, a couple of tough ones (at least I think they're tough!!) Hi, I have a form where a user can select from combo boxes and multi-select list boxes the data types and parameters they want to appear on a report. When my code finishes, the report is shown in print preview. I know I...