|
any one can be my angel to help me with this code
have this data access database which I modifed.
In the Search form code I need it to modify code so, it look and match more
then one field. If the record is not in one field then it should go and look
for the second one or third. pl see the code. pl some one hlep me.
Thanks.
Mike
Option Compare Database
Option Explicit
Private Sub Clear_Click()
DoCmd.Close
DoCmd.OpenForm ...
|
1 |
3/7/2006 6:48:19 PM |
|
|
quiting from application
how can i force use quiting from application only by cliking a close butten
and not on the windows X butten?
thanks
...
|
3 |
3/7/2006 3:25:49 PM |
|
|
compressing db
how can i control by code if application quit will be with compressing the
current db or whith out compressing ?
thanks
...
|
2 |
3/6/2006 11:48:17 AM |
|
|
How to check if a file exists?
Hello, (I apologize if this appears twice ... I had a problem when
sending...)
In a VBA module, how can I tell if a file exists before doing the
TransferSpreadsheet? What I would like is something like this:
filename = <calculated from some values on the form>
if filename exists then
ask for alternate file name
endif
Thank you,
...
|
3 |
3/6/2006 11:40:34 AM |
|
|
Catching Events
I have packaged up a part of my program and placed it into a separate mdb file.
I then referenced it into my main program.
I am able to transfer data from the main program into the packaged up
program by linking it's tables into the main program and using an append
query.
I am also able to open and use the forms in the packaged up program, via a
public sub that resides in the packag...
|
1 |
3/5/2006 11:36:27 PM |
|
|
Changing "Me.[fieldname]" to work from a Module
I am new to writing Modules.
I have a Form containing a Chart. There are a series of listboxes on the
form that changes values and such on the chart as different selections are
made. I have the same 20+ lines of VBA code attached to the AfterUpdate()
event of the listboxes. I want to move this code to a Module so when I make
changes or add listboxes I do not have to change ever incident o...
|
3 |
3/5/2006 3:18:37 PM |
|
|
Database Schema scripting
At http://www.trigeminal.com/code/basScriptJetSecurity.bas Michael Kaplan
offers a module to script out security permissions in a database. Does
anyone know of a similar script for saving/restoring a database schema?
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Microsoft Access Developer since 1994
Vancouver, BC
...
|
8 |
3/5/2006 1:51:54 PM |
|
|
combo box
Hi,
I have two combo box on a form and I was trying to use the top combo box to
determine the content of the 2nd combo box. i.e if the top combo box content
is Car and Truck. If the user select Car, then the content of the second
combo box will be list of Cars type in table and if the user selects Truck
the content of the second combo box will be Truck in table.
My question is if I...
|
2 |
3/4/2006 12:34:44 PM |
|
|
ComboBox Question...
Hi,
I have two combo box on a form and I was trying to use the top combo box to
determine the content of the 2nd combo box. i.e if the top combo box content
is Car and Truck. If the user select Car, then the content of the second
combo box will be list of Cars type in table and if the
user selects Truck the content of the second combo box will be Truck in
table.
But the problem is...
|
3 |
3/3/2006 12:24:35 PM |
|
|
Dynamic picture loading to report
Hello codders,
i need to load any type of picture (but not bitmap only!!!) to a report.
I made this work in forms by using .picture property on a picture object.
Using the code at report causes an object doesn't support this property or
method.
Any help?
Thanks a lot,
(buddy*)__lukas__
...
|
8 |
3/2/2006 6:06:56 PM |
|
|
mde grows on close
This is a multi-part message in MIME format.
------=_NextPart_000_0024_01C63CA3.6F0B86C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Anyone have any idea why my .mde file grows on close?
I've read all about database bloat and fixed many issues by closing all =
recordsets, querysets, and current databases, also setting everything to =
nu...
|
3 |
3/2/2006 12:30:13 PM |
|
|
French language currency routine required / date routine offered
In the VBA Developer's Handbook, Getz and Gilbert offer the routine
dhNumToStr. It takes a number and converts it into text for writing checks.
For example, 24.95 gets converted to Twenty-Four and 95/100.
I need an equivalent routine in French. Has anyone attempted this?
I offer my own routine for converting a date into French text. Please let me
know if there is a system function to a...
|
11 |
3/1/2006 6:57:14 PM |
|
|
Email Sending Message "From" Account
I would like to specifically send a message from a Group account, of which a
logged-in user can have the message sent from the Group MS Exchange account,
as opposed to their actual Windows Log in account.
What special coding is required for this ?
Many thanks !...
|
2 |
2/28/2006 2:23:06 PM |
|
|
Generating passwords automatically
I've created a Password function that creates a random password
Function Password(passlength) As String
Dim i As Integer, tmp As String, tmpChar As String, arrChars(61) As
String, j As Integer
For i = 0 To 9
arrChars(j) = i
j = j + 1
Next
For i = 65 To 90
arrChars(j) = Chr(i)
j = j + 1
Next
For i = 97 To 122
arrChars(j...
|
4 |
2/26/2006 10:23:20 PM |
|
|
Are DLLs the way to go
I write a lot of utility programs and database front ends using Access
2000-2003. Most of my functions are in the modules and I use a lot of the
same functions in most of my projects. Lately I have been finding that I am
not updating all of the common functions in all of the projects and they are
falling out of sync (what a suprize!)
I have never created a DLL but I was wondering if t...
|
7 |
2/26/2006 2:21:15 AM |
|
|
ImageClass HelpMe
Compliments for the good gym of study to S. Lebans but my lower part level
of knowledge of the VBA has been put k.o..
1. How can I do to PCX to load images?
2. As I can do to the image to make Negative
3. How can I do to cut out the image for then to resize it, in dynamic way
in another control Image?
example: to cut out a portion of the image, to make to become her/it a new
image to unhide...
|
2 |
2/25/2006 2:35:26 PM |
|
|
Combo Box?
Hi,
I have two combo box on a form and I was wondering if there is a way for me
to use the top combo box to determine the content of the 2nd combo box. i.e
if the top combo box content is TVand Radio. If the user select TV, then
the content of the second combo box will be list of TV stations and if the
user selects Radio the content of the second combo box will be Radio
stations.
...
|
3 |
2/25/2006 3:46:55 AM |
|
|
How to avoid : error 3052 file sharing lock count exceeded
Rather than keep increasing the registry value as my clients grow and grown
their databases, I'd like to change my code to repair this problem.
We are using Access 2003 on a Windows XP system using a Windows 2003 server.
For some reason recset.lockedits tend to suggest that we are using
pessimistic locking (which in itself seems odd to me). Now with pessimistic
locking I'd expect each r...
|
1 |
2/24/2006 4:21:19 PM |
|
|
Help with this code
Dim oApp As outlook.Application
Dim oMsg As outlook.MailItem
Set oApp = New outlook.MailItem
Set oMsg = CreateItem(oMailItem)
With oMsg
.To = "ssamnang@yahoo.com"
.Subject = "cmd Buttom Testing..."
.Body = "Hey delete me now"
.Send
End With
at the very first line, I got the following error:
Compile Error:
User-Defined type not defined
SF
...
|
4 |
2/23/2006 3:29:51 PM |
|
|
I need your feedback
My boss may have me implement the following subprocedure to automate the
correction of the ItemID of the records...
If you understand how to read my code, will you give your input if you think
it's the best way to do it or not?
Sub ChangeID()
Dim db As Database
Dim rsI As Recordset, rsSI As Recordset, rsSSI As Recordset 'The three
tables
Dim ITEM_ID_txt As String 'The ...
|
3 |
2/21/2006 8:14:30 PM |
|
|
Access Email through Outlook.
Hi,
I embed the code below in my button click, so that when the button is click
an email will be send but....How do I get rid of the pop up message from
outlook "Microsoft Office Outlook: A Program is trying to automatically send
e-mail on your behalf. Do you want to allow this? If this is unexpected, it
may be a virus and you should chose 'No'".
Dim olApp As Outlook.Application
Di...
|
3 |
2/20/2006 3:23:55 PM |
|
|
Adding a column to a table using a VBA function
Hi
I have an access Db where I need to create an extra column in a table the
default value would be the current date I need to create this in a vba
function.
Any help greatly appreciated
Subs
...
|
14 |
2/17/2006 5:05:42 AM |
|
|
textbox to field?
Hi,
I have 2 unbound textboxes, that I want the user to input text, and I want
this text in a field in the table, so that every time they input some text
it comes into the same field in table it will just keep overwrite the old
text in the field of the table every time they input text.
How do I do this...
Thanks
Tiger
...
|
4 |
2/16/2006 4:33:55 PM |
|
|
accessing controls by tab index
Hi, I was wondering if anyone could let me know if it is possible to access a
control by its tab index? Reason why, is that in a user form, if a certain
entry is made, the next 'n' controls need to be disabled... best way to do
this, appears to be by using the tab index.
Any help will be greatly appreciated, thanks:)...
|
4 |
2/16/2006 3:27:04 PM |
|
|
acc 2003 2 form instances
trying to generate 2 active instances of same form at run time with:
'Module Declarations section:
Public FM1() As New Form_fmCompany
'Module Code section:
Sub OpenFM1(Comp_ID As Long)
ReDim FM1(0)
FM1(0).RecordSource = "SELECT ......"
FM1(0).Visible = True
FM1(0).Tag = "FM1" 'this tells running code that the instance being
tested is this one
End Sub
Problem is:
All...
|
5 |
2/15/2006 5:28:26 PM |