Search results

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...

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...

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...

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...

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

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...

Is there a way to include the "Compact and repair database..." function in a macro? I have a macro that runs a lot of make table and delete queries. Consequently my database "grows" considerably. I'd like to 'compact' the database at the end of the macro. Thanks in advance, Andrew

I have a table with say two fields, Item and EffectiveDate. I will have data as follows. Item   EffectiveDate (mm/dd/yy) One    04/01/2003 (record 1) One    04/04/2003 (record 2) One    04/06/2003 (record 3) One    04/03/2003 (record 4) Two    04/05/2003 (record 5) Two    04/04/2003...

I have a database where the "Item" field sometimes contains item codes with an asterisk as the first character. I want to filter out all item codes that begin with an asterisk, but for the life of me I can't figure out how. Any help will be greatly appreciated. Andrew