Hi everyone, I am trying to create a record set using VB within Access (code below). I get an error at the first Execute Line. I'm sure I will get an error...

I have set up a CrossTab Q that the user can only pull one weeks of data Sunday - Saturday. At this time the CrossTab comes back with the Dates. I would like...

OK, i'm going to try to describe what I'm doing as best I can. I have a table called tblCourseReg with the fields lngRegNo, lngCourseNo and lngStudentNo....

Folks: I am hoping there's a pivot table wiz out there who happens to know the magic for this! Situation: Underlying query has a couple of tables joined, and...

I have 45 queries (that perform calculations from info in various but very similar tables) that I am going to query to SUM it all together. However, as you...

Any suggestions on query / interface design for a multiple variable where clause query. That is SELECT * FROM CUSTOMER WHERE SERVICE_PROVIDED = "a number of...

I have created a database to help with the scheduling staff members. It is possible for staff members to be listed in up to 18 different fields. What I want...

My tool button that has File Tools Insert, etc. is gone and i can't get it back.

I have a table with a list of states and which user is currently responsible for them. I am trying to get the Users across the top and the States listed below...

I have a table of data that has a StartDate. I am trying to assign a Number that represents the Fiscal Period the startDate Falls into. I have another table...

test

Can anyone tell my why only some of my queries are present when I select the datasource from Word 2003? All my tables are indicated and only about half my...

Twice today I have run some SQL and it has created a cursor and not created a table. I can not paste the SQL here because it is large and on...

HELP!!! I have an existing Access document that I work with on a daily basis. Somehow, I've managed to modify it and am not able to print detail reports. The...

Waht kind of query must i write to this have?? P_ID P_NOME P_ COGNOME 1 ingrid esposito 2 pippo ...

I've created an Outlook email template designed to automatically be sent by Access, with the requirement that the contents of the email msg populates a master...

we need a new operating system, XP's old news!!

Can anyone explain how I should use a max function to calculate the most recent Date from 6 date fields in a query. In excel I simply have the date fields in...

I have a table with five fields, Mon, Tue, Wed, Thu and Fri. Each record for each field is either a "Yes" or "No" ie Mon Tue Wed Thu Fri Yes ...

i have around 20 tables containing similar data. i need to create a querie that will allow me to compile all of this data together in one table. any ideas?