Is there limit to number of files in a datebase in searching forms
Mon, 7 Jun 2010 13:27:10 -0700
Once I hit 1001 files in a database, search does not work. Why? ...
|
RE: Is there limit to number of files in a datebase in searching forms
Mon, 7 Jun 2010 13:27:09 -0700
Is this an Access question? So far as I know Access does not have FILES.
It has TABLES which has FIELDS that contain data.
--
Build a little, test a little.
"ky carver" wrote:
> Once I hit 1001 files in a database, search does not work. Why? ...
|
How do I control a text box via another combo box
Mon, 7 Jun 2010 13:07:41 -0700
I have read through dsome o the other answers and I just can't seem to get it.
I have a table called employee information.
Within that table are two fields. Retail Title and Retail Incentive.
I have a form with a combo box for the the Retail Title.
This field looks to a table called Retial titles which ...
|
Limit Combo Box
Mon, 7 Jun 2010 10:33:32 -0700
I will do my best to make some since.
I have a form for entering data into a table named dispatchdetatils The
Combo Box named vehiclebox on the form shows vehicle license plates numbers.
When a vehicle is chosen a new record is started and the new record milesout
field on the dispatchdetails table is popula ...
|
Form Subform DLookup
Mon, 7 Jun 2010 09:15:03 -0700
Team,
I have a Form / Subform (with tabs)
On the Subform, I want to:
1. Sum values located on the Form to values located on the Subform.
2. Be able to add a new record for a subsequent Change Order.
The latest attempt has been to display the sum is:
Private Sub txt_Change_Order_Current_Agreement_Value_Af ...
|
Is a vertical datasheet view possible
Mon, 7 Jun 2010 09:02:53 -0700
The standard layout for the datasheet view form is horizontal. Is there a way
to display the datasheet view vertically with the field names going down the
left side of the form and the data expanding to the right? ...
|
Default font for forms in Access 2007
Sun, 6 Jun 2010 17:56:14 -0700
How do you set a default font for a form or a report in Access 2007?. Mine
is always Calibri 11. Changing each time is tedious. I have looked at
several "solutions", (one here from 2004). None of which even faintly
describe what I see. My copy of 2007 is recent, downloaded 6 weeks ago. I
am using W7 ...
|
|
|
Even an error with this code I copied
Sun, 06 Jun 2010 14:41:46 +0100
I found a password login system for Access and copied it to aon click
event on a form in Access 2007, but there is an error in the coding.
I have created a tblEmployees with the following fields:
IngEmpID
strEmpName
strEmpPassword
Then I put a unbound combo box on a form with the username and password
fie ...
|
SubForm, or something Else?
Sat, 5 Jun 2010 11:08:57 -0700
I have Chosen (big Grin) to utilize the new Multivalued fields option offered
in Access 2007. But, as always, I get started very excited, but am unable to
finish...
Not sure how to design my Form - but it would be a Main Form Sub Form
With ChurchID (as Main) and a Subform with
PositionTitle1 (Non-repeating ...
|
applying concatenate filter
Sat, 5 Jun 2010 08:41:46 -0700
Hi All,
I tried to filter the record in my form but it seem it doesn't work as
expected.
I tried to create a concatenate filter and put all criteria in an array but
it seem, it just applying the last condition only.
here is the filter action code
============================
For each rs in array(rs1,rs2 ...
|
