Search results

Sorry, but I don't understand what's happening. A file is selected, then imported into a new table? If import errors occur under these circumstances, a warning message is automatically generated isn't it? What is the "original form" you want it to go back to? And what changes will be made to...

You can use the Command Button Wizard "OpenForm" option. Edit the code and delete the reference to stLinkCriteria. Replace it with a comma, then acFormAddas the fourth argument.

If you look up TransferDatabase in Help, it gives you the basics of transferring and linking data from donors to hosts. If you wish to automate the process, you'll have to write a function which imports\links each block of data(i.e. each table), appends it to the master table using a standard...

This can be done with append queries. You have to make sure that the tables in all the donor databases are the same for names and datatypes as those in the host database. Then the process can be safely automated.

No, now I see what you mean... Put a calculated field in your report iif(MyCheckBox,MySumField, 0) and do a running sum overall to get the total

As I replied in my last answer to you, more information is needed about the structure of your database and the fields you want to search for matches. I am not sure how the code you posted applies to your situation. It might not be appropriate at all.

Well, you just put 4 for your First Quarter, and 1,2 3 for the rest in sequence. The result will still be correct..

IIf(Datepart("q",[DateEntered])=1,"1.00",IIF(datepart("q",[DateEntered]=2 AND NewCartSizecode="120 AND CartSizeCode="136",0.96, IIF(..... Biut where are you using this expression?

Can you explain this more clearly please? I don't understand exactly what you want to do. Do you want to count the numbers of YES/No fields that are TRUE?

Also you can use DatePart("q", DateDelivered)=1(or 2,3 or4) instead of the long Date Between clauses

At a first glance, you can just lump all dates of the first quarter into one expression, since they all result in 1.00 regardless of cartsizecode. This saves a large number of characters. So: (IIF[DateDelivered] Between #10/1 /2001 #And #12/31/2001#,"1.00", IIF(....... NB - you do mean to...

Well, I really don't think Access would do this job as readily as Excel could. But perhaps you should take advice from more than one source! Don't forget that with Excel you can send only those parts of your scenario to your idiots (sorry, engineers),which are appropriate to their project...

It sounds as if these tables are financial scenarios. So my next question is: Why not do this in Excel, which is better suited to handle this type of thing?

answering your first post, what are you basically trying to do? It seems you are trying to copy data from one table into another and alter the date in one of the fields. But it is extemely unlikely that you would want to replicate the data as well. Surely you only want to copy the structure...

Please don't feel you are being bothersome. If I didn't want to help, I wouldn't volunteer my services. I don't quite understand what you have done, but it seems that you haven't created a TOTALS QUERY. In Query design view, there is an option under the VIEW menu of show totals . Selecting...

Read Help about OLDVALUE (Access2000 and above). In the BeforeUpdate of the field you could put something like (approx): If Not isNull(MyField.OldValue)then MyField = OldValue. So if it's a new record, it will change, otherwise it won't...

Yes (but don't tell Annie!)

If you were doing a demographic survey and had some fixed criterion for wealth/poverty, a yes/no would be objective within the terms of the survey. I can be married today(God forbid!) and divorced tomorrow. I can be rich today and poor tomorrow. Where's the difference as far as the database is...

Yes, BUT there is nothing to indicate that the the other income information referred to is stored elsewhere. If it is not, then this is a valid, if rather imprecise, measure of a client's status and can be used as a general indicator of prosperity. As we don't know the purposes for which...

I understand what you are trying to do, but you can easily present the data in your tables ordered and totaled as you desire by means of queries. The subdatasheet simply shows you a list of related records for each customer. A totals query can show you all customers ordered by name, value of...