Search results

I would turn it on its head and have the months as columns, as these can be fixed i.e. Jan - Dec then each year's data would be on a separate row which can grow and grow.

look up DoCmd.TransferSpreadSheet. This will do the job for you.

I'm not quite sure what you are after but If you require to sort and renumber this can be achieved in a query. You will require a sub query. Here is the basic outline. it uses the Authors table wich consists od an numeric ID and Author name Non Unique Sequence SELECT (SELECT count(au_id) FROM...

Although the upper limit is 2Gb. You can link any number of tables. What i would do is develop a sub to read the whole file and maintain a line count. develop a sub to read x number of records and write them to another file. then a sub to read from x+1 to end of file again writing out the...

what you can do is to trap the error number so in the on error routine IF err <> 2046 Then Msgbox err & " " & err.Description endif Resume yourExitHandler

why not strip off the 'Q' in a query, convert to Integer and sort that.

look up transaction processing in the help file. it is the transaction.rollback that does it all for you, in a transparent manner.

First thing I would do is learn to spell av - have avin - having plzz - please cud - could

Use transactions processing if you want to undo changes. use Docmd.Execute YourSqlStatement, DBFailOnError this will cause any error routines to execute, and is where to place your transaction rollback command.

Just be aware that totaling hours and minutes from a datatime field will only go up to 23h 59 min. This is the way Access works (or at least the versions I have worked on) You may have to spilt the hours from the mins and perform int(totalmin/60) to get the hours and mod 60 on the total...

What you need to do is to disable the Min max close buttons on the form then generate a button to close the application (there is a button wizard that will help you)

I don't think Me. is applicable in this context, just refer to the fields as you you see them in the field list.

You require a Parent table for the item, and a child table to hold the photos. The child table will hold the primary key of the item as a foreign key. However standard practice is to store a link to the photo and not the photo itself as your db will bloat to the point where you may wait a...

You can specify what column headings you require on a crosstab whether there is data or not. Open Query properties and enter each column required in quotes seperated by a comma.

Quite often when moving shotcuts from one PC to another Windoze in its wisdom changes the actual path that you can see in the shortcut properties. Check the properties and re-specify if necessary. Are all the versions of Access the same on each persons PC and are the paths to Access the same...

use UBound(myarr2)-1

Ah so its homework

You require a totals query. Create a normal Select query, Add the style field and the order quantitiy to the grid, then convert to a totals query. I do this by selecting View/Totals from the menu but it may differ from version to version. Then set the type of total for the style to GroupBy and...

what is preventing you from converting a db from Access 2000 to 97, this functionality is built into Access. There is always a method to convert to the previous version. 10 years ago I developed an Access 97 db using Access 2000

Two reasons, spring to mind, 1) does the Cancer Treatment table have an auto numberID, if not You may have two treatment entries with the same ID. 2) Similar to above, I have seen combo box that do not show the correct value and they are out by one and that is where you have 2 keys identical...