echo false isn't working
Fri, 26 Sep 2008 13:20:01 -0700
So, I've a couple procedures where it would be better to not have the screen
update.
I've tried both docmd.echo (false) and application.echo false. In both
cases, there are still screen updates, specifically, the all open windows go
white for a few seconds.
Is there anything that needs to be used in conj ...
|
Record Source Theory
Fri, 26 Sep 2008 10:38:02 -0700
After a few years of working with Access, I realize that there are about five
ways to do anything. With that in mind, what I am looking for is an opinion
on the "proper" way to design a professional database. The issue is this. I
have an ODBC connection (System DSN) to a large application that hundreds of
pe ...
|
Refresh a form
Fri, 26 Sep 2008 10:10:02 -0700
Hello,
I am building a routine (module) to refresh the content of an Accessform.
The fields (textboxes, combo-boxes, and their lables, and the commandbuttons
as well, I will define in certain situation to make them visible or to enable
them.
But....first of all, I want to 'clear' my form or make all my in ...
|
Copy Record - Is field autonumber
Fri, 26 Sep 2008 07:56:07 -0700
I'm working on a function that will copy a specific record. Anyone have a
function that will do this? Basically, I'd like to be able to pass a
tablename, the ID field, and ID value to this function, have it copy the
appropriate record, and return the new value. In addition, I would like to
have the option ...
|
Query Problem
Fri, 26 Sep 2008 09:32:11 -0400
Help, I cannot figure this out.
I have a group by query and I am having problems with multiple OR
statements. When I save the query it puts each parameter on a seperate line
and then it doesn't work properly.
My parameter criteria is: Not Like "*9303*" Or Not Like ";S1C *" on field
Comments with anothe ...
|
Query in VB/Passing it to a form/query
Fri, 26 Sep 2008 05:58:11 -0700
A Query figures out what paint has what particle size.
Switchboard has a bunch of check boxes with particle size ranges and people
can select and the querry is suppose to return another form with the list of
paints that match the particle size range. I am not sure how to relate the
check boxes to the query a ...
|
Row in Database locked
Fri, 26 Sep 2008 05:36:06 -0700
I have multiple users using an Access database (Interface) connecting to the
main Access database on a server. I have found that sometimes when updating a
record while another user might have the record open on a query Access just
ignores the update without returning an error.
Code:
' Ch ...
|
|
|
Reference a field dynamically
Fri, 26 Sep 2008 04:00:01 -0700
Hi, all!
I've tried to search the forum for an answer to this, but haven't been
successful.
I try to do the following:
To alter the label caption for a field programatically, so I can alter more
than one label using code.
Example:
I want labels showing 1:, 2:, 3:, 4: to alter their texts to:
1-1:, 1- ...
|
DAO coding question opening a record set.
Fri, 26 Sep 2008 16:41:35 +0800
Hi,
I have a piece of codes like this:
Private Sub Submit_Click()
Dim dbs As Database
Dim qdf As QueryDef
Set dbs = CurrentDb()
Set qdf = dbs.CreateQueryDef(CheckPartNum, "Select PartNum from PartNum
where PartNum='" & PNum1 & "'")
Set rst = dbs.OpenRecordset("PartNum") 'PartNum is a ...
|
A openrecordset question
Fri, 26 Sep 2008 17:01:35 +0800
Hi,
I have codes like these:
Private Sub Submit_Click()
Dim dbs As Database
Dim qdf As QueryDef
Set dbs = CurrentDb()
Set qdf = dbs.CreateQueryDef(CheckPartNum, "Select PartNum from PartNum
where PartNum='" & PNum1 & "'")
Set rst = dbs.OpenRecordset("PartNum")
If Not rst.EOF Then
...
|
