Recent content by sailinxtc

using the code I posted, I am not sure I am picking a file, I don't give a output file so it prompts me for a file name, can I utilize what I am using already with the DoCmd outputto or are you stateing I need to do something differnt and use a folder picker ? I am not that familiar, do you...

utilizing the DoCmd OutputTo Method and leaving the OpenFile blank so it prompts for the file name, is there a way you can set the filename and still have it open the output to dialog where the user can choose the path but the filename is already set in the dialog ? Dim pdfFile As String...

sorry if this is a highjack but was working on a similar situation with Pdf's and reports Basically am trying to utilize the Save As dialog and fill in the name with [Log_ID].pdf One way I have it works but brings in the report name and will allow the user to change the name manually but would...

I am getting the same Runtime Error 2465 when utilizing the following code and the debug points to the If Statement. If I use the same code with a double click event the calculation works but don't utilize the If and Loop code, so not sure what I am missing with trying to use the on current...

I am using access 2007 with VB code and would like to do a similar method for the savefiledialog method, where the filename would be filled in by default for the Save As entry with the primary key, where the table name is "Log" and the primary key is "ID" I was able to get the following code to...

whooops, wasn't aware........

Does anyone know if the Export/Import to a text file will work with the Runtime 2007 ? It works withing my Application on the machine I developed it on, but not on the Runtime Machine... Basically I run a macro that calls the pre saved Export and/or Import file that I created with the export...

I have a related question... I am using Application.FollowHyperlink txtURL with a button and a text box named txtURL I have set a default URL in the properties for the textbox I used the button property on click event procedure to call Application.FollowHyperlink txtURL This works well...

Well What I did, or didn't do was so simple I almost don't want to admit... When I moved the data from the old MDB to the .ACCDB format with 2007 I didn't set the database to open the switchboard, So in turn I got nothing..... hope this simple mistake can help others that miss it...

Narrowed it down a bit more.... I can open the .accde file in Access 2007 (non runtime version) and all works fine. Installed just the runtime on the other machine, without using the package manager and opened the .accde file and get the following warning message: Warning its not possible...

Have another question with the Access 2007 Package Manager and Runtime. Originally my database was started in 2003 and have worked with it in access 2007. The file extension has always remained a MDB or MDE. I started looking into compiling some of the modules and found that one should create...

Not sure I worded that correctly... When the packaged solution installs on a computer that just runs the Runtime access version with my database. It requires the mscomct2.ocx be Registered. This requires copying the mscomct2.ocx file and also the Regsvr32.exe via some method, and also calling...

I simply googled the REGSVR32.EXE and downloaded the simple instructions and file from microsoft site and also downloaded the mscomct2.ocx file from microsoft. Seemed to be the same method for Vista also but have not tried it yet. I ran into the problem with the Runtime Version on other...

The Code I posted was an example from the forum and also on MS Access site. If you search on browser API it comes up all over and also in search engine listings... I agree hard to follow and probably why I am having so much trouble. All I want to do is use a browser GUI to copy a file from one...

The code I had posted prior is what my button was calling - on click - as an event procedure. I will have to look into further on tempory storing the file and location etc... not to experienced with that yet. thanks