Search results

Ok, so I have a Report that is filtered by several combo boxes on my main Form. What I want is to change the value of a text box on a sub report on the main Report. The sub report that this combo box is on is either visible or not visible depending on the selection in the combo box. I have this...

Hey guys, I have a main report with several subreports on it that are filtered by a form with several combo boxes on it What I would like to do is have some of the sub reports only open on the main report depending on the input in the combo box ie.if the user chooses "Yes" from the 'Heated'...

Hey guys I was wondering how I would go about making it so that a query will run or not run based on the input from a combo box. I have a form with several combo boxes. And a couple of these controls a query that I would like to be optional. Right now it runs no matter what the input in the...

Hi guys, I'm looking for a little bit of help here. I have a form and on this form I have a combo box. Now this combo box is populated by a table that I have called "Options". So this is all fine and dandy to select items already existing in the table, but ideally I would like to be able to...

Hey guys, I seem to be in a bit of a pickle. I have a subreport embedded in my main report and a second subreport embedded in the first subreport (3 levels). On this subreport, I have a text box in which I do a simple total calculation on which I do a summation of data from the 3 subreport and...

I've been working on a database for the last month or so. It's been a slow process since I've been learning Access and VBA in the process. But my supervisor wanted a copy of it as a progress check to send to his boss. So I sent an email with a copy of the database as an attachment. THe email...

Hey guys, my problem is this: I want to run a query that runs off of two list boxes on a form. However, I want both these parameters to filter a single field in my query. Why I want to do this is I have several types of accessories made by several manufacturers, both included in the...

Hey guys, Ok, so here's my problem. I have a form which has several combo boxes. The user uses these to filter the information they need for a report. Each combo box relates to a different query and each query has a sub report. Now, on the first form there is a button to preview a report based...

Hey guys, When I try to open a report or a form in a database I've been working on for the past couple of days, a dialogue box pops up saying that I "do not have exclusive access to the database at this time". Does this mean that I can't access these form because someone else has the database...

Hey guys, I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed. I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving...

Sorry about the double thread posting, please look at the other thread with the same name. Thanks in advance for the help

Hey guys; What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report...

Hey guys; What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report...

Hey guys; What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report...

Hi all; I know this thread has probably already been done but I've tried searching and nothing I've found seems to be what I'm looking for. What I want to do is incorporate an automatic Date update to a table, every time an item is updated in that table. I've tried creating a new field...

Was wondering how one might go about creating a swithboard similar to the Northwind one found in the sample database. Thanks

hey guys, was wondering the coding so that when a form is opened, it automatically sets you up with a blank record. This thread has probably already been done, but I would appreciate any help

Hey guys, just learning how to use Access. I'm putting together a costing program and trying to do a on-the-fly summation of production hours, I have 12 items and I do the whole =[VALUE]+[VALUE]+... thing. It's all good until I include the last entry into my expression, up until that it adds...