Search results

Create a new table called tblarchive. In the db window create a new query. In design view select your working table and select the fields that you want to append. Right click in the query where the table is and chose the append query type. This will prompt you to enter the table which you want...

You could use an append query to append the data from your working table to an archive table. Then use a delete query to delete the contents of your working table.

Hi all, I was wondering if anyone has ever used this powerup from Unisoft and what are the pros & cons. I would be interested to know if anyone has used any alternatives ( If there are any). Thanks in advance. Kev.

Alex, Thanks for your reply. I have managed to solve it now. What I am doing is using the common dialog to aid the user to insert a path to a stored image file in a table ie. .Fields("PathHolder") = Cmdlg.FileName Maybe I'm going about this all wrong but It seems to be working now...

Hi all, I have a routine ,part of it is to update a field value in the current record. I am using with rst .Edit .Fields("MyField") = "My Value" .Update .Close etc,etc, The problem is that instead of updating the...

In your form properties make sure that 'Shortcut Menu' is set to yes.

erinkleiman Like I said to Hayley, I never tested the code I just wrote it on the fly. You could probably loose the left statement and just use a test to see if the current date is equal to your email send date. Kev

If you are in debug mode you will not be able to set references. Make sure that you access the VB window whilst in design view of your form or stop the debugger. Too Late!!

erinkleiman In the VBA window go to Tools>References and tick the 'Microsoft Outlook 9.0 Library'. That should do the trick. Kev.

In the VB window go to Tools>Reference and make sure that you tick the box 'Microsoft DAO 3.6 Object Library'. Also make sure that it is set to higher priority than the Active X library other wise you will need to use 'dim YourDb As DAO.Database' Kev.

Try 'Microsoft Common Dialog Control' from the tools menubar.

Create a new unbound form. Put an unbound combo box in the form and set the ROW SOURCE to link to the table that holds all the option for you original combo box. Put an unbound Textbox in the new form and set the CONTROL SOURCE property to equal the new combo box and set the VISIBLE property to...

I think Approach uses Dbase files so if you go to Get External Data>Import and then choose DBase IV in the dialog box you can import all the data from the approach database.

To import data, on the File menu, point to Get External Data, and then click Import. To link data, on the File menu, point to Get External Data, and then click Link Tables. In the Import (or Link) dialog box, in the Files Of Type box, select either Outlook() or Exchange(). Follow the...

This link may point you in the right direction for coding.http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30353 You would need to add some code to test for your event. Kev

You can use the Now function just make sure that your field is set to short date format. But the Date() format is preferred

In A2k it is :- Me.Cmdl01.InitDir = "Drive Letter" Me.Cmdl01.Filter = "*.jpg|*.jpg" Me.Cmdl01.ShowOpen I'm not sure if it is the same in 97. Check your library references in Tools>References. Make sure you have the ActiveX Data Objects 2.1 ticked. Kev.

Use the 'Microsoft Common Dialog Control' which you can find in the 'More Controls' button on the toolbox menu. Kev

In the VBA window go to tools>References and make sure that you have all the same references selected as the other users. Also check that none have 'MISSING' written next to them. Kev

Resolved. Thanks anyway.