All the tables, local and 2 linked are in one file, the second file are Queries, Forms and Modules, it is not compiled yet.
The splitting ran smoothly, it's about 1,5k records so far. The Queries RecordLocks property was set to Edited Record.
My Access database is linked to Oracle and I use query to insert data to local table but also to display some corresponding data from Oracle in the continuous form.
It was very useful when inserting manually product indexes, allows to avoid mistakes and was a confirmation of product "Active"...
I put here the part contains Combo selection box.
Is there any way to force it to select proper data column in the form before filtering?
'Yes/No field and combo example. If combo is blank or contains "ALL", we do nothing.
If Me.cboFilterIsCorporate = -1 Then
strWhere = strWhere &...
Hi All,
I would like to make a little modification to Allen's Browne Search Form.
Because I can not add links yet, it is the first Search Form under Applications / Utilities on his excellent website (not "Search As You Type" which I also use with great satisfaction).
So I placed whole Search...
My name is Michał and I live in central Poland.
I'm rather a new user to Access, I used to mainly work in Excel before.
Curently I'm trying to move most of my data to Access because of the increasing number of users in my department of the company.
Thanks,
Michał