Access 2000 to 2003, get error 43831554 (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 access21223 (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 Case141375 (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.mdb41554 (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 Select31113 (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"51522 (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 - 9856101267 (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}"11920 (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 200762570 (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 strings11042 (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 Reports01262 (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 message21148 (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 spans11170 (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...
"%" character1989 (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 issue31155 (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 Loop21149 (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 Variable12132 (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 variable11349 (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 parameters11616 (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 selec21137 (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...