Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ctrain

    Drop down lists in word

    Is there a way to expand the drop down list to more than 25 entries? I am trying to make a template for people that don't type. So I need several drop down lists with losts of information. Is there any way to change how big these boxes can be? If anyone has any ideas I would appreciate some...
  2. Ctrain

    Printing complete invoice in order tracking database

    I am using the sample database for order tracking. When I enter in an order, only part of the order actually print on the invoice. How can I get the complete order to print not just the first few lines??
  3. Ctrain

    trying to run saved finds, completely shuts down program

    I have a database of training and I have several saved finds. When I select to edit the saved find I get an hour glass then the program completely closes out and puts me back on my desktop. I desperately need to fix this problem, I would really appreciate any help. Thanks!!!!!
  4. Ctrain

    Need to create a page break within a catalog

    I am using the order tracking template database, I am using the catalog and I have the items grouped by item number, I would like to create a page break between the groups of item numbers. Such as all items with 100 series then a page break before going on to the 200 series numbers and so on...
  5. Ctrain

    Excel enter date if cell is not blank

    Thanks for everything and have a super great day!
  6. Ctrain

    Excel enter date if cell is not blank

    This should be exactly what I need, and Columns C & D work GREAT! This is a sheet where three people enter data into, and we need to know when they entered their individual data, we are trying to catch who is not doing their part in a timely fashion. enter data in column Date inserted...
  7. Ctrain

    Excel enter date if cell is not blank

    Now that I have really confused you, I found my problem, Spelling. This works great, NOW! Can I use this same formula for other columns that need a date entered also. They are all date fields, like this one, would I just need to change the column number in the second If statement. Thank...
  8. Ctrain

    Excel enter date if cell is not blank

    I gotcha, you where correct I had it in the worksheet selection change event. I changed that and it seems to enter the date properly. My only question is the I have other columns that have data in them also and when I go to them I get that same error message, I just select end and it goes on...
  9. Ctrain

    Excel enter date if cell is not blank

    Hi Skip sorry for the delay, I was having computer problems, I have added the code you supplied, I am getting a run time error '42' when ever I click in any cell on my worksheet, it says an object is required. Then it starts the debugger, and it highlights the .. If .Row <= 2 Then I...
  10. Ctrain

    Excel enter date if cell is not blank

    Thank you all for your input. Skip I think the worksheet change macro would be the best. I really need the date to stay as the date it was entered. Or how about this, would I be better off making the user enter the date and give an error message indicating the the entry date can not be prior...
  11. Ctrain

    Excel enter date if cell is not blank

    I am trying to write a formula for when someone enters a date in column C, then todays date will automatically enter into column D. I am trying to switch from lotus to Microsoft, and need to figure this formula out ASAP. Any help will be greatly appreciated. Thanks!
  12. Ctrain

    Converting Approach Database to Access

    I found the directions on how to do this when I try, I get an error message that say the text is to long to be edited. Then it will not do anything. I would rather not have to redo the whole database. Does anyone have any ideas of a quick down and dirty way to do this? Thank you!
  13. Ctrain

    Data Entry Forms Questions

    Thanks for the info, I am begining to understand. I am going to take all of your great tips home tonight and see if I can get it to sink in.
  14. Ctrain

    Data Entry Forms Questions

    I am trying to make a data entry form for a supply database. Since I am a former approach user, I am use to being able to have forms that relate to more than one table. If I am understanding Access correctly, a form can only be base on one form or query. So, am I correct in thinking that to...
  15. Ctrain

    Data entry form problems

    Thanks Ken! You have really helped that problem. I wish I could borrow you for a couple of days. I would have this whole thing up and going. I guess I am going to have to go back to my books. Is there any book that you would recommend that could help me, I am trying to swith from Approach...
  16. Ctrain

    Data entry form problems

    I am trying to make a data entry form for purchases of products. I have made a combo box for my product number now I need a box that will relate to that box and in the next box display the product name. I am new at this, so I guess I am not quite thinking right. Any help would be appreciated.
  17. Ctrain

    Access reports

    I am an Approach user trying very hard to convert to Access. I have my database set up, it is to record orders of supplies, I have the customers, the products and all other tables made, but I have not entered any orders yet. How can I create queries and know if they work without entering data...

Part and Inventory Search

Back
Top