From 2003 to2007
Tue, 16 Dec 2008 13:55:53 +0100
Hi,
I converted my code from my previous 2003 version to the new access2007
version.
I get following error:
(I have to translate so could be a bit different)
error 13 during executing:
Types are not matching
The code:
Dim db As Database
Dim tb As Recordset
Dim kl As String, afd As ...
|
Auto name input
Tue, 16 Dec 2008 04:25:01 -0800
I would like to add a field in my form that will display a list of the user's
as the letters of the last name are typed i.e. auto find.
Is this feature available in access or must it be coded?
thx in advance for the feedback. ...
|
Conditional Formating or Continuous Form Record Formatting
Tue, 16 Dec 2008 03:10:06 -0800
Hi
I have another question.
I have a continuous form that I need to highlight certain records based on 2
or 3 criteria. If the criteria is met then all fields within the record (or
even the back colour of that record) must be changed to red.
I have the following fields on the form
fldStartBy
fldDea ...
|
Who is logged in the duration of current connection
Tue, 16 Dec 2008 03:06:05 -0800
Hi All
I have an Access FE installed on users pc's (about 100). The BE is a SQL
Express db.
I need to find out who is connected to the SQL Server - what date/time they
connected and what date/time their session ended.
I have read a number of posts on getting a list of current users but is it
possib ...
|
Brizar Exporting to Excel
Tue, 16 Dec 2008 02:50:54 -0800 (PST)
Hello,
I'm rather confused to why when i use the in built "Analyze it with
Microsoft Office Excel" Feature from MS Access and use a filtered
table results or unfiltered table.
when the records have been exported to excel and excel opens straight
away, all information is their apart from one field "Notes" Ac ...
|
how to off cursor
Tue, 16 Dec 2008 01:16:10 -0800
dear friend,
any body can help...
i would to off scroll thru cursor data in the form. what heppen now, data in
form can scroll bar from cursor. ...
|
Form_Activate not being triggered
Mon, 15 Dec 2008 23:30:22 -0800 (PST)
I have a Main form with a subform containing related records I have a
double click event in the subform to open another form to view the
records in their own form. The problem is the Form_Activate procedure
on the form that open is not running. I am opening the new form via a
DoCmd.Open form.
Could someone ex ...
|
|
|
Need Money????
Tue, 16 Dec 2008 00:01:30 -0500
Need Money, visit http://dinero4ever.blogspot.com
Now!!!! ...
|
Need Money????
Mon, 15 Dec 2008 23:59:00 -0500
Need Money, visit http://dinero4ever.blogspot.com
Now!!!! ...
|
printing records to Excel worksheets
Mon, 15 Dec 2008 17:13:26 -0800 (PST)
I am trying to open an excel file and insert the data from a Table or
Query into a sheet and print.
I actually need to loop thru all the filtered records and do this
task.
Currently I am using this code to open the excel file and place the
data into Cell B2 then print. This part works but I need to integrate ...
|
