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...
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??
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!!!!!
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...
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...
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...
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...
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...
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...
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!
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!
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.