Search results

Well....Access will do this for me. Nevermind :p Got to stop doing this!

Ok - Long story short. For 'user' I dont want them to be able to edit tables or anything (disable menus and what not). For the admin I want to be able to make these things viewable again. Is there any way to do this in VB??? Thanks

Found it :p

Hello...I have a form that needs to have code placed in it so as not to have records updated. Thanks to a previous post, I believe the code I was showed will work. But I do ahve a question: Where can I put this 'on current' code? The form has text boxes binded to a table. I want to be able...

Thanks for clearing up that 'Me' thing. Been wondering that for a bit. As far as the on current event, all I have where you suggested to look is On Click, On Dbl Click, On Mouse Down, On Mouse Move, On Mouse Up ? This is obtained by right clicking the form (where there are no objects) in...

Omg.... :rolleyes: lol @ me

Kick ass! Between '1-1-' & Year(Date()) And '12-31-' & Year(Date()) Jon K - thanks!!! One question: Why is it that Year(Date()) works and not Format('yy', Now()) ?

Hello there... Searching through the forum I have come close, but not totally correct yet as to the syntax I need to use. tbl_1 has dates stored in medium date. I have a query set up to do many aggregate functions on the results, but before I do that, I want to specify a date range. The date...

Ok - I'm sure this will do what I want. I just have a few newbie questions. When you say "me.newrecord" is 'me' the table or the form? and is it the same when you say "me.field1.locked = true "? OK...now - how do i get to the OnCurrent event? I tried going to properties of the form, but it...

Hello I have a form that is populated with data from a table. The form's entry's are bounded to the fields in that particular table. My problem is, I want the user to be able to veiw existing records, but when they make a change I want to force a new record and NOT save changes to the current...

Yea, I got that - but the initial SQL was to cumbersome for a format(). But - after I got fed up and started from scratch again, I was able to make it more workable with the SQL. Thanks for the help

Well - I just formatted each type and smashed em together.

Ok - I optimized a little: DateDiff('h',Sum([tbl_log].[Off Time]),Sum([tbl_log].[On Time])) AS Hours,DateDiff('n',Sum([tbl_log].[Off Time]),Sum([tbl_log].[On Time])) AS Minutes,DateDiff('s',Sum([tbl_log].[Off Time]),Sum([tbl_log].[On Time])) - DateDiff('n',Sum([tbl_log].[Off...

Ok - I tried changing the quotes around and it didnt help. I moved some things around and got it to 'work' but when I say work, I mean that it says its to complicated to do a Sum(DateDiff("hh:nn:ss", field1, field2)) So....I just did a sum(datediff()) that returns seconds then i did this...

Ill try changing the quotes around, and the format is correct. I get a correct answers when using 'n' but not when I'm using 'nn' (which was obtained from the User-Defined Date/Time Formats section of the help file).

I searched through the forum, and found alot of examples on DateDiff(), but I need to take two dates (both stored in a table as [Off Time] and [On Time] and subtract them. Then show them in hh:mm:ss format, keeping in mind this is in a query. The datediff() function gives me and error if I try...

Jon k I still have hair thanks to you. Worked like a charm.

Maybe someone out there can tell me what I am doing wrong. Cause I am loosing my mind today!!! SELECT tbl_equipment.Equipment, Sum(tbl_log.[Off Time]) AS [Off Time] FROM tbl_equipment INNER JOIN tbl_log ON tbl_equipment.Equipment = tbl_log.Equipment WHERE...

yep - that does it thanky

Hello I was wondering the vb code to do something for me. I have a field that is ##_#### The first ## is the current week / 2 The '_' has to be placed in and the last #### is the year. ie: 23_2002 I want this as a default value for a field on the form. So AfterUpdate on a list box, it will...