Save precious time and dollars in learning the secrets of programming.
Complex logics made simple and easy to learn.
Own a complete Database Application built using OOPs, Classes,
Datagrids, ADO (ADO .Net) with options like Sale, Purchase, Receipt,

I don't mean lines of code in a given Sub or Function, but the overall size
of code modules.
I wouldn't expect it to matter much if at all, but I recently moved a good
bit of code out of one large module (80 subs or functions) and put it into

I am running into a really odd problem with Access and looking for some
insight as to what could be causing my issue.  Basically this SQL
creates a listing of Total Sales (Sum(InvLine.Retail)) by Category
(InvLine.Cat) which seems strait forward.  But today I run the report

taking the following data:
a     w
a     n
b     r

Been given a rush query to do in an access database, am quite rusty.
Here is what I need:
TABLE1
EMPLID, YEAR

We have a product that is being used by a client to outsource salary
packaging. They therefore run several instances of our database, one for
each of their clients.
There is now a requirement to run operations globally across all the

I am using MS Access 2000.
I am trying to create an Access report that lists and subtotals all the
people that have entered our department and lists and subtotals all the
people that have left our department for a given date range.

Does ms access support sequences?
If not, how can i create auto increment column type from the end user
application  ?
<Im using Visual Studio 2003>

Some sites I've rolled out mde's to allow user to press
F-11 & bring up database window. Others do not. Anybody
know what setting controls this? Strange is that the app
is the same in each location - compiled to mde using same

Is there a way to set a primary index to ignore Nulls and if so how
would I do it.  I have already tried setting it so it is not a required
field, but that does not work.  It states that the field can not
contain null values.

I wonder why when I do a filter by form, some text fields show all the
data in the table in the combo box and others only show two items, Is
Null and Not Is Null. I want to show all data, instead of just null or
not null. I created the text fields the same way. But I don't know if I

I have a rather simple database that I've designed a switchboard that
runs several macros for producing a report that is based on a select
query. I need to design an input control that assigns a value to a
criteria on which the query/report is based.

I've got an MDB (Access 2000 format, using Access 2003 to create and
run) that's just enormous, even though there are"
  0 tables,
  3 pass-through queries

I'm developing an application for use within my company in Access 2003.
I'm new to '03, the application I did for my former employer was in
'97.  The two applications have similar functionality (we're sales
offices, and I'm doing things such as associate directories, commission

I've recently completed a database that tracks my food purchases and
inventory and I want to add another piece to the database that tracks
sales. Our company's waitstaff enters order information into Positouch
terminals; I have a Positouch "server" which generates management