Access 2000 to 2003, get error 43831573 (6/3/2010 3:59:01 AM) UtfHello,
We have a Access 2000 program which is running fine on old PC. After we
changed to new PC(Win7 with Office 2003), we can't get it work correctly
anyway. When running the fuction, we always got "...
Updating .nsf lotus notes server file - from access21236 (6/4/2010 8:22:33 AM) UtfHi,
Using the below code i can fetch data from the .nsf file kept in the server.
Dim LotusWizard As DAO.Recordset
Dim session As Object
Dim notesdb As Object
Dim notesView As Object
...
Checking for Null & Select Case141395 (6/4/2010 8:54:19 PM) lmccI have a form called fSearchforCompany with two unbound fields. After
selecting a field from lstQuickSearch (list box) and tabbing to txtSearchBox
to enter data, the correct form should open with the text fr...
Allen Browne's Calendar97.mdb41573 (6/5/2010 12:57:20 PM) MarkThis may be asking too much, but does anyone know how to use the calendar
(frmCalendar) from Allen Browne's Calendar97.mdb as a subform on a main
form, rather than as a modal popup?
I would like to use the...
If this correct use of Select31131 (6/5/2010 2:29:32 AM) UtfHi there
I want to use the following statement in the RowSource for a report but am
unsure of whether it's correct:
SELECT *, *
FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] =...
"item not found in this collection"51533 (6/4/2010 3:35:55 PM) UtfI try to send mass emails in my VBA codes, but I got the above error message.
Can you help me to debug it. Here are the codes.
Dim email1 As String
email1 = "a@hotmail.com" + ";" + "b@yahoo.com" + ";" + "c@...
Conditional updating - 9856101279 (6/6/2010 1:21:35 PM) samotekI have the following working updating function which is ok:
CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72"
I want to add on a condition depending on the field “code” in the same...
Sendkeys "{ESC}"11929 (6/6/2010 10:12:36 AM) UtfHi
untill now I used the Sendkeys "{ESC}"/Cancel in the event BeforeUpdate, but
occassionaly I had some problems. From now on I follow the instructions of
some users in the duscussion Groep and I replaced ...
VBA Reference Libraries-Access 2003 vs 200762587 (6/4/2010 2:00:19 PM) UtfI'm in the process of converting from Access 2003 to Access 2007. When I
converted my 2003 db to 2007 the VBA code would not run. I changed the
Reference libraries in 2007 to match what I had in 2003 and th...
Select Case question - Comparing strings11054 (6/5/2010 8:11:36 PM) JDBI am passing variables into a subroutine, and comparing these to some
parameters in a array. If all 4 of the variables passed in are equal to 4
values in the array, I run a a loop adding values to the array....
OLE, INK and Reports01280 (6/5/2010 9:19:35 PM) UtfHello everyone, here is my problem.
In my app I have 7 spots where a signature can be required. They are all
OLE controls that when they get the focus they are scaled in size, 4 x, when
you double click...
run query message21157 (6/4/2010 8:26:06 PM) UtfEvery time a SQL statement is ran the "run query" message is display in the
status bar, is there a way to prevent this so a useful message could be
displayed?
Thanks
Jim
...
quantifying overlapping time spans11192 (6/4/2010 11:46:56 PM) EHobsHi all,
I am trying to write a query to calculate the amount of time that any two
individuals overlap in their use of a location. My table currently looks like
this:
Date Time IndividualID Arrival...
"%" character11013 (6/4/2010 11:42:21 PM) UtfI am using the following code:
Val(strValue)
where strValue = "0.1%"
I am getting a type mismatch error.. what does the "%" character do to a
string?
...
Calendar control conversion issue31167 (6/4/2010 9:29:12 PM) MarkHi all,
I still do most of my development at home using Access97. At work, I convert
the FE to the default 2000 format on a computer running Access 2002(or maybe
it's 2003, I'm not sure which). I can then ...
Why does code Loop21164 (5/25/2010 10:00:01 PM) UtfWhen I click on a command button to show a report I have a break point on the
command_click. Upon clicking the command button it opens a report.
DoCmd.OpenReport stDocName, acPreview
As I step thro...
Form Name as Variable12154 (6/4/2010 9:36:02 PM) UtfHi,
I have the following subroutine:
Public Sub SetMeterBasic(p As Single)
' This subprocedure is used to update the progress meter bar
With Forms![FormA]
.shpMeterBar.Width = p * .lblMeter.Width
...
Public variable11359 (6/4/2010 4:28:19 PM) UtfI am calling a public sub from a form, and I am trying to get the sub to be
able to access a variable from the form. I declared the variable as public
in the forms code, but it isn't available to the subro...
create a form that collects parameters11634 (6/4/2010 11:35:14 AM) UtfHi,
i need a form where we search for a detail and the result should be
published in the bottom, based on the result the user will decide what to do
next in acess 2007.
i refered the link below
http://...
populate a text box with multiple records based on combo box selec21167 (6/4/2010 4:20:54 AM) UtfHi,
I have made one form with a combo box (dropped down) , a search button and a
Text box. when a user selects a value (ie. Project No.) and click on search
button the text box should display all the rec...