Search results

Thanks. Mark

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

You had it right. I will only be working in one year at a time, so there will not be any other years involved, nor will the data from other years be present in this table. I will only be in 2009 or 2010 and for this purpose will not need to see other years. I have tested it with other...

It worked perfectly. Thanks again. mark

Thanks. I will try that. Mark

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

Bob, I made a discovery that I would like to share with you as a solution. In my macro, I delete the records in the target table just prior to running the append query. I thought that I had already put a delete records in the macro, but I guess not. It is there now and it works perfectly...

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

Thanks everybody for your assistance, inquiry and suggestions. I have not counted the number of tables, but there are a whole ton of them and have added many tables since the last time that had the problem occurred several months ago. I did take the suggestion and made a copy of the table. It...

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

Pat, Thank you for your suggestion. I have been asking the same question off and on for months and have not received an acceptable answer that I can use. Everyone always wants to give me a suggestion using SQL, which I do not understand. I admit I am not a guru, but I think that I have a fair...

Even with IsNull, I still could not get it to calc with the blank field. I must have done something wrong on the setup. However, in the mean time, I did get it to calc for me in a workaround, which I have done in the past. What I did was in my macro and just before I ran the calc query, I ran...

We are talking the same language now. Thanks. It is the the designer grid that I am so familar. Here is an example of my table: record # |Field 1 | Field 2 | Field 3 RECORD#1 | 10| 0| 10| ....... correct calc (F1 + F2 = F3) RECORD#2 | 2| |...

Adam, Thanks again. I was hoping that it was something like a simple property setting in the table design mode that would solve it. I have put together a fairly large database with many tables, queries, macros etc. and this null thing has been a big challenge for me. I have programmed...

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

Thank you very much! I had forgotten about that feature. I knew it was something simple and you were a great help to me. I was trying to do it by using a query so that I could use the exact same report so that if I ever had to change the layout, I would only have to do it in one report and...

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