I'm new to Access and Visual Basic.  I've built the tables, queries, forms
and reports and I'm ready to write my first code (module?).  I know I'm
basically asking someone else to write my code BUT... if anybody will "hold
my hand" here... I learn very quickly by example.

Hello, I need help in resolving my dilemma,
In the query design I have to fields [OpenDate] and [CloseDate], and the
third field I have a formula "Length of Days:([CloseDate]-[OpenDate]+1)" and
I'm getting results, but I also need to do a grouping of " 0 - 30", " 31 -

How can I modify this function so that it will show what the record is?
Function scan_sku() As String
Dim rs As DAO.Recordset
Dim strSQL

I would like to bring in various file types, txt and xls, into Access
automatically on a specified timeframe for each.  The problem is that the
filenames generated from the application we use to gather the data defaults
the date and time as an extension to the filename (ie.

I'm trying to create the following summary for each day of the week and for
each category but I'm not sure where to begin... should I use a query or
create a report and how would i get the information to populate for a weeks
date range..

I have two tables, table1 and table2.
table1 contains a list of names and numbers, in two fields.
table2 contains details jobs against names and numbers, the names and number
fields will be linked to the corresponding fields in table1. I want to link

Hello, I have a query that gives me the sum for a few fields. Some of the
fields will return a zero. How do I not show the fields containing a zero in
my query results? Would i use the critera section and if so what would I
enter there?

I am looking to make a database to help me manage 20 managers that report to
me.  I want something where I can click on a location and it will allow me to
type notes about my location visits with them.  I woudl also like the ability
to print the data by location.  I have only ...

anybody ever do any work with OMR readers?
i could use a few lines of code.
MSComm reads the cards fine, but i don't know how to parse the input.
the couple of examples that come with the reader don't help...

I searched validate email and come up with this:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))
I don't want to put in table validate because my daily macro to import from
text file may fail (it may contain single period as email). I want to put

I hope this is the right group. I have a VB program that opens an Access
database and was wondering if I open it in Exclusive mode will any other
users that try to open it get an error code? If so does anyone know what the
error number would be or should I just trap all errors.

I want to have my own format for customer and project numbers, how do I do it?

I’m trying to create a data base for ordering employee uniforms at my place
of employment.
So far I’ve created the following tables, Employee, department, Gender,
Article, supplier.

In a database to keep track of online purchases, I will have a Vendors
table. One of the fields will contain the URL for the vendor's website
(eg, www.amazon.com). Should I make this a text field or something
else?

I am hopping someone can help me....
I am looking for a code or how to code
What I have is the following tables
products