Search results

I found this piece of code that might work. I place this code in the Before Update 'make sure you have two names entered first if len(txtfirstname)>0 and len(txtlastname)>0 then if nameexists(txtfirstname, txtlastname) then call msgbox("The selected name is a duplicate ...") cancel=vbcancel...

I have attach the sample db. On the Create a New Batch forms. I do not want the user to choose duplicate names on one record. See 1st record. I have to have drop downs for all the individual employees, due to different time’s different pay as well as different employees with a combination...

You are right Brian, I should have look more through the form

I have a form for Due dates based on a date received. Real simple: Field is reads: =Date()+5 If it lands on a Friday, I need to add 2 more days If it lands on a Holiday add 1 more day Have not figure out if a Holiday lands on a Friday, then I have to add 3 more days. I was messing around with...

In a Single view, you can use the =Sum([your field]) to get the sum value. But is it possible to use it in a split form?

I thought I might try a differen't approach for a little bit more of a understanding: In my query I have the following: Strrttime Endtime Minutes: DateDiff("n",[Strttime],[EndTime]) Total Hrs Work: [Minutes]\60 & Format([Minutes] Mod 60,"\:00") PayAmount...

I have done this a thousand times never had a problem before. Trying to get a sum on a subform. The field is called PayAmount. In my query it looks like this: PayAmount: Round(CCur(Nz(DateDiff("n",[Strttime],[Endtime])*[AHrRate]/60,0)),2). In my subform I added a text field and added the...

OK guys, I finally got it to work. this is what you all were trying to explain to me. First I had to add another field for minutes Minutes: DateDiff("n",[Strttime],[EndTime]) Then add Total Hrs Work: [Minutes]\60 & Format([Minutes] Mod 60,"\:00"). Thanks to the both of you for helping me on...

Thanks all for the quick reply. I am still not getting the result that I am looking for. I pasted the following code into the qry 60*((DateDiff("n",[Strttime],[EndTime])/60)-DateDiff("h",[Strttime],[EndTime])) And I get the -30 which is correct, but how do I get it to where it reads 6hrs and...

Very Simple Query using the date and time function Trying to show the total hours work. My result is: Start End Total Hrs Work 5/3/2011 9:45:00 AM 5/3/2011 5:00:00 PM 7 It should read: Start End...

I received a error message. I know its me. My "formname" is "tblPayEstimates Subform" and its in a subform as well. My objectname is located on a different drive C:/ob/. So the bottom line how would I write the correct code. Thanks

I just use the macro "send object"

Paul, see the attach in what I am referring to. Also thanks for being so patience with me.

Paul, thanks for the quick reply. Ok let me try this again (my fault). I want to send an email out. I want in the subject line of the email the field color to end up in the subject line. Here is the bottom line. IF I have three fields in my form, I want those to show up in the subject line...

I have accomplish everything in sending a object in a email. Now for the twist. In the subject matter, I woud like to include three fields. Is there a way to where I can do this? For example, lets say the field is call color and in that field I have selected Red. I want red to show up in the...

Found many answers on this subject. Looking for the simple fix. Has anyone ever just had to change the ODBC refresh interval (sec). I will attach my error message for the ODBC and the screen shot of the ODBC refresh. Thanks

FYI, I just found out that using Frontpage I can import the db into a Webpage, which then I can use the free host. So far no problems.

aprpillai, thanks for chiming in, checking all of my options here. Bob, my man glad you chime in on this. I can't tell you how many times you got me out of jams. So it sounds like I can't just upload the db on a site and use it from there. Just throwing this out, I did find site where you...

Have no clue on the best way to do this. I have a db and I have 3 users that need to update the db. These users live in CA,TX and WY What is the best way to do this. How to a Website? How to a Server? Gee, it sounds so simple even when I type it in. Thanks

Guus, Sorry I have not reported back as soon as I should have. I have SQL running as my BE. I was adding new fields to previous tables and adding new tables as well. I refresh my tables where I added the new fields, then used the wizard to add the new tables to the BE. Then I noiced I added...