Search results

Cannot find File error Thanks to all of you. You have been a GREAT help. Dawn

I have split my db into a front end and back end and when I make a copy of both DB's onto a CD and try opening the DB from the CD, I get the following error: Could not find file C:\Documents and Settings...mdb It is looking for the back end db in the original location. I've copied both the...

HURRAY! It works wonderfully. Joins and all. Problem fixed and I learned along the way. Thank you so much Bob. Dawn.

Uh oh I spoke too soon. Yes I get all records...ALL the time though. Even if I enter a specific date, I will get all records. Here's my code: PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime; SELECT tblSale.SaleID, tblSale.InvoiceNumber, tblSale.SaleDate...

Hold it Hold the presses! I just realized that I changed all the tables in Northwind to be proper naming convention. Orders table is now tblOrder. ALL works wonderfuly....thank you so much Bob for your help and expertise. Dawn.

Thank you Bob, I did the code as you suggested and I'm getting the following error: Sntax error in FROM Clause. There is an order table and there are orderID, CustomerID and Orderdate fields. Dawn.

I've created a query for a form where I want the user to be able to select between start and end dates, BUT I also want the user to have the option of pressing return for ALL dates. I'm a newbie and I'm not sure how/where to put this code. What I've done thus far is put below in the criteria...

Rich, My DB after zipping is 156Kb and I'm only allowed to send 102kb. Can I e-mail this to you? Dawn.

Ok. Actually I have to convert it using the db utility. I've tried this before and it didn't seem to work, but I will try again. Dawn.

Pardon my ignorance Rich...what is a 97 ver? 97 Version of my db? Dawn.

Hello again Rich, Ok...I did what you suggested and I still get no return. Here is the code that I entered into the txt box (TotalSale) (which is the txt box that subtotals the 3 different subreports...

Hi Rich, Thank you for your response. I'm a true newbie to MSAccess. I looked up in the Help section for HasData and the following code is what was suggested: Me!SubReportControl.Visible = Me!SubReportControl.Report.HasData This is fine, but I'm not sure this is what I need. The help...

I have 3 different sale subreports within a main sale report. I want a grand Total of all 3. I use the following code for each of the subreport totals. The totals reside within the individual subreports. =IIf(Sum([TotalUnitSale]) Is Null,0,Sum([TotalUnitSale])) (I have called this txt box...