I have a label on a form that I want to turn the visibility on/off based on a check box condition on a subform. It seems to work fine unless there are no records in a subform, then I get an error message.
Is there a simple way around this. I am a pretty basic user, so I am sure that this is...
Can anyone help with this one.
I have a report where the fields are set to "can grow". I want to have the "excel" look (ie. each field has a visible border) when it reports. I would like to have all fields grow equally to the size of the larges one. Is that possible? Otherwize it produces...
I know, I know always back up the database...I didnt.
I had it on a USB disk and for whatever reason (more than likely improper removal of the device), the database has been corrupted and cannot be repaired by the compact and repair procedure. I have also tried the Jet4.0 compact utility from...
I have a report that crunches several queries before opening, and I would like to launch a form while it is openning that would display the status bar that is found at the bottom left of the screen. I would then like to close it when the report is finally produced.
Is this possible??
Thanks...
Question for the pros.
I am trying to create a graph based on a query where two fields are summed and then grouped by month. I need to have one of the summed fields by a running total by month instead. How would I go about this?
THanks in advance.
I am hoping that someone can help me with a little problem that I am having...
I have a combo box on a form that looks up a value from tbl_main, field "Mark No" I want it to dynamically filter the attached subform, which draws from the same table, same field as a value is typed in the combo...
Hello,
Here is my problem. I have a list box that you select items from and populate another list box. The second list box populates a report. This is done using a "string" coding. The problem is when I exceed a certain number of records in the list box (usually about 120 records), the...
Here is the issue.
I have a subform on a form with two combo boxes. The first box (drawing), should filter the second combo box (weld) when a value is selected. In order to refresh the second box value when the first is selected, I used afterupdate..me.weld.requery.
This works until I get to...
Does anyone know how to export a report that contains a couple of graphs to excel, keeping all of the formatting and data? I can export it to an RTF and maintain the data, but I can no longer edit it (basically a snapshot).
I would certainly appreciate it if anyone has any good ideas...
Here is the problem..I have a database whereby one report asks for a number of days to report by when opening. The user is to enter a number and then the report is based on this number.
...Problem is I have distributed this database via runtime files (packaged for use on machines that dont...
I have a little dilemna...
I would like to have a combo box (named isometrics) and then click a button to move that value over to a list box (named current isometrics). I would then like to be able to select another from the combo box and add it to the list box as well. OR, be able to filter...
Here is an easy one for you experts...(not so easy for us amatures)
I have a form, with a subform which is linked by fields named isonumber (same name in both tables). Everytime I add a new record, I get a 2 records added in the sub form table...one with the isonumber and one blank. How can I...
Please someone....
I have two list boxes on a form called frm_multiselect. From the left box (isometrics), you can select fields and move them over to the right box (current isometric). I then want to open a report (rpt_foreman_main) and filter the records by the fields which are currently in...
Help
I want to sort by a number field [wldno] on a report, but it ends up like this
1
11
12
2
3
33
4
444
5
how can I order so that it will no just order by the first number and will order by all.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.