Search results

Thank you for responding so quickly...It worked!! Noreene

I have a form that I key in the truck Id and it pulls in serial number from another table. But sometimes I only have the serial number and I need the truck Id...so, I put a command button on my form named Find. When I click the button, I want it to give me an input box that asks "Please enter...

HOW SIMPLE!!!! Thanks so much Noreene

Another similar question I have a similar request...I have a macro that prints 5 reports which works fine...the only thing I am having trouble with is if the report is empty, I want that report to close without printing. I know this is so simple and I have tried several ways but I just cant...

Thanks to both of you IT WORKS!!!! Exactly what I needed... Noreene

I have imported info from Excel into a table in Access...But, the name field has last name, first name in one field and I want it to have last name in one field and first name in next field...I know how to concantenate first and last name but how do I UN-concantenate? Thanks for your help...

This is probably not helpful...but I know that if you open your form with docmd. gotorecord,,,acnewrec then you're only going to see the records you have entered at that time...Once you close the form and open again, it wont show previous records. Does this help at all? Noreene

Thanks GizmoT You certainly sound educated to me!!!!!

Okay, just one more question. I am curious as to why there had to be Nz added before each field to get the sum... Why would it not work by using =sum([vac] + [sic] + [hol])? I just wanted to be clear on the difference. Thanks, Noreene

Ya'll are the greatest thing since sliced bread!!!!! It worked, and I thank everyone that helped me... I LOVE THIS FORUM!!!!!!!!!!!!! Noreene

GizmoT Your report is similar to mine but I am trying to combine those 3 fields into one field...Can you try to do that on your db and see what happens? Storming_norm I tried your formula and it gave me the same number of hours in every dept. And I had running sum set at NO. Do you have...

GizmoT I still cant get it to work..I put my fields in the detail section plus I put the individual fields (vac, sic, hol) in the detail section also. It shows all values for those fields under the appropriate headings but it will not total those fields in the unbound box called Other. It is...

Thanks GizzmoT I tried that and no values appear in the Other textbox plus I put the fields in the deptfooter and the values show on the report. Other textbox is completely blank....So, I know these values are coming into the report, but they come under their own heading not totaling in the...

I have a crosstab query that has column headings Reg, OT ,Vac ,Sic, hol, brv and the hours for these fields are the value. ON my report I want to show REg and OT in their respective columns which I can do, but I want all the other headings thrown together (sum of the hours) in an unbound...

You guys are so great!! I was almost ready to pull my hair because I had my macro to output to all working and then decided to go under startup and hide the database window...Well, it would work sometimes and sometimes it wouldnt... So, then I showed the database window again and it started...

THAT WORKED GREAT!!!!!! thanks to both of you for your help... I LOVE THIS FORUM!!

Thank you for that code, Chris. But, I dont know where to put the code since I already have my macro tested and running correctly...if I change everything I am afraid of messing up what I have already... Can I get some ideas? Thanks, Noreene

In my database, I have a macro that outputs a report to our server in rtf format...the output works fine, but it shows me a preview of the report in Word and I have to manually close the Word application each time...This is for many users on our server so I dont want them to have to close this...

Thanks Bob, I have downloaded your app and it will certainly help me...This forum has certainly been a life saver for me, too... Fizzio, Even when I put in your code, it still asks for a workorder parameter value......WHY!!!!! Of course, when I just click OK it trys to print all records.

Please could I use your code or would you tell me exactly what I need to do? I would deeply appreciate it..That sounds like exactly what I need. Thanks, Noreene