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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.