I have been trying for 2-3 weeks (with posts to forms and reports groups) to
print the results of filter by form. Nothing works as replied, something is
always wrong.
So, since I know my Me.recordset  (Me=a form) is correct by looking in

See the commented line...just can't get to this recordset!
Dim db As DAO.Database
Dim rs As DAO.Recordset
'Set rs = Me![report_tab].[Invoices_tbl_subform].Form.RecordSource ' Ive tried thhis line w/o the [report_tab] does not work...same for line below...

This is an Access 2003 question relating to a Main Form that has a Sub Form
(which contains all of the data entry information)
On the sub form I have a field I want to reset to zero at the start of each
month for all of the records. This is the only field that changes each month

I have a back end file that wont let me open it - even with shift
all it says is
the microsoft jet database engine stopped the process because you and
another user are atempting to change the same data at the same time.

i have a small query with 1 column of data of varying length
i want to conver them to a single row , comma delimited
is there a function that i can use to convert the items from 1 column to 1
row?

Looking for a VB funtion to determine if a select query returns any records
or is null.

Help Please!  I'm running Access Ver 11
I know that to find the current user, I could use the function CurrentUser.  
Now, how do I find the current form?
Thanks in advance.

I presently have the following code that registers when
its not at the EOF, but doesn't work when at the last
record.
Here is the code:

I am making Reports in ACCESS 2000
I wanted to use bold and non-bold text (plain) text in a single Textbox as
the records are taken frm Database and using another textbox or label is not
given data in sequence .........

I am fairly new at writing in VBA.  I've picked up a lot of the basics
(docmd.[cmd], recordsets, synchronizing forms, etc)  Anyways, sometimes when
I am adding or editing code on some forms or modules, the text I type
automactically turns red like there's an error in the code (and I ...

I'm constructing an Access 2000 database, which calls a VB sub routine, when
a command button is clicked, to open a form, which then calls a converted
Macro function routine to set several field values from the original form.
The function routine does set the specified field ...

Using a make table query receive the message about deleting the table and
also about null field violations.  Would like these to automatically say yes
so that the user does not have to answer them.
Many thanks

Sorry to cross post, but getting no replies on the other Access NG
I have a report the size is A5 landscape. I need to get the page dimensions
using VBA.
If I open the report in PrintPreview I get

Hope someone can point me in the right direction.  I have a barcode scanner
that uses a dll.  In VS, I was able to write a VB program that reads the
scanner.  What I would like to do is use it from Access.  I copied the
function declarations to a module in Access, but it doesn't ...

I have a table (tblControlATB) with three data elements: ID, Type,
Description. On a form (tblATBDelete), I have a ListBox which displays these
same data elements and is populated from data pulled from this table. I want
to be able to select one of the line-items in the ListBox, ...