I just copied a form from one database to another and for some reason the copied form in the new database does not display. the form opens but the area with all the info is blank... When I choosed design mode it all shows up correctly but in form mode it is just blank.
I am creating a report that is organized by project. The detail lines are to list payments applied to the project. How can I skip the detail section (or print a single blank line) if there are no payments in the separate payment table that match the project ID? Is there a way to tell that there were no matching payments and format accordingly? I currently get multiple blank lines.
I have a report that prints invoices, and in the page header area it contains most of the invoice information such as labor cost, customer info, etc. In the detail section of the report i have the line items, and a line contains a part, vehicle charge, etc. Some invoices dont have any line items though, and it seems that when there are no lines(ie. nothing in the 'detail' section), the header information will not appear either. Any ideas on how i can fix this?
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code: ABC Co. ZYX Co. 123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Sorry if this is inappropriate, but I don't think I've ever seen a post by a mod saying so.
We're working on a project developing an enterprise class solution for the petro-chemical industry. Currently we are building a prototype in Access and are in need of an Access developer to help with it.
If anyone in the Houston area is free and would like 2-4 weeks of work, please let me know. Our need is immediate, and would require that the individual work here at our office in Texas City.
How can I make my forms use the whole viewable screen area no matter what size monitor or resolution the end-user is using? I would also like all objects to be seen in the viewable area without the end-user having to scroll down or to the right. Is this able to be set in the form properties somewhere? I hope I am clear with what I am saying.
I need to make a random schedule every week. I have a new DB that I have attached and the current one being used that was built by some one else. The reason for building the new one is I could not figure out what to change to add a new section/Area for scheduleing.
What I have are 3 levels of auditors
Level 1 are the basic auditors which I will need 1 per shift per day Level 2 Are operationl Auditors I will need 2 of the per week Level 3 are management auditors and I need one of those per week.
When I get these compiled per week I will need to make a report to e-mail out.
I attached both DB's the old one to show what I need, and the new for a more stripped down and easier to update version.
Hi all First off, I hope this post is not inappropriate for this forum!
I'm looking for a designer for access in the Wagga NSW Australia area to help me design a database for our small business.
Some of you may have seen some recent posts by me regarding an invoice database. I was attempting to do this on my own but I now admit defeat. I can't get my head around the basics let alone the difficult stuff so whilst I have made a few DB's myself in the past they were basic, this one is way too complax for my hard head.
I would love to hear from anyone in my area who could help with this on a one on one basis (Hence the need for being close to me)
I am willing to pay for this service & would appreciate if the person understands that I want as much input in the design as possible so I can understand it top to bottom when completed.
Obviously I would like some kind of idea how much this would cost me. Bearing in mind itis tutorial sessions as much as design I am looking for. I would dearly love to be able to do this myself via some TAFE trainning or the like but I simply don't have the time for courses etc as my schedule is very hectic.
Anyways, enough reasons, the gauntlet is down, anyone care to pick it up?
Regards Mik
PS - I would like to thank all those who tried to help this poor wretch but I'm afraid I am a monkey see monkey do kinda guy, much better with one on one.
I have a form (eg. frmMain) with a subform (eg. frmSub).
The subform is going to be a query which displays results based on criteria defined in the main form.
So say frmMain had a field called 'OrderDate'. When they typed an order date, all the orders on that date appear in the subform.
The way I have it set up at the moment is that the query criteria is like [forms]![frmMain]![orderdate]
Do this means that once the order date is entered - there is still no results in the subform because the query has already run when the form was opened and, as this field was then blank, no results were returned.
I would like to keep this setup, but - instead of having the subform set to the query, it would be set to another form which just has a commond button.
The user will then input the OrderDate - click the button (which is in the subform) and the query will run. This can be done easily. HOWEVER, is there a way for the query results to be displayed in that subform area after the button has been clicked instead of opening up a new form.
I know in web design you can target links to frames, so wondered if this was possible?
I am using RTF2 ActiveX Control which enables me to include the Rict Text Controls in my Access Form.
I want to generate a doc document out of the information which i type in the RTF2 Area on the Access Form. And whatever Rich Text Format information i have written there (for eg in Bold, Italics, Indentation, Tables created, Bullets n Numbering etc), is retained as it is on the Doc document which i am generating with the help of bookmarks.
Please help in how do i do that 'coz i am not able to do it using the Rich Text Format...
I'm using access 2010 and have Tabbed Documents enabled as well as Display Document tabs.
When i open a form in design mode, it appears that I have the option of setting the form size parameters by dragging the page boarder horizontally or vertically to grow or shrink the size of the form. When I change view back into form view however, these changes don't appear to be having any effect on the form itself.
My question has two parts:
What am I actually affecting when I adjust the page size in design mode?
Is it possible to set a definitive end to a form in form view without reverting back to the Overlapping Windows setting?
I have show results of scores on a graph but need to show if those scores fall below, in between or above acceptable limits. For example, lets say the acceptable range is between 10.5 and 15.6 but people can scores between 0 and 50. So what I need to do on a report chart/graph is show the actual scores in columns, let access automatically adjust the scale, but have the area between 10.5 and 15.6 on the scale highlighted or coloured or perhaps indicated by two horizontal lines across the chart/graph.
I have a button placed on a form, but it is only clickable a few pixels along the bottom of the button. If you hover anywhere above this, the button is not clickable and does not highlight as if it is clickable.
I have deleted the offended button and recreated it, but the same strange behavior occurs?
If I move the button up a few pixels or more, then the clickable area shifts to the top of the button and the bottom becomes unclickable.
The buttons are in the header of the form and is completely visible when the form is in normal form view. I also can not see anything that could be sitting ontop of the button (no transparent controls or anything) that could be obscuring it.
SELECT (sum(d.cartonsshipped)/m.ctnperskid) AS PalletCount, itemnumber, shipdate FROM orderdata d inner join itemmaster m on d.itemnumber = m.itemnumber
GROUP BY d.itemnumber, d.shipdate HAVING (sum(d.cartonsshipped)/m.ctnperskid) > 0 ORDER BY d.shipdate, d.itemnumber;
and not get the aggregate error (3122). I am guessing it's giving me the error because i try to do a function in the select area.
How do I move combo box label into the form header area while leaving the actual field title in the detail area in a subform so they looked stacked like the other items??
I have a combo box in the header area. The record source, Bound Column are set correctly ( I know because I tested it on a form ). In this instance, the user would select from the dropdown list, the name of a member of staff, based on the click-event, and passing the Staff_ID to a variable, this would be used to filter a recordset/recordsource for the report. However, there is no dropdown ( or arrow on combo - so no name can be selected ) ?
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:
Code:
AREADONEREMAIN TOTAL AREA1100200300 AREA2200300500 AREA3200700900
Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?
What would be the best table construction to allow for the inclusion of area information that varies depending on the selection of a certain route, to also include crossovers?
How best to allow users to see all of the areas that apply to each of the routings, but not to be presented with the same grouping twice if more than one routing is selected at the same time?
I should add that I am looking to have these selectable by a combo that is filtered according to the value(s) in other fields.
I have a query to count the number of society members in a particular UK Postcode area. It works well for a single Postcode reference but adding further references to the Query Design View generates an 'or' or 'and' statement, rather than the additional counts that I need.
The SQL code I use for a single reference is : SELECT Count([Mail List].[PostCode]) AS CountofPostCodeH FROM [Mail List] WHERE ((([Mail List].PostCode) Like "BN5 ???"));
How do I amend this code to produce counts for multiple references in one query.
I have a couple different reference files that get updated each week. Sometimes there are missing data elements, so I'd like to structure a select query to show me those records that have blank elements but I'd like the similar records to be pulled in as well, so I can make a determination as to how to populate the blank records..
See attached example: I have a client ID reference table that gets populated with forecast owner names (individuals responsible for the customer) from a couple of different sources. Sometimes there are names attached and sometimes the field is blank.
How can I structure a query to show me just those Client ID's that have multiple entries with blank AND non-blank forecast owners? I'd also like to exclude single/multiple records where there are only blank records...
OK, I have been searching around on the fourm for over an hour now...I give up. If this is some where else, I am sorry.
I have a database of maintenance data. There are several columns that are usually filled in, some records have some columns blank. They are formated text because they hold letters and numbers (see pic).
I am using a form to query the table...no problem. The form has text boxes the user filter down the data
The problem comes are with the results of the query. Any record that has a blank column is not retuned. I am using "Like" so that the user can enter in partial codes. I know "like" won't return "null" records.... Help!
Things I have tried: 1)IIF(form field is blank, return table field, else use like command to filter) - returns nothing! 2)Like "*" & [Forms]![Fleetwide_data_Request]![MAL_CD] & "*" returns all records without blanks (i.e. missing data)
I have been running the same database on numerous systems for 5 years and the user clicks on a button and using this code;
DoCmd.OpenForm "Employee", acNormal
Simple !, this always opened this form blank, without applying filters, ready to accept a new employees details.
But now this no longer works, for no apparent reason? What happens is that it opens with the form fields filled with the first person in the Databases details instead of being blank.
The only thing that could have changed is that i converted the database to 2003?
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.