Search results for query: *

I am looking at adding something related to the code to use the Windows dialog box to get a file path. It is faq705-2484 The users want to be able to click a button and select a place where a file is located and then once that path is established, save it so they can launch the file from the...

I have a report application that allows the user to open various forms, select criteria, and run a report. I need to print a selection of all of the reports for each division once a month, so I set up a main form called frmSet that opens each report form in sequence, sets the criteria that the...

I have a database that I have been having problems with lately. One or more of the tables will just stop being editable. The >* new button grays out and the tables are read only. I try refreshing the links through the linked table manager and that does not resolve the issue. I have to delete...

I don't pay a lot of attention to hardware details and was working along happily on my last machine. Had to get a new machine and my boss wanted to maximize performance. They give you the minimum requirements but not the ideal/best case. If one GB is good, more is better was the theory. I was...

This is sort of a half theory/half practical question. I didn't even know this was possible previously. I just learned it was possible from someone else's design to call a public function that is embedded in a form from a report (learn something new everyday). It looks just like calling a...

I have Adobe 6.0 and want to set up printing a set of reports from Access to PDF. It currently takes about an hour of constantly having to check and see if it is time to run the next report doing them individually. I want it automated. Set Application.Printer = Application.Printers("Adobe...

I have a report that looks like this: Name Period Mon 1, ... Mon 12 Last12_Sum Prev12_sum ----------------------------------------------------------- Ins Co 1 30 12% ... 15% 14% 12% Ins Co 1 60 25% ... 23% 24% 22% Ins Co 1 90 57%...

I need to set up a report to group information by week for a 52 full week (Sunday - Saturday) period. In the past I have had issues doing grouping by week at the point where the year ends. With months, you can do a Format(DateField, "yyyymm") that can sort November, December, January...

I have a patient database that will not close. It only happens if a new daily record is added. I can use the exit option if I look at data or a report, but when I add a new daily record it copies data from a previous days record into the new record using a recordset clone. After that, when...

I wanted to get the Developer Extensions for the Runtime version of 2003 and the ability to deploy it. The documentation on it is terrible. I get to the point where it asks to select an install language. It is a required field, the wizard won't move on without it. If I select English, it says...

I am trying to go through a table check several rows to see if they contain values and if not delete the field from the table. This can end up being for approx 50 fields it needs to check. The fields are all named Field1, Field2 etc... I tried two things so far: (1) find a field I want to...

I have a form with a lot of information and I wanted it as big on the screen as possible, but if you maximize it in the window it shows the min, max, close buttons even if they are disabled on the form. I got some code from Microsoft that sizes the form on open to the size of the access window...

I have a report that looks like this: 12 months down in the detail section with numerous columns across (charges, payments, write offs) and a total and average per month summary at the bottom of this list Further down a subreport with total and average per month for the previous 12 month...

Someone asked me to compare using Access to Filemaker (which I know absolutely nothing about). The major issue is that the database would be to collect information physiologic info and for each major part of the body or organ system, all sub-sections would be listed with a check box. The...

I have a report now that shows patient information in a group header (ID, Birth weight, Birth Date etc...) and then the charges for a specified range of dates in the detail section (includes Date, Charge code, Physician, Daily weight). But it will only show the dates that a charge was actually...

My goal. I have a list of Physician names with SVDT, appt time, duration, type, and status. I need to get it into a report where I can say for each specific date that a physician saw patients - how many did they see, how many were originally scheduled etc. (easy) - but then it needs to go...

I have a one page report that shows 24 months of data in rows at the top followed by various summaries: 6 month summaries since 2000 (6), current and past fiscal year and last 12 months, current fiscal year to date and past fiscal year to date AND then monthly averages of each of those...

I have a multiuser database that is generally working well, except when someone previews a report and looks a multiple pages (perhaps minimizes the screen for a while) and then tries to print the report or part of the report. When they print they get the image of the main form which is open in...

I am trying to take a list of data by month and create a second list of annualized values (12 mos) based on the first list. Jan 25 Feb 15 Mar 10 Apr 20 May 22 18.4 June 30 19.4 Jul 28 22.0 This is an example where I use a 5 month interval for the calculation. Starting in May which is...

I have created a custom menu for an application which contains three items: return to Main menu, print, and exit. When the app opens at the main menu, all of the options are available. But, when I open a report the print item disappears. It isn't greyed out, it's just not there at all - and...