Search results

This is the set up I'd suggest...

"If I have been able to see further, it was only because I stood on the shoulders of giants" - Sir Isaac Newton

try using the long month format "dd mmmm yyyy" so it comes out 01 September 200X, this should then be correctly converted. Using your format() above, it would still return 01 09 200X which could still be converted to american date format without explicitly recognising its month.

Having reread your question I may be off on another tangent. The above will print every table in the database except system tables. If you require something different, ask again. Can you explain what you mean by 'I have tables built in forms'

This is about as good as I can come up with... Private Sub Command7_Click() Dim i As Integer Dim tdf As TableDefs Set tdf = CurrentDb.TableDefs For i = 0 To tdf.Count - 1 If Left(tdf(i).Name, 4) <> "MSys" Then 'prevent system tables from printing (prefixed with MSys)...

Right you are.

Do the dates need to be in the worksheet itself or just displayed on the form? If just displayed on the form, you can easily reference an unbound text box to form field using: =Forms![YourForm]![YourDateBox] If it is that you need the dates in the excel sheet, you will have to delve in VBA...

Use an update query to update the fields to: Mid([YourField],2,Len([YourField])-2) Should do it.

Without knowing the get start date function it is difficult give any exact advice, however I do know that SQL uses mm/dd/yy as default. You may be able to get round this by formatting the return of the getStartDate function into something which SQL will definitely interpret how you want, such...

For I = 1 To 4 MovementType(I) = Me("Type"& I ) Next I

raskew, thanks for the disappointment, that helps. Doesn't my example adequately account for translation of minutes to seconds etc?

Format(StartOfWeek(Date()),"ddd dd mm yyyy")

A workaround to this is to build a datasheet form which looks like a query, then set the underlying form controls aligned how you want and return to datasheet view, the alignments will be inherited. To print the data use a report as suggested above which I thought was a good explanation.

Function StartOfWeek(d As Variant, Optional FirstWeekday As Integer) As Variant ' ' Returns the date representing the first day of the current week. ' ' Arguments: ' D = Date ' FirstWeekday = (Optional argument) Integer that represents the first ' day of the week (e.g., 1=Sun..7=Sat)...

Rich, I find that comment a little 'rich' :), actually I think there were two gamers stealing my bandwidth when I posted, so I hit the enter twice. Damn line-sharing kids. Down Under: Using either method you can't calculate above 23 MINUTES AND 59 SECONDS. Try the attached instead which...

I think you need to reference it with the objSht object to make it point at the excel application object.

Not picky Rich, a good point. Good job I haven't got a real job :) ::Puts thinking cap on::

Not picky Rich, a good point. Good job I haven't got a real job :) ::Puts thinking cap on::

Try the attached.

So what you are saying is you need another status field for updated room number records?