Search results for query: *

Option Compare Database Option Explicit This is a function I already have in my database but I don't know if it is functioning because it worked in 97 and I have issues with it now that I am running 2000. Been so long that it was in place I can't remember how I referenced it in the first place...

VBslammer- I don't know what I did wrong but nothing is happening when I enter a birthdate now. I pasted the value to reference the function but then got a zero in a field named TxtAge. I know I am missing something but what? RookieDev

Lupinis46- The control source of [Age]is =Age([Birthdate]&""&"Yrs" I get #Name error if the control source is not set as such. I am really baffled that I get the error message "You can't assign a value to the object" and then it does in deed carry out the operation. Odd isn't it...

TheAceMan1 and everyone.... My hard drive bit the dust so I've been busy replacing it. Last day of the warranty too..I had some good luck! Thanks for the advice I'll give it a try! I'll let you know what worked! Thanks RookieDev

Hi All- I have an after update event as such: Private Sub BirthDate_AfterUpdate() Me!Age = Year(Date) - Year(Me!BirthDate) End Sub Here is the weird thing, the [Age] field will update correctly after you click "End" on the runtime error. Runtime error 2448 You can't assign a value to this...

I have an AutoKey macro that will work out on the network but will not work on the server. I simply copied it into the front end of the workstations and all is well. When I am working on the server though and hit the f12 key I still get the windows save as dialog box. {F12} Open Form...

No actually I did not want the information to change. I have a database that is linked to a table in another database and if anything is changed in the original table it either shows a blank record or is missing information and I was wondering if there was a way to keep it from disappearing.The...

Is there a way to get the values not to change once they are entered into the second table and the underlying values are changed? RookieDev

If I store the values in a table and then those values change the next year will the original rates stay as they were or will the fields become blank after I put the new rates in? RookieDev

Sorry for the delay..I could not get on the web site all day an started at 5am. It just wouldn't display for some reason. At any rate...What I was hoping to do was this...When I am entering time if the Rate code is 55-100 then the value for that person's default PayType at RegRate would display...

I am assuming that Txttype.value would be my field named Rate correct? And I should place the code on the same place as my current select case statement is? Thanks RookieDev

Where am I suppose to put this by the way????? Just want to make sure I do it correctly. RookieDev[ponytails2]

Yes! This is looking more like what I need! How do I reference the Employee's default paytype though? I'm thinking that I will need to be able to change that Paytype if they work in another classification so at some point I am going to have to link in the PayTypes and their underlying rates...

CTOROCK, Let me give you a little more information.Maybe that will help. The PayType actually describes if the employee is a plumber or painter or whatever. Here is the situation. When I put in hours worked the home office wants the PayType to display and then the correct rate of pay. My...

Actually I did add that to the Query but I can't seem to figure out how to tell it when or how to use the RegRate and then the OTRate for the individual employee. Does that make any sense? RookieDev[ponytails2]

Thanks for the great advice! Here is the reason I am trying to seek out the missing numbers....I converted the data from a corrupted DB3 database and I want to make sure everything is accounted for. There would actually not be a record for a missing product and therefore all of the transactions...

Can anyone help to steer me in the right direction on this? I have assigned a default PayType to each employee. Here is the PayType Table. PayTypeID PayType RegRate OTRate 1 CLRK $10.83 $17.52 2 SOD $8.32 $18.26 3 HKA2 $7.75 $14.40 4 T&P $12.51 $21.54 5...

That works fine. Is there any way to have an indication placed on a report like a checking statement? RookieDev

Ok, I'll give it a shot and see if I can understand it. Thanks RookieDev

I was wondering if it was possible to create a report that would indicate missing number like your checking statement does. I have of course, an inventory listing and was looking for an easy way that I could find out what numbers were available. The Product Names start with 1000 and go through...