Search results

  1. D

    Very Confusing & HUGE Challenege..need help.

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

    Very Confusing & HUGE Challenege..need help.

    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?
  3. D

    Very Confusing & HUGE Challenege..need help.

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

    Very Confusing & HUGE Challenege..need help.

    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?
  5. D

    Very Confusing & HUGE Challenege..need help.

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

    Very Confusing & HUGE Challenege..need help.

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

    Very Confusing & HUGE Challenege..need help.

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

    Append Query out of my league...

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

    Form question

    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!
  10. D

    Append Query out of my league...

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

    Automation Error

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

    Automation Error

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

    Drop Down Report List

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

    Find Record Problem

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

    Find Record Problem

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

    HELP! Company DB acting up all of the sudden!

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

    HELP! Company DB acting up all of the sudden!

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

    HELP! Company DB acting up all of the sudden!

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

    Sum of IIF

    *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?
  20. D

    Sum of IIF

    WOHOO! THANKS SO MUCH! It worked!!! *great big hugs*
Back
Top Bottom