Search results

Hello, I have a query that has multiple "customers", who can have multiple "Products" and each product has multiple ship dates. What I want to do in a Report, and I assume this is a setup needed in the underlying query is show All Customers, All Customer/Products, and the last 5 shipping dates...

I'm having an issue with a Crosstab Query/Report. Query setup. Column Headings is the Month. Row headings is Product Name and Price/Gallon. Under each Month, I can sum the gallons of product sold, but I also want to calculate sales. I can do that on a report (with other limitations), but...

Hello Everyone. At work, i've developed a database that is used on our production floor and it's working quite well for our needs. I'm using Front End/Back End on a file server since I do not have a SQL backend. Everything is office 2010 and Windows 7 on the desktop environment. I've used...

Hello, to save space, I want to open a report based on a query from two different forms. In the query it's easy enough to do and it does work, however, when I open the report from the second location, I'm asked for the information from the first location. Basically we'll say the report is...

Hello all, my first issue of the new year, and Happy New Year too. I have a parent form with a list control that when a job is selected in the list box, it puts some text in a text control and does a me.requery for two subforms. The records in each subform change based on the job selected...

A somewhat complicated question and problem that I’m sure I designed without knowing. Before you ask, I cannot show any structure so I’ll try to be as descriptive as possible in a generic sense. it’s a design for work and I cannot divulge the information. To give some perspective, I’ll...

I have a form based on a query that I've developed over the past couple of days. When I first started, the form opened cleanly with no prompts needed. I could select my criteria, do a refresh and everything looks ok. The problem came when I selected new criteria, it wouldn't always update to...

Hello, I'm putting this one in the General because the problem could one of many different areas. I'm using a query, one data entry form and a form with List, vba with Microsoft Outlook Object Library code and it is checked in the references. First, I've created a query that checks for open...

is there a way to capture the domain groups that a user is a member of? For example, if I had someone setup groups like the following CompanyPurchasing CompanyProduction CompanyAccounting and I was a member of two of those, can I somehow retreive that information in access to allow some of...

I have a parent/child setup. A parent table that stores the "Name" of a recipe. Then I have a child table that stores order of ingredients and instructions with the "Name" of the recipe from the Parent Table and the order being the relational key. I want to copy Recipe 1 to Recipe 2 within...

Hello, Using Access 2007, I'm working on a form that will allow the input of the following. And then print these things on a report. Step Number - Number Field Step Instruction - Memo as size of description can vary Attachment (Picture) representing the Instruction - Attachment so the...

Hi. I've created a form with a list box that will get the username, look up a task list and then load the list box with those tasks. I'm doing this as a reminder of things to do. However, I'd like to anchor it to the right side of the database window, but I can't seem to be able to do that...

We'll I've lurked for a few months and just recently started asking questions and posting. Wanted to say my hello in the proper forum and I look forward to asking a lot of questions.. Eventually answering some too. Thanks, Ed User of Access since '97 and all versions until 2007 (so far)...

I think I need to go and introduce myself as I've noticed there's a place for that.. I've found this to be a great place to ask a question and get a good answer. I've tried searching but I think I'm possibly not searching the forum or Google with the right keywords. I found in here where...

I have a couple of update querys that search a status and/or date information and change the status of the record based on the criteria I've given. The querys work fine, I've just tried to use a Macro to run both queries. In testing the Macro it worked, but it prompted me four times.. two...