Search results

P.S. It keeps kicking the string above back at me with errors.

I doubt it...I am probably the one who missed it...still green behind the ears here. So...how would you format the currency to make it multiply and output like 000000?

Thanks, I will play with that. Any ideas on the currency issue?

Second problem...the service descrption MUST BE 40 characters so if the service was cleaning how do I tell it to count the characters in cleaning (8) and then add 32 spaces before the next field?

K - I think I got it but the currency is outputting 000860 instead of 086000 and I tried to copy/paste the other code and it isn't working.

That helps ALOT but can I reserve the right to ask more questions? *grin*

One of our key customers (GE) has demanded that we begin to submit our estimates in their transmission 160 character format. Basically it it a txt file that looks like this all on one line. 1ABCDWXYZ0502EST TEST123456T050208654321C 00010851803098518031 000000E 0000000000000D...

Thanks...I already had that one...I was using it for my base. It doesn't create records in multiple tables though and I have no clue how to do that. I need to create a form with a multiselect list containing a list of the employees and a box for the date and for holiday hours. I need to be...

Thanks! That is the exact DB I had a copy of and was playing with......it is not updating 2 tables though....this is frying my brain! Not that it wasn't already!

Hi there. I am trying to create an append query that will update employee time cards for holiday hours without having to enter each time card individually. * I have an employee table which has the employee id, first name, last name and so on. * I have a timecard table which holds the...

I am still new to Access. Where to I go to check for the object reference? The problem happens when you are in the access form and you click the button to merge with word. Where do I go to do a decompile? But it only happens on the one PC and that just started. It works fine on all the...

I have a form that merges with a word document and has been working just fine for a couple of years. HOWEVER.... 1 (only 1) of the computers in the office all of the sudden started getting this error when trying to run the merge. ("Run-time Error 2147024770 (8077007e) Automation error - the...

Is there anyway to have a list of reports in a drop down format? I have a screen with about 14 buttons on it and it would look so much nicer if I could figure out how to do that. Thanks for any help.

Sure did...first thing. Didn't change anything.

Hello, I have a large database I set up and we have been using fine for a couple of years now. All of the sudden, anytime Find Record is clicked and the value is entered, I am getting the following error, on ALL forms. Nothing has been changed in the DB itself and it worked GREAT before. The...

Didn't work. It displays on some but not others. Any other ideas?

Thanks for your response. Sorry for the delay. Had surgery on Friday. Back at work now and trying to fix the problem. I have done none of the above nor do I have a back up. It is so wierd. It is storing the data in the table & even printing it out on forms/reports but after I add a new...

I have no idea what is going on. I have a tabbed form with a combo box to select customers. I have a combo underneath it that updates to select the contact once the customer is selected. It has been working a-ok for almost a year now but all of the sudden it works but doesn't save the contact...

*giggle* Do you have time for 1 more quick question? How do I create an on update event that make Access check the total of a form against the balance on a subform and popup a warning form if they do not match?

WOHOO! THANKS SO MUCH! It worked!!! *great big hugs*