Search results

Let me know when you find the solution. Sometimes this occurs when I am changing the design of a form. I think it has something to do with the dll files. Just my guess

I would try SQL as an auto email and link it to the db

could not even said it any better than that

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...

Reltub, ss you can see there is alot of great help here. I won't chime in since you are getting alot of hints on how to build your db.

just my 2 cents, I have a complete database in just doing this. I have over 10 years invested in it. So if you need any aditional help please let me know. This is the place where I learn it all. Great group of people here.

It work like a charm Thanks Bob

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...

jdraw, thanks for the quick reply. I need the check box showing its "check". If the invoicenumber field contains final, make chkbx6 shows a check mark

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?

Pat, thanks for the reply. I found a work around finally after a few hours of thought and testing. You are so right there is no way to reference a specific row. I had to add a another text field on the main form, to make it work.

Galaxiom, sorry i have not got back to you. I was pulled off to another fire. Still fighting this, My subform is named tblPayEstimates One of My field is named flduser Everything works great with the above criteria =[tblPayEstimates Subform].[Form]![fldUser] Pulls everything correct. Now...

Gizmo, thanks for the quick reply. Maybe this explains a little more: To reference a value in a subform, use the following syntax for the text box's Control Source property: =[subFormName].[Form]![ControlName] where subFormName is the name of your master subform control, and ControlName is...

I added a text box on my main form. I have to other parent names in a subform that I would like to add to my main form. I have this working just using one parent name "dtdrec" that is working. How would I add "flduser" and "fldstuff". =[tblPayEstimates Subform].[Form]![dtdrec] I hope this...

I have not a clue working with excel. Here is what I have so far I have a file saved as .xlsx so when I added a macro I had to save as a .xlsm. When I want to update the .xlsx file, I have to to all the steps over again. My question is can I export a worsheet (.xLsx) to a worksheet in...

Pat, thanks for chiming in. Ok, now I got it to work. My next step is going to be a difficult one. I don’t know if I can even do it. I have attached a PDF trying to explain what I need to accomplish. I figure it was a lot easier to show visual and try to explain in writing. Here is the...

Thanks for the quick reply, I sure have.

I have a report to which I am trying subtract 2 text boxes (TotalRec and subtotal) In my Detail I have a text box with the following in my control Source: Name: TotalRec =IIf([Copy Of QryContract Aging Report subreport].[Report].[HasData],[Copy Of QryContract Aging Report...

For the Report Gurus, this should be a easy one In a report How do I subtract Group footer from Report Footer? For example: In my Group footer I have Items that are going to be expiring in a certain month. In my Report Footer I have a total of all the items. So each month will subtract...

Rain, its working only when in the textbox reads "Final", but if the textbox reads "12345 final" its not working, its kinda back to square one again.