sql query problem
Fri, 9 Nov 2007 17:17:01 -0800
hi im trying to perform a query using the recordset property
here is my sql string
stSql = "SELECT * FROM [tasks_done] WHERE [tname]='PPM Projector #" & projno
& "'" & " AND [tdate]=" & Date
problem is with the string the way it is it wont return any results despite
having matching results in the table, ...
|
Read an Outlook Inbox from an Access db
Wed, 7 Nov 2007 03:32:00 -0800
I am running an Access 2002 db and Outlook 2003. I have a special email
account setup in Outlook for a specific purpose.
I want to open the inbox for the account from within Access, store the
Sender and Date&Time data for each entry in a table and then delete the
record from the Inbox.
Does anyone have a ...
|
Reposted - List Box
Mon, 5 Nov 2007 17:37:35 -0000
Marsh
I have removed the original code etc so I now have an frmrefurb and
frmrefurbsubform. Here are the details of the combo boxes - Thank you for
you help!
The subform is where I have the combo boxes in datasheet view I have
referbdetailID Supplier Name: ProductID and Product Description Name:
In dei ...
|
Database Startup Problem
Mon, 5 Nov 2007 11:42:59 -0500
Has anyone came across this type of error when trying to open up their
MSAccess Database.
" The Microsoft Jet Database Engine could not find the object "Databases' "
I've a very important presentation this morning and now don't know how to
correct this problem.
Please Help
...
|
List Boxes
Sun, 4 Nov 2007 15:58:06 -0000
Sorry I ment Combo boxes and NOT List Boxes in my previous post!
...
|
List Box
Sun, 4 Nov 2007 15:54:51 -0000
I have a frmreferb form and frmrefurbsub form.
the sub form and the following field Supplier - Product - Product Desc -
Serial Number
I want to be able to click on the Supplier List Box and the click on the
product list box but I only want products to display which are available
from the supplier I have ...
|
digitally signed...expense involved
Sat, 3 Nov 2007 14:57:28 -0700
need response....BUT, BRIEF
...
|
|
|
recordsource property
Fri, 2 Nov 2007 16:56:54 -0800
I am struggling with something that I thought would be pretty simple. I am
trying to retrieve the recordsource of a report without the report being
open. It seems that Reports only works with reports that are open.
Allreports works with everything but doesn't give me a way to recordsource.
any help appreciat ...
|
Error on scrolling through records with images displayed
Thu, 1 Nov 2007 22:31:00 -0700
Hello,
New here, but been programming in Access and VB/VBA for yonks.
I have recently put in an image object in my Form using the code snippet
from here
http://support.microsoft.com/default.aspx?scid=kb;ben-us;b285820
In particular the Function DisplayImage - which sets the .Picture property
of an Im ...
|
OpenForm with 2 link criteria?
Thu, 1 Nov 2007 15:58:33 +1100
Hi,
I have a command button on a subform which pops another form but I'm having
trouble getting the link criteria to work.
The main form is frm_DockSheetEntry, the subform is
frm_DockSheetEntrySubform.
I need the popped form (frm_Comments) to display the record from
frm_DockSheetEntrySubform where
[R ...
|
