Search results

I have a series of files that I am converting from dBase and I would like to merge them into a single table. They are history(for 2008), hist2007, hist2006, etc. back to and includiing hist2000. Each file contains about 1200+ records & 12 fields of varying lenths. The immediate goal is...

I am trying to build a filter in a query that will allow me to filter dates between a range, ie. Mar 1 through Mar 31. I am putting it as part of a button to select the month and print a report. Each year will have different data and so I want to have it select between the beginning of the...

I am attempting an append query and I get a "key violation" error. I know it has something to do with a key field. I have added and removed the "key" and still get the same error of not being able update some records because of the error. I have the records sorted. Any ideas? Thanks...

I am using an append query and get a "key violation" error. Everything that I have read indicates that I probably have some duplicate records somewhere. I am confused as to which of the two tables has a duplicate record. I think that it should be the target table. I have eyeballed both target...

I have a table with 22 fields defined. When I attempt to add one more field and then I try to save, I get the error message: "Too many fields defined. " I understood that the maximum number of fields allowable was 255. In the past, when I encountered this problem, I deleted multiple fields...

I am attempting to update a field in which I have blanks. I get no update for those fields, but I do get updates for fields that have values. I know that it has to do with blanks and zero fields are not treated the same. I recall reading something about treating them as null, but cannot find...

I have been trying to print structures of my tables(called file structures in old programming)for documentation. I have not been able find a way to do so. Also, I have tried to print documentation for macros and rather than getting a nice neat listing that looks like a spreadsheet(the way it...

I have a report pointing to a query using a "stmtcode" field name to sort by in the Record Source and it prints correctly, BUT when I try to change to a different sort using "mailcode" field name, it still gives me same sort as before. For that second report I am using a query with a...

I have created a forms and have used BUTTONS to cause an event to occur. Now I would like to use a form that displays all of the records of a table and to be able to use a CHECKBOX for each record to accumulate all of the records selected so that I can accumulate from among all of the records in...

I am having trouble with an update query where I am attempting to add or combine several fields together into another field. Nothing calcs for some fields. If I recall, the problem is because at least one of the fields has blanks rather than zeroes. Somewhere I recall that in that case I need...

ACCESS2007 I am trying to sum fields and group related records together (as in a report, but in an append query) so that I can place the resulting summarized data into another table. The sum functions get me field totals, but I cannot find anything that will allow me to total by groupings in a...

I have summarized a table(a) of 589 records into a table of 119 records(b). I am trying to calculate a factor in (a) as a percentage of the total in (b) for each record in (a). (a) can have multiple records for each corresponding, summarized record in (b). I do this by dividing each of the...

Access2007- Building a query to handle future input... I run an update query that does what it is supposed to do and gives the proper values. THEN I add a one more field to the source with the builder using + that has no data in it yet, the query fails and gives blanks, even though one of the...

I have looked through help and books and cannot find some items on the "properties tabs" in the report designer. One example is the "filter" property. The only thing that I get is a "zoom" and that is a blank screen. What is the syntax for that? Where can I read about it? F1"Help" has been...

In my macros, when I use "OpenReport" I get these yellow warning triangles. I know that I am doing something wrong, but can't for the life of me figure it out and track them down. I have searched and searched and cannot find anything in any of the books nor helps. They seem to function without...

In my macros, whenever I have an "OpenReport" action, I get these yellow warning triangles with an exclamation mark in them. I know that it must mean that I have done something wrong. I have searched all over and cannot find how to track down what is wrong and how to fix them. They seem to...

Within a Macro I am able to successfully establish and display filtered records from a table with success, but when it goes to the next step of the Macro (to print the filtered records), it begins to print the entire table as if my filter were non-existant. I have looked at the report and have...

On Report Form design view, Property Sheet under Data Tab, there is a property "filter" and a property "filter on load" just below it. I am trying to find the syntax for placing a filter in that property and have been unsuccessful. I have also tried using filters elsewhere to accomplish my...

In my individual page report with the data detail and the name and address do not match up with the data detail... The first group of name and addresses in the headings do match up perfectly with the detail records in the group, but when I go to the next group, the name and the address is one...

In using a form as a menu with macros, how can I select a print job from the menu choice and get it to print a report without the print wizard popping up?