Search results

Hi, In the 2nd query I made, the only thing in there is the following expression at the top of one of the columns: Sum Of Expr1: Sum([qryCalcMiles].[Expr1]) Can I provide any more info? Thanks, Jim

Yes, indeed I am querying a query. The first query gives me the records from the daily mileages. The second query totals all those daily mileages to return one figure, which I get (both queries work fine). Would just like to display the total query on the form. You mentioned to make sure...

OK, I tried =Sum([Expr1]) and now I just get #Error I put the above expression in the same place where I had the previous one. Please help, and thank you, Jim

The expression is: =[qryTotalMiles]![Sum Of Expr1] And, it's in "control source", of the unbound box. "Expr1" is the 3rd field in my first query, which does the substraction operation to result the miles for that record. That expression above was built using the wizard ... Can you please...

Hi. I thought I had this problem solved. I have a query which calculates beginning and ending mileage, and displays the miles driven for that record. Then, I decided I wanted a total of ALL the miles to be displayed onto the single form, which has a single underlying table, (with my 2...

Hi, I have Access97, which I upgraded to Access 2000. Now, my Access97 had at least the Office Service Pack 1 installed. But, I can't update my 2000 version now, with the service pack 1 for Access 2K. Also, I am running this on NT 4. I understand that the Service pack for Access 2K is...

Thank you both. Indeed, I did end up modifying my query criteria. In the query criteria field, I made the expression to point to the value of the current employee record, on the main form. This gave me exactly what I want, for the report. Thanks, Jim

Hi, I want to open a report in preview mode, that displays the complete history on the displayed employee, NOT all the employees. But, when I click my command button, it displays the report, listing all the employees. I think the problem is in the criteria of my query. I don't like using...

Thank You, that's all I needed to do, had I bothered to look for it. Jim

Hi, I'm working on a database, where it's imperative that I split the database from the tables, and then update just the front end. But, i just discovered that when placing the front end and the back end in different directories on my same computer that the front end get's disaccociated with...

Hi, I have a problem with a form not opening in datasheet view. I have a main form, a subform, and a subform within the subform (which uses the tab control). So far, everything works ok. But, I added a butoon to open the subform on page2 of the control, in datasheet view, so the user can see...

Wayne, That would certainly work otherwise, but my problem is that there's no room. That's why I need to make this Details form a pop up form. I almost got it working, but I still get: You can't add or change a record because a related record is required in table "Service" And I know for...

Hello, I think this is a subject issue which I've certainly help beat to death. It was answered with previous help received here, when the issue at hand was "how to get my pop up form to match a certain field from the underlying form, with the help of a query". In that case, it was a query...

Hi, In using Access 2K, I have created a pretty complex database. I find now that I cannot make an mde file out of it. I can however as a test, create a new database, put a single table in it, and create an mde file no problem. Is there a simple way to figure out what is hanging me up on...

Hello, It's been a while since I've been here. I have a database which I'll be sending to someone to use for their business. I want to post it on a website, in case my flaky email decides not work (as is sometimes the case). If so, I want to put it on a web page, for the user to go to...

Hi. I'd like to be able to insert some code, which I suspect would have to be in a global module. I want to have a message box pop up weekly, or daily, after a certain date. Let's say August 1, 2003 (example: Please make sure all records to be included in QTR2 are in by close of business...

Hi, It works now. I switched some things around, and I think it's giving me what I want. Thanks, Jim

Hi, I have two problems regarding a query and a form field. The pop up form has one field it should display the result of a calculation in my query. I ge the ?Name# error, and I've specified using the builder right down to the query field. The other problem is that I want my query to total...

I have the understanding that child/master links apply to subform/mainform setups. I was hoping not to have to set up another subform and instead make this a pop up. In my table relationships, supplier is the PK, with a many in Service. Do I need to put at least the one field from Suppliers...

Hi, I've uploaded a graphic of my database form to illustrate a better idea of my issue. In the Service Table (subform), I have just included some extra fields: SupplierID , Parts, and Part Number. Of course, I also created a new table "Suppliers", with SupplierID as primary key. I can't...