Search results

Okay, I've finalized on two static documents (one Word and one Excel) that will be stored in the table. I've experimented by opening and closing the documents many times from within the Access table. As long as the documents are static then there is no bloat that occurs. However, I could...

Thank you for the quick reply. However, there is no point in me even putting them on the form, if they can't be stored in Access. I need to have a single file footprint for this application. However, at most there will be three documents stored (two Word and one Excel). They should be...

I have documents (mostly Word) stored in an Access table. The table contains two fields. (1) a text field with the document's name and (2) an OLE field that holds the document. When I press a button with the document's name on it (or it could be a hyperlink or a dropdown) on a form then I would...

Thanks Thank you all very much. =(([TimeOut]-[TimeIn])*24)-([TimeDC1]/60+[TimeDC2]/60+[TimeDC3]/60) in the Control Source works perfectly.

Still and error Hello, Attached is a gif of how I have the fields set up. However, I'm receiving an error. Can you advise? Thanks again, Andrew

Say I have four fields, only one of which will be submitted to the DB. Form field one is "Time_In" (short time). Form field two is "Time_Out" (short time). Form field three is "Time_Wasted" (minutes?). Form field four is "Time_Worked" (minutes?). Only form field four will be submitted to...

Thank you ! ! ! Thank you ! Thank you !! Thank you !!! Maybe one of these days I'll get the single and double quote logic down (but I doubt it). Thanks again for the help, Andrew PS. I'm putting a fixed copy of the DB example at the hyperlink above, in case it will help someone else.

This is very similar to another post of the same name. However, my problem appears to be because the report includes data from both a form and a sub-form. I've received feedback before, but I'm still unable to get it to work. I've placed a sample DB here. If someone could download the file...

Thanks Thanks. :D That did it perfectly. Since it was a VBA sub I was looking to find, I put it here in the VBA forum without thinking about the application. Thanks for helping out anyway. Andrew

I can do something like     ActiveWorkbook.Names("auto_open").Delete for each name in my workbook. But I have a bunch of names. I've tried several methods to delete them all at once (like array...), but without success. How can I just delete all names in the active workbook? Thanks in...

Thanks for the help. I wasn't able to get the code to work. I don't understand why, but I don't have time to pursue it now. I just created my linked tables and chose to save the password. Sometime, when I have the opportunity, I will give more attention to your code. Thanks again, Andrew

Thanks for the help. I just recreated the linked tables and it is working. Andrew

What / where is the linked tables manager? In my DB tables view, I see the globe icons for the linked tables. If I open the tables then I'm prompted for my username and password, but there is no option to save them.

I created a bunch of linked tables, but did not check the "save password" box. Is there a way that I can enter and save my password with the linked table now, or do I have to create them all over again from the start?

Can you export (TransferSpreadsheet macro) to a password protected Excel workbook? If so then how? I haven't been able to find instructions on this (saying that I could or couldn't). Thanks, Andrew

Well, I wasn't using a module, but I don't see why that would be a problem - except that I don't know how. This is what I've done so far (that doesn't work). If you could tell me where I'm going wrong then I'd be appreciative. I created a new module and called it "OracleConnect". The module...

I did, but I didn't find the code to use - only references to it. (I would much rather use VB than the external tool options.) Probably I just missed it, but I spent over 45 minutes looking. If someone can give me, or point me to, the VB code then I'd be very appreciative. Thanks, Andrew

I'm linking tables to an Oracle database. I've set up a system DSN that allows me to connect. However, when I run the macro that opens several make-table queries on the linked tables then I'm prompted for the Username and Password to the Oracle database. Is there a way I can store and input...

Thank You ! ! ! Thank you. Your example led me right through what I needed to do. Of course, I had to make some tweaks, due to ever changing requirements. But with your example as a learning tool, it was easy. - And I never would have figured it out on my own. Thanks again, Andrew

thank you - but headed home to bed now Whoa, Jon! Thank you! I just took a last peek at the forum before heading home and off to bed. I've already downloaded the file and I'll examine it tomorrow. I'll give a full reply then. Again, thank you. Andrew