Command button to open another database?
Thu, 18 Dec 2008 12:42:00 -0800
I have a command button on a form that opens another form within the same
database. Is it possible to have one that opens a separate database? Right
now my code for the former is:
Private Sub GoToCMLabels_Click()
DoCmd.OpenForm "frmCMLabelsDataEntry", acNormal, "", "", , acNormal
DoCmd.Close acFor ...
|
Command buttons to switch between forms
Thu, 18 Dec 2008 11:14:01 -0800
I'm trying to use a command button on each of 2 forms to enable the user to
switch back and forth and the click of a button. The code I'm using is:
Private Sub GoToCMDM_Click()
DoCmd.OpenForm "frmCMDMSearch", acNormal
DoCmd.Close acForm, "frmCMLabelsDataEntry", acSaveNo
End Sub
Private Sub GoTo ...
|
delete records from one table if not in another
Thu, 18 Dec 2008 11:27:51 -0500
how can i delete records from one table if the records do not exist in a
matching table? i am making a backup of a table before an import is
performed. the users may need to undo the backup so i need to be able to
delete only the new records. this is not working, but you get the idea:
DELETE tblPatient.* ...
|
select into overwrite table
Thu, 18 Dec 2008 10:18:40 -0500
how can i automatically overwrite an exisitng table when i execute a select
into make table sql statement?
tia,
mcnewsxp
...
|
printing labels
Thu, 18 Dec 2008 06:28:27 -0800
Malcolm P. entered the following steps to make it possible to print labels.
"In Word, go to: >Tools>Letters and envelopes>mail merge.
Select >labels..................."
I get as far as "> Tools", and then have a problem. The next step is
"Letters and envelopes". I get "Letters and Mailings". I've played ...
|
?F?U?b?q?Z ?U?e?e?Z?h?^?h?c?q?Z ?Y?q?f?d?m?`?^
Wed, 17 Dec 2008 17:42:13 -0800
Ç÷ÈWÈUÈYÈlÈUÈhÈr ÈbÈ^ÈcÈiÈh ÈmÈ^ÈgÈhÈdÈXÈd ÈiÈYÈdÈWÈdÈaÈrÈgÈhÈWÈ^Èu
http://sanderswynx.chat.ru
...
|
Need to create a search based on a specific field
Wed, 17 Dec 2008 13:54:00 -0800
Okay so I am really new at all of this and I will try to explain as best as I
can as I would appreciate the return of information in the same matter (dummy
terms). On my form I need to create a text box that allows someone to do a
search based on one of my fields in my table. I actually need 2
searches...o ...
|
|
|
Default Value
Wed, 17 Dec 2008 13:29:01 -0800
In the primary table, I have an "ApproveDate" field, the next field
(ReportDate), I want a default value to be 6 months from ApproveDate. What
is the expression for this?
--
Dine Lene ...
|
Permission Denied 2007
Wed, 17 Dec 2008 07:54:29 -0800
I have a simple data base that I upgraded from 2003 to 2007. Everything
works as expected except a macro (called from a form) that creates a text
file of email address. I get a Access error "Permission Denied". I assume
there may be something I have to change with user permissions, but I can't
figure it o ...
|
Search question
Tue, 16 Dec 2008 19:47:02 -0500
Every day when I start Access, the first time I search a table (or
query) with ctrl-f it wants to search for the exact text and 'as formatted'.
I have to un-select both options.
Is there a way to have it save the settings?
TIA
Rich W. ...
|
