Search results

Try: exec BuildAttendanceEvents_GroupByEmp cdate("30/12/2007"),cdate("15/01/2008")

I put in Fo Fa and it came back with "Don't Listen" on the girls shoulder, and "to Rich" on the guys butt. So this is a setup right?

me.SectionName.Height Section names DEFAULT are FormHeader, FormFooter, Detail. If you rename them than use that section name. My Access 2003 displays the height in inches for each section.

There is not a FORM height. Form height is Form header height, + form detail height + form footer height. Look at the individual sections to adjust the height.

BACKUP your database. Use and UPDATE query. Create a query with the two tables, better to use the main table first, but does not matter. Join the two tables on the primary key MENU = QUERY - UPDATE Pull down the column you want to update (recives the data) from the main table. In the UPDATE...

I am going to guess whatever control has the focus when the form opens, is off to the side causing the scroll bar to be placed like that. Change the INDEX property of each control to properly reflect the order the controls should be accessed. No FREEZE command that I am aware of in forms.

Hummm, it would appear they mean CB = True, CB = False, CB = True OR False. Quite a difference in my mind.

Always call something like this from your form, say on the before update event. Sub CheckedBoxes() dim vHoldIt as variant if Me.ChkBx1 then vHoldIt = "CheckBox1" Else vHoldIt = "" if Me.ChkBx2 then vHoldIt = vHoldIt & " " & "CheckBox2" if Me.ChkBx3 then vHoldIt = vHoldIt & " " & "CheckBox3"...

I have a sony KB4 and this thing is great. I was a little antsy to spend the extra money for it over say a sharp, but in the long run I am glad I did. On the game system setting on my Composite input (it remembers setting by the port) the xbox is more than great at 1080p. But what really is good...

Yea, I could swap out Neil with Skynard depending on my mode/day also.

They are just using it for sorting. So a null would be first (giving ascending) and so would zero, it would not show in their query.

Why not just use conditional formatting in Excel to do it? Under FORMAT/Conditional Formatting for each data cell add this =IF(DATEDIF($A12,TODAY(),"D")>=180,TRUE,FALSE) Replace the A12 with your date field

If it is NULL causing problem, try this Val(NZ([Street_Number],"0"))

The SPLIT function would store the data in an array. It is up to you to convert it when pulling it out, just like you did (BTW that has been how I have done it for many years, like you did). Functionally there is little difference, just a tad easier to read. So dim SomeArray SomeArray =...

If you were using VBA, you could use the SPLIT function to break the string apart, but the SPLIT function requires an array to store the values in.

I have a Garmin Nuvi 760. It is not recommended for a bike (guess cause it is not waterproof), but it works really, really, well. Y9u would need a headset of some kind to hear it on a bike however.

ZZ Top Eagles Doobie Brothers Elton John Neil Diamond OK I know the last two aren't bands.

Having trouble finding a new seat for my 2001 Moto Guzzi Jackal (in the USA). Do you have any places that make replacement seats (poofier) seats for the Guzzi's over there? Can you give me a URL if you know of one?

If you bind the fields to the table behind the form, access will update/add automagically. So if you want the users to control the update, then you need an unbound form. How ever this creates problems because it takes a lot of coding to get that right. You may want to rethink your strategy at...

I like to keep the document/image/etc. in a separate folder, then reference it via a UNC. How ever that means they have to store those in some folder structure. You can then record the location for display in a text field. There is sample code for using standard windows dialog in the sample...