Search results

I cant change the table propery to number only so is there an afterupdate code I could run on a field and check for alphanumartic charters ?

I cant change the table propery to number only so is there an afterupdate code I could run on a field and check for alphanumartic charters ? jon

Ok so If I use this code Me.[Field1] = DLookup("[Sumofhoursdelay]", "QryName") If this runs I get the hrs I'm looking for but I can't figure out the WHERE end of this code. So again when the query runs it returns only 2 lines Company1 plus the total hrs and Complany2 plus its hours. So I want...

The query runs fine but how do I get the data out of the query and into the fields on the form. The total query is going to add all the hours for 2 companys for a certian record. There will alway only be the same 2 companys but the total hrs pre record may differ. So on my form I have [cust1hrs]...

that is exactly what im trying to do but cant get the code right.

=DLookUp("[HoursDelay]","queryname","[CausedBy]=" & [apple]) I still cant get the the total hours of the delays out of the query. Again the query on its own runs and does do the totals. I want to get the totals. any help please

yes I can do that. Let me mess around with this for a bit

so I run the query and then have the Dlookup grad the sum from that query? The dlookup will be the control source for the field?

I have a totalquery that runs fine and give me the sum for both fields I'm looking for but I can't get the outputs to fill the fields on the form. I have tried the Dcount query in the control source but that just returns an error and locks up access. SELECT [Tble-wcDelays].Causedby...

with a Dcount query works like a champ. If DCount(" * ", "Qry-Check for Delays") <> 0 Then

I do not believe its doing the requery Forms![Frm-mainform]![frm-subform].Requery Right?

No I have not I will do that right now.

I was trying that and its funny sometimes it works sometimes it doesn't. But I can't pinpoint why

So I have a subform that tracks delays there can be many delays for every main record. Users will start a delay and others will close them or complete them by entering the completed date / time. So before the save or unload on the main form I want to check the subform for any delays that are...

thank you guys got it working great

But I cant figure out how to drop the numbers following the name??????

I have the control source of a field set to =GetWinUserName() this returns the user name logged into the pc.

So how do I call these functions?

I'm able to pull users that are logged into our network but our company uses a name that has their employee number as well. So deponding on when they were hired it could be a 5 or 6 digit number. so an example would be JSmith123456 or it could be JSmith12345 so is there a way to drop the...

I have a subform that shows notes entered but if there is more text in the field then you cant see it all. Can I make it so that this field will grow so the whole input is visible or can I make it so when you click on it it opens in a larger window showing all the txt?