Search results for query: *

Thanks Guys -- Works Great

Hello I am working with a db on a network with multiple users. There are four different computers using it. I am running this code after update of a 'wc' control: If DCount("[wc_code]", "dbo_rtemastr", "[wc_code]='" & Me!wc & "'") > 0 Then 'Do nothing Else MsgBox "This is not a...

Thanks guys

...chart. Here is the expression in the calculate3d field: act setup hrs cnc: IIf([workcenter]="CNC" And [insu]=-1 And [down]=0;([timeout]-[timein])*24;"") Can I put the format (General Number) in this expression somewhere so msaccess will recognize it is a number result that can be summed...

...chart. Here is the expression in the calculate3d field: act setup hrs cnc: IIf([workcenter]="CNC" And [insu]=-1 And [down]=0;([timeout]-[timein])*24;"") Can I put the format (General Number) in this expression somewhere so msaccess will recognize it is a number result that can be summed...

Mike, Thanks for your time and knowledge. Jeremy

...of the set-up check box and a 0 in the criteria for the down time check box, then create the calculated field: act setup hrs: ([timeout]-[timein])*24 I then want to see the log in times for down time in the same query. Normally I would just create another similiar query, only I would put a...

...of the set-up check box and a 0 in the criteria for the down time check box, then create the calculated field: act setup hrs: ([timeout]-[timein])*24 I then want to see the log in times for down time in the same query. Normally I would just create another similiar query, only I would put a...

SteveR77, Hello. I have two date/time fields that I subtract in a calculated field to get the 'act hrs' value, which is numeric. I would need to subtract one half hour from the 'act hrs' value, If the value is greater than 6 hrs. Thanks for your time Jeremy

Hello I am working with a db that employees use to clock in and out of jobs for production/ efficiency tracking. I don't want them to have to take time to clock out for lunch. Is there a way to maybe create a calculated field that subtracts one half hour from another field called 'act hrs' if...

Hello, I am working with a db that I just recently split manually. Now the forms in my front end take forever to open. Could someone possibly share some pointers on how to improve this performance? Many thanks as always. Thanks Jeremy

Hello, I am working with a db that has a switchboard with various command buttons I would like to hide if user login name is 'shopfloor.' Can this be done? Thanks Jeremy

Hello, I am workin with a db that has a form and a subform. The subform has a couple of controls on it that have If IsNull functions, then msg box. The only problem is that when the user clicks ok after an IsNull msg, The bogus value is still there. In fact, once I set focus away and back to...

Hello, I am workin with a db that has a form and a subform. The subform has a couple of controls on it that have If IsNull functions, then msg box. The only problem is that when the user clicks ok after an IsNull msg, The bogus value is still there. In fact, once I set focus away and back to...

Hello again, Thanks for your time and expertise. I hace tried what you suggested. Now I get the error 'the object you have referenced in the Visual Basic Procedure as an OLE object isn/t an OLE object.' What does this mean? Is there a way around this? Thanks, Jeremy

Steve101 , True, I don't know much about VB. However, I do prefer to use VB, but in this case I'm trying to trigger VB commands in an Autokeys macro. I wouldn't have posted this if I didn't need to assign an f-key for every button on my form because for this database on the shop floor, users...

Hello, I was wondering if there is a way to go to a new record using a macro. I need this because I'm trying to use function keys to trigger commands instead of mouse click. I had this working in VB onclick of a button in the subform using DoCmd.GoToRecord , , acNew. This same command does...

Hello, I am trying to use SetValue in a macro. Whaqt I'm trying to do is set the value of a control on a subform = 1. Item: [Forms]![frmwipin_plantone2]![Text89] Expression: 1 Not sure where I'm going wrong. Any suggestions are extremely appreciated. Thanks Jeremy

Hello, I was wondering if there is some kind of statement that could be written that compacts and repairs msaccess db without needing exclusive access. We have a db with about 30 users on five computers. If four computers are logged in and one is not, the fifth can't be logged in if the db...

cghoga, This looks like a great idea. I'll get back to you when I have time to employ this. This bug is my highest priority. Thanks very much Jeremy