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 know there is probably a more elegant way to do this with subqueries etc, but I would take the table listing the donors and their amounts and create a query that Group By Donor ID (assuming there is a record that is a unique id) and sum(donation amts) for the given year. You can then filter...

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...

Based on how this is set up, it looks like you just put it in a field in the query designer top row as NameField: getSchedule([name of field with text string]) where the NameField is whatever you want to call this new calculated column and the name of field with text string is the table...

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...

If a tree falls in a forest... Answering my own question in case anyone happens upon it with a similar problem. There was really no error handling beyond Move Next in my original code, and there were errors occurring. I tried setting up to find out what and where. The 1st problem was that it...

I found another thread this discusses this without resolution: thread705-867742 I am linking to tables SQL Server if that makes any difference. Not sure there is any resolution to the recordsetclone method of doing this.

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...

This shouldn't be hard, your problem does seem to be based on how your query is set up. You want to group to the CPT level. If you explain what the query shows that would help in figuring out the best way to do that. Kris

Oops! You wanted fields in tables not list of tables. Sorry.

Here is the SQL, cut and paste into the SQL screen of a query. SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name I saw this in a FAQ at http://www.tek-tips.com/faqs.cfm?spid=181&sfid=690 Kris

The calculation I use for beginning of week would be [DateField]-Weekday([DateField])+1. This assumes Sunday is the first day of the week. If the day of week for DateField was Wednesday it would be calc to 4, which counts Sunday as 1, so you need to add one so it will only subtract 3 to get 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...