Search results

  1. Joe8915

    True Story....

    A lady in a faded gingham dress and her husband, dressed in homespun threadbare suit, stepped off the train in Boston, and walked timidly without an appointment into the Harvard University President's outer office. The secretary could tell in a moment that such backwoods, country hicks had no...
  2. Joe8915

    Can you answer these 4 questions

    4 Simple questions from a CONCERNED CITIZEN!! This really should get your "gray matter" to churning, even if you are an Obamafan, I wouldn't want my hero to be made out to be a liar, would you? just kidding OBAMA is not nor will he ever be my hero...a real clown maybe!!! For all you...
  3. Joe8915

    Where is all the Obama Supporters now!!!!!!!!!

    Have you ever notice when he was running all the movie stars, were all over him in every way possible. Now you don't see any of them even around him. Its like they buy the ticket to a movie but never go see it. This guy is a disgrace to the United States, and just to think I thought Carter...
  4. Joe8915

    Royal baby finally arrives

    Does anyone care?
  5. Joe8915

    Reserve error 1104

    This error just pop up for the first time. I have compacted and repair db. That did not help. I can log off db and come back in and everything seems to be working ok. Then in a few minutes it pops back in. When the error comes in none of the macros work. The db is split, using SQL as the...
  6. Joe8915

    Copy and append

    I am trying to accomplish this in a macro. I know I was able todo this in older versions of access. I want to get data from a query and paste and append into a table. I thought would be a real easy task. When I started to design the macro this is far as I got: Qry Name: GetData Table Name...
  7. Joe8915

    Report Footer dividing 2 fields cannot get the correct figure to show

    Field Name A =Sum([Piece]+[Summary detail]+[PartialSum]+[Summary Partial]+[WVSum]+[Summary wv]) = $53.53 Field Name B =([ClockHrs]) = 8.50 I want to divide field B into field b It shoud come out to read 6.50 I have tried everything but cannot make it read 6.50:banghead: What in the heck is...
  8. Joe8915

    2 Forms 1 subform "After Update" event

    Good morning all, this is what I have: Main Frm Sub form Form= FrmEmployee Hire 1 Text key called Text1 Need to update the Sub form from FrmEmployee Hire I used the “After update” Event in the main Frm and it work great. What Event would I use from the FrmEmployee Hire to update the sub form...
  9. Joe8915

    Populate field from a Main Form to subform field

    There are 3 words that are dangerous a staff meeting: Can you do? Is this possible Why can’t we Then why do I say, “It most likely can be done”. This is what I am trying to accomplish. I have a form with a subform. I would like to populate a field in the subform, from the Main Form. The...
  10. Joe8915

    Combo box and subform issue

    I have a combo box located in the form called “Frm Add/Edit Payroll”. The combo box is “EE” What my problem is I do not want to have the user be able to change the name in the combo box once the records have been created with the correct data using the subform. I tried changing the...
  11. Joe8915

    Can not get one field to Total in my Report Footer

    Anyone like to take a stab at this one. It must be so simple, because I cannot find out where the problem sets. I think I need a fresh set of eyes.
  12. Joe8915

    Question Should be Combo Box 101 ......issue

    In my combo box I have several names. When I select a new name, I should get a new record. This is so simple; I just can't put my hands on it. I have attached the db. Please tell me what I am doing wrong. Thanks for taking the time to review.
  13. Joe8915

    IIf statement with ending result

    I have a text box with the following statement: Summary detail: Sum(IIf([dacthc]=0,Null,Fix(100*[dqty]*([dstdhc]*[drate]/[dacthc]-[drate]))/100)) My question is, if it meets the criteria, is it possible to make it default to a "0" in the field. Thanks for taking the time to look and review
  14. Joe8915

    Overflow error 2950

    Can anyone point out where I can correct the overflow error. My thought it has to do with the WV Fix. This all came about trying to convert a excel formula to access. I attach the sample of the file from excel. I put it in a word document, but I think you get the idea what I trying to do...
  15. Joe8915

    Form Footer issue

    How do you move the Form footer close to the Form Detail. When form comes up in a display, the footer which has calulations appears to be at the bottom of the form. I have move the footer as much as I can to Form Detail. Please see the attach Thanks
  16. Joe8915

    Question Excel formula convert to access

    This should be a no brainer for some people. I am trying to convert a excel formula to access. The column for h/c adj$ reads: =IFERROR(TRUNC(D1024*(F1024*G1024/E1024-G1024),2),0) Col: D1024 E1024 F1024 G1024 qty: act h/c: std h/c: rate: h/c adj$: detail: 14.00...
  17. Joe8915

    Several subforms need to do a summary

    I have several different subforms, I have field adding several Textfields in the Form Footer. Now I need to combine all the subforms into one main form and do a summary. I know you can do it in reports such as using the "HasData" method. I could not make it work. Any ideas on how I can make...
  18. Joe8915

    So how do you feel now !!!!

    http://www.bing.com/videos/search?q=Parasitesaredevouringthehostculture.wmv&mid=5D853E97868BD27B50C05D853E97868BD27B50C0&view=detail&FORM=VIRE5 Now is there something that I am missing here? Only fair to warn you, do not watch on Modays or if your boss gave you hard time for not working hard...
  19. Joe8915

    Simple Iff statement problem

    I have a field called Invoice Number. If the Invoice Number contains the word final, then display a MsgBox "do something" this is what I have so far. Private Sub Invoice_Number_AfterUpdate() IIf = (Invoice_Number) <> "final" MsgBox ("then do something") End Sub Of course I get a error...
  20. Joe8915

    Question Iff statement

    Contains 2 fields chkbx6 InvoiceNumber I have a chkbx, I need to have it check when another field contains final. In my querry this is what I have so far: Def6: IIf([InvoiceNumber]<>"final","check") As you can see this works to make it read check. But how do I make the chkbx to be check?
Top Bottom