Based on a set of records <r> with data <x> which is grouped by attribute <y>; within each group of attribute <y> - i want to filter records as the running sum of data <x> exceeds criteria <z>.
for example, with the below data, as <x> exceeds <z> or 3.5 (by summing from top to bottom)- for each...
I want to do your basic look-up function on a ReportNet Report. For example, I have a list of styles as well as multiple color numbers attached to them; but I have used the minimum calc to display only one of those color numbers; now I want to display the color name that is associated with the...
In XP- Office 2002- when I send an attachment using VBA from another application such as Access or Excel, I am prompted by Outlook or Windows(I dont know), but the prompt asks me if I want to send the attachment from the outside program(something along those lines). I would like to turn this...
I have a Form with 2 subforms within it- both bound by same table. I would like the user to browse a more expanded list in one subform, and select a line(record), and then have that particular record filtered in the other subform; and this is where the user will make any changes.
So how can I...
I need to send an access table as a text file attachment but not in the default access text format; it needs to be a delimited format with separations by "|" and with no text qualifier.
Any ideas on how I could do that?
Thanks much.
Well, the question is in the following line:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel2000, "1", "V:\PC Fax\Novemberbilling2002.xls", True
I need to omit the path V:\PC Fax\Novemberbilling2002.xls and allow user to browse the file in the API window.
Is it...
Hey-
Could you help me print my Adobe files from VB? My users are printing a form to the Distiller which is set as the default, but then they are required to manaully change some printer settings and then print the distiller file. The reason I am doing this is because I am not able to reduce the...
I am currently having problems decreasing the scale within access to allow me to print a form on one legal page. The only way I have been able to do this is to print it to the Adobe Distiller first and then print the output(manually). Does anyone have some code that could 1) Identify current...
I have a form w/ unbound textbox & several subforms. This is shared by many users. When selecting an item from the textbox, information ON SCREEN properly updates within the subforms. But when PRINTED, data within subforms remains as data related to the 1st item in textbox. Why would this be...
It finally dawned upon to check the record source of the form/report. After removing the recordsource, the report/form did not duplicate. In some of the form cases, within the subform controls, you need to make sure it says NO to Can GRow.
I want to be able to print a form on 1 legal page, at least 1 page wide, like for example in excel you have an option to fit page to a specified width. IS this possible in Access w/o having to adjust the size of your data?
Ive noticed that this question has been asked many times but I havent seen a helpful answer yet- I am having a problem when printing a form/report. The data is repeating itself again and again. I have understood that it may have to do with the amount of records contained in the query but that is...
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.