Search results

The best thing to do, to lose weight, is to eat properly. After that in addition you can join the gym or take part in some sport activity regularly such as football, rugby etc.

Greatest manager of all time, will be a big loss to Man Utd. No manager can replace him and the only one close would be Jose Mourinho but that would be short term as he never stays at a club for long! If David Moyes gets choosen I feel Fergie should of retired next season and sign Moyes as...

If I owned a company, I would care about how employees represent themselves. I wouldn't employ someone where a tattoo is visible although I wouldn't mind if it was out of sight never to be seen in work. Just like if two people, one fat one normal, with similar CV's came for a job I'd more likely...

As far as I know you have always had to save code in a module. In 2007 if you tried to exit, it would pop-up asking if you wished to save changes in the module.

Do you use many temp tables? I usually find this happens to me when using temp tables or using a delete and an append query on a table. As stated by paul, compact on close option works fine for me. I also try to have temp tables on another mdb.

That will work just the same, I just copied code I had from an open worksheet which started a few columns down. As I said it depends on his needs.

I'm confusing myself now. :D Then =ROW()-ROW(A$1) will work perfect. If you want to have the autonumbers start from 1 then you add one, but as a general rule I always start with 0.

I normally use the fill myself but it depends on your needs. Oh crap, completely forgot it's for columns. In that case: =COLUMN() -1 will work perfect, remove the -1 if you want it to start from 1 instead of 0.

Nope, you can still do that. @Dick7Access you should use =ROW()-ROW(A$1) instead of A1+1. So if you delete a record it will re-arange the auto-numbers where as A1+1 will give you errors. It depends on your needs.

At first glance, the start should look like: IIf([Weight]>5 and [Weight]<21

Should be something like: SELECT Table1.Seniors, Table1.Juniors, Table1.Novices, [Seniors]+[Juniors]+[Novices] AS Total FROM Table1 WHERE ((([Seniors]+[Juniors]+[Novices])>100)); Change Table1 to your table name - highlighted in red If you don't want to include the total in the results table...

Can you maybe explain what you want? There are plenty of ways you can autonumber by dragging a series of numbers etc. or using formula's.

Could you not just create a table using the query results and use the table instead of the query to import to excel?

Tested and this works perfect: Private Sub Command0_Click() Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFile "http://wsdfarm-brise-something/ExtractBOXI/Referentiel%20MSP/Tickets_CC_daily.xls", "\\dakar\soemthing\something2\works.xls" End Sub

Try: FileSystemObject.CopyFile "http://wsdfarm-brise-something/ExtractBOXI/Referentiel%20MSP/Tickets_CC_daily.xls", "\\dakar\soemthing\something2\works.xls" If it doesn't work check your links are correct. You don't need to have true at the end because true is default. :)

Maybe you need to explain exactly what you are trying to do. When you import the excel file are you doing anything to it?

What if the car has no booking at all? I'm not sure the best way to go about this but what I would do is create an expression field in the query which will return either 1 or 0 for each record. 1 if the car is booked within the date and 0 otherwise. Add all the fields up for each car and if the...

That's what I wanted explained in the first place. You could always insert the short and long version into the In.

You didn't really explain that. Can you show what your tables look like.

Surely you would use "In" then? eg. instead of: ([field1] Like "*criteria1*" Or [field1] Like "*criteria2*" You should be able to do: [field1] In ("criteria1", "criteria2", "criteria....")