|
problem after load images in database..
hi...i got a problem..when i hv load all the file..i want to sort the
file refer to
the name file..like a103.bmp,a104.bmp,a105.bmp..bcoz when i sort it..it
being like this..a103.bmp,a1031.bmp,a104.bmp,a1041.bmp...can u help
me??is there any coding in vba which can solve this problem??? plz i
really need a help...tq..
...
|
4 |
25.08.2006 10:34:50 |
|
|
Making Event Procedures available to any Event in Access
Hi,
I have a number of procedures that are called by various form field events
but it would be very handy to have certain procedures available within a
complete form or from within multiple forms within a database.
Thanks for any help you can offer.
Andy :)
...
|
5 |
25.08.2006 08:48:01 |
|
|
Are option groups really, really dumb in VBA?
I am getting "Run-time error '2427': You entered an expression that has no
value" when I refer to an option button's value:
If Me.optFindAll.Value = vbTrue Then ...
However, I had set this option button as the default when I created the
option group. Do I still have to explicitely assign a default value to it in
code, before I can use it?
Also, what is there to gain by assigning...
|
12 |
25.08.2006 07:34:07 |
|
|
ldb
I have a database that runs on a server. The ldb file remains open even when
everyone is logged out. Can someone explain?...
|
3 |
24.08.2006 21:28:07 |
|
|
Many-to-many-to-many
I am developing an application for an environmental group that has forms for
people info, event info and sponsor info, each with subforms for the other
two types of data. The people form has a many-to-many subform relationship
with events and with sponsors. The Events form has a many-to-many subform
relationship with people and with sponsors. The Sponsors form has a
many-to-many subform...
|
4 |
24.08.2006 20:01:28 |
|
|
Faster retrieval of data
Which is faster - Domain Aggregates (e.g.DLookup or DCount) or DAO.Recordsets
with SQL ?
If both have pros and cons, what should I keep in mind when I've to decide
which to use where ?
Thanks for any tips.
--
Sreedhar...
|
8 |
24.08.2006 19:52:34 |
|
|
Access as a performance typer
Is there a faster method than "docWord.Range(docRange.Start).InsertAfter" to
place text into word? Bookmarks are out of the question since i do not know
the lenght of the document and i am formatting and adding tables on the fly.
thank you
_________________________________________________________
I know you guys like code:
Public Sub wordMapping(ByVal tmpPath As String)
Dim appWo...
|
2 |
24.08.2006 19:49:44 |
|
|
Search VBA Code
Hi. I'm using an VBA code I've found on internet about looking for a
recordset. I decided to add it to the Search form I've created. The code I've
found it in this link:
http://www.functionx.com/vbaccess/howtoado/locaterecord.htm
The function of this code was when the user enters the ID in the textbox,
then when he/she clicks the Enter or Tab button, the information appears like
title,...
|
8 |
24.08.2006 19:49:29 |
|
|
Store SQL result into a Var or Array?
I am trying to capture the results of a query & store thosee results into a
variable or array.
Example: If the results of a query return 5, 7, & 8, I would like to store
these results into an array, for use in my code.
Any help?
Thanks
...
|
6 |
24.08.2006 19:37:27 |
|
|
Create a html-form in word wich returns data by email
Hello!
I have a question for U all.
I want to create a html-email in word that contains a form that the
email-receiver fills out and clicks a Submit button - wich returns four
fields that he/she has filled out in the form.
The data shall be sent to a webservice that has a method that inserts the
data into a MS SQL database.
Is there anyone out there that can help me with this problem...
|
1 |
24.08.2006 14:51:02 |
|
|
environment variables
Good day All,
Does anyone know where I can get the full list of environment variable (args
for environ()) - (Doug, the API is good, but I need the environ$ list.)
thank you...
|
8 |
24.08.2006 14:33:07 |
|
|
Character limit
I have a string, which is long. It is an update statement. When I display
the results in the message box, my statement is cut off at the end. What I
did was put the where part in a different string variable and concatenate the
two strings, but that did work. Does anyone have any ideas?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/...
|
5 |
24.08.2006 14:20:03 |
|
|
Single and Double Quotes
Hello All,
I am new to vba am and encountering some issues when attempting to run a sql
statement. I am having issues with Single Quotes and Double quotes causing
errors. If the values contain any single or double quotes I get an error.
See code below.
strSQL = "insert into newDB values ('" _
& rs.Fields(0).Value & "', '" &
rs.Fiel...
|
7 |
24.08.2006 13:47:01 |
|
|
help with access page
I have an Access (2002 edition) page that has one of the fields contain a
hyperlink to PDF files. If I click on the link directly from the table it
works however, if I click on the link from the page it does not. how can I
make it work?
Al...
|
1 |
24.08.2006 13:22:02 |
|
|
help with HTML
I would like to transfer a query as HTML by providing the user a command
button on a menu, I need to do the transfer with on click. Can some one help.
thanks
...
|
3 |
24.08.2006 13:20:02 |
|
|
Customer Relationship Management (CRM) Tutorial (August 2006)
Customer Relationship Management (CRM) Tutorial (August 2006)
CRM Basics,CRM Objectives,Types of CRM :: Operational CRM , Analytical
CRM ,Collaborative CRM, CRM Implementation ,CRM Technical
Functionalities ,Popular CRM's :: SugarCRM ,vTiger CRM , Daffodil CRM
,Future of CRM
http://flying-rugs.com/crm/CRM.html
...
|
1 |
24.08.2006 12:42:58 |
|
|
Customer Relationship Management (CRM) Tutorial (August 2006)
Customer Relationship Management (CRM) Tutorial (August 2006)
CRM Basics,CRM Objectives,Types of CRM :: Operational CRM , Analytical
CRM ,Collaborative CRM, CRM Implementation ,CRM Technical
Functionalities ,Popular CRM's :: SugarCRM ,vTiger CRM , Daffodil CRM
,Future of CRM
http://flying-rugs.com/crm/CRM.html
...
|
1 |
24.08.2006 12:42:48 |
|
|
Updating Office 2003 with SP2...can lead to error if don't?
Hello,
is there any chance that a Database coded on a pc with Office 2003, Visual
Studio 2003 and all the latest updates installed can run fine and the same
database when run on a pc that has office 2003 installed, but not updated,
gets error?
We are facing a very strange behaviour...
If I deploy the db with the package wizard AND the runtime version of
Access, it works fine. But if I ...
|
3 |
24.08.2006 11:43:02 |
|
|
using Date to filter reports
Well I thought this was going to be easy but....
I want to print out a report for contact birthdays. I have the date in date
fields and put
Me.Filter = "birthDate = " & START_DATE
Me.FilterOn = True
in the open event for the report. I did this for the initial test , thinking
once I had this working I would worry about only looking at the 'month' part
of the dates which I am not...
|
3 |
24.08.2006 10:58:01 |
|
|
problem when load image files to database..
i got a problem with database..when i trying to link the images from
1folder to database using vba coding i've got error 438"object doesnt
support this property or method"....this the code:
Option Compare Database
Option Explicit
Private Sub Command12_Click()
On Error GoTo Err_Command12_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , ac...
|
6 |
24.08.2006 08:56:54 |
|
|
Using Call Shell to open Excel Workbook within Access 2003, SP2 Ve
In a Sub procedure, I am updating a spreadsheet from queries within Access.
Then I use the 'Call Shell' in Access to open the spreadsheet for viewing.
When opening the spreadhseet, I get a warning message "File???.xls is
already open. Reopening will cause any changes you made to be discarded. Do
you want to reopen File???.xls Yes/No." Is there a way to
prevent this m...
|
2 |
24.08.2006 06:04:25 |
|
|
Calendar versions different
I made a form with the calendar version 8 from the system32 folder. On my
laptop, it has the calendar control 9, from the microsoft office folder.
When I try and run the form on the laptop, the calendar kinda works, but the
numbers don't show up. Do I have to register the calender .ocx, version 8
onto my laptop? And if I do, will the laptop even know to overide that .ocx
over the .oc...
|
3 |
24.08.2006 05:01:11 |
|
|
How do I setup reminder time of Outlook from Acces?
I have a problem++> how do i setup reminder (to my contacts) time of Outlook
? The source reminder time is made from Acces! I want to export this time to
Outlook, so automatically after I export the time, Outlook will set
(automatic) reminder to my contacts! Thank for your help, tahnk for you all! ...
|
1 |
24.08.2006 02:25:01 |
|
|
Having trouble with OLE - Help please 3rd time asking - No respons
I have a note table that I want users to be able to attach or link to a
number of different objects (1 object per Record). Meaning they may need to
attach a video or a graphic or a document to the note. I set up the field as
an OLE Object (Imbedded, which I need to change.) within my table.
When I am at my home I right click and browse to the object and it inserts
it as a package. I...
|
8 |
24.08.2006 02:18:01 |
|
|
how do I debug access script?
I have a database that someone else created for me and then went on
vacation...When I attempt to upload data from a selected file, i get runtime
error 2391 Field F2 does not exist in destination table. When i pull the
table and do a find, there are no results......
|
4 |
24.08.2006 02:12:01 |