Search results

I need help modifying a query I didn't write...or, if it's better that I write a query using the results of this query, I'm open to that. I have a query: SELECT SP.[Store Product Key], (([P].[Package]*[P].[Size]*[SP].[Cases])/[P].[ConversionRate]) AS QOH FROM Product AS P INNER JOIN [Store...

Can someone tell me why we get an Enable Content warning at the top every morning when we open the front-end database? Marcie Fessler Access 2010

I think my head is beginning to spin and I am beginning to think in circles about queries. Is it better to create queries to display information in forms and reports (forms to update information, reports to print it out), than to just have the forms and reports get the information themselves...

Thank you. When the other person working in the database leaves early today I'm going to make those changes. Thanks!

I'm getting a "Field Cannot Be Updated" error when trying to add a record to a sub-form. I click "ok" and continue...I can input the first field in the sub-form, but nothing else. I can go backwards to the previous record, then when I come back to that record, the data that I input is there and...

You are all so helpful! I would be sooo lost without this forum. Thanks everyone for your help. I'm chugging right along now with this project with the grocery stores. I found an issue by mistake yesterday. While I was trying to test one of my forms (which was NOT working and I had to...

That was it! I went into the form and did the same thing...now it all matches. THANK YOU!!!!!:)

Here's the shot of the Form in Design View...

The Product Query shows 2184 records. I've included a screen shot of the Design View...I hope I did it right. The Product data table has 2732 records. Marcie Fessler

The jpg opened for me just fine but I'm sorry, I'm a newbie too and can't help you.

I'm not an Access developer...but I'm becoming one quicky. :) I have split the database, with the back-end residing on the server. Only 1 other person is working in Access right now; she's verifying the data. Today she's working directly in the back-end so someone, please tell me if this could...

I have a large database of hazardous products carried in grocery stores, etc. Several reports are required, including 1 copy of a document that lists the governmental-required reporting for each product. These documents are all in PDF form and I have a link to their location on the network...

I've found a piece of code that's supposed to produce the results I want. Here it is: '************ Code Start ************* ' This code was originally written by James H Brooks. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in any...

Not sure how to send a screen shot of what my report has to look like.

Could it have something to do with the fact that the page numbers are in the Page Header, not the group header?

Great! That almost worked. I'm working with products in aisles in a grocery store. The aisles change depending on which store location I'm working with; that's set up in one of the tables in the database. The particular store I'm using to create the report has 23 pages for Aisle 6, then...

It's been a long time since I've used VBA code...but I'm not a stranger to writing code. I'm actually in the process (beginning stage) of learning Java, as I want to write an application for something I'm doing personally.

Forgot to say it's Access 2010 but the database for some reason saved as a 2007-2010.

Thank you! Now I have the Aisle Number Header. The next part of the issue is how to get the page numbering to work correctly. I have ="Page " & [Page] & " of " & [Pages] at the top of the page, in the header. I want the numbering to start over at 1 for each new aisle number. I want...

I appreciate the answer but I need more basic instructions. I have a page header and a page footer...but I don't have any other headers. Since I have no idea even how to enter a sub-header (like "Aisle Header" or whatever) these instructions don't help me. I'm an intermediate user that's been...