Recent content by grantc

Thanks that worked!

Hi A new record is a StockCode [part number] that doesn't exist in stock table i.e tblStock [StockID] - Autonumber [StockCode] [StockDescription] tblExcelStock [StockCode] [StockDescription] I only want to append tblstock with entries from tblExcelStock that don't already exist...

I have an existing packing slip access app that works really well, however I am wanting to update/append the stock inventory table from a linked excel table [excel data may change from time to time], but I only want to add new records from the excel table. I tried using an append query but the...

Thanks, works like a charm !

Hi Everyone I have a "pop-up" form attached to a main form that allows users to add items to a combo box on the main form. How do I get a new item added via the "pop-up" form to appear in the combo box without closing and re-opening the main form ? Thanks in advance. Grant

Thanks for the fast responses: I have been able to use the linked table manager with the MDE file and it seems to be working. The problem is the speed it takes about 7 seconds to open and populate a form with data which seems very slow even on a 10Mb network. I am not sure where to from here...

Hello I am about to unleash a database that I've been working on for several months and would like some ideas regarding splitting databases and making MDE's. I have read so many threads about file corruption etc that I am looking for the safest method. This is what I had in mind: Split the...

Hi All I am running NT Server and have a simple logon script to connect client machines to shared drives etc but I can't get them to run automatically when I logon. I have run the scripts manually and the work fine. Any ideas/touble-shooting information would be greatly appreciated. Grant

Thanks Doug Worked a treat !

I have managed to corrupt my ODBC Access driver files, Does anyone know how to re-install ODBC from scratch with all the default settings ? (OS WIN'95 Access 97) Thanks Grant

Hi DM I had the same problem a while back use this code as an event procedure when the button is clicked. Private Sub btnPrintForm_Click() 'Print Preview Button Code On Error GoTo Err_btnPrintForm_Click 'This code opens the report defined in the string 'stDocName limiting the report selection...

Thanks Guys ! I have tried both methods and they work great.

Hi All I am trying to apply an "IP Address" input filter to a text field in Access '97 has anyone done this ? I want the entries to be saved as 127.0.0.0 etc Any Ideas ?

Hi All How can I use the MS Date Picker V6.0 on an Access 97 form without receiving the MsgBox "Can't set value to NULL when check box property = FALSE" when changing records ? The error disapears when the "Check Box" is enabled but I don't want the check box on the...