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 strongm 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. rcreed1

    Sorting problem

    If I understand your suggestion it wouldn't work in my case because I have about 13,000 flight numbers to go through. so my columns would look like this source flight number 0 ab123 6 ab 123 7 ab 123 0 ac 12 7 ab 12 7 dc 124 6...
  2. rcreed1

    Repeating a header

    I stand corrected!!!!!!!!!!!!!!!!!!!!!!!!! I read your reply but was not able to try it out at that time. I have tried it and it worked great. Sorry for doubting your suggestion, It was easier than I thought. Thanks again
  3. rcreed1

    Repeating a header

    Thanks for your reply but I don't think that would work. I will try. This may be a better description... Some flight number only appear once, some may appear 10 times. If the heading was part of the flight number then it would appear before each flight. Well say on my report I have 100 rows of...
  4. rcreed1

    Sorting problem

    I have a field (called source) that will have a 0,6, or a 7 as it's data. I then have a field that has a flight number (input as a text since it is comprised of both letters and numbers). Some of these flight numbers appear three or more times once with a 0, once with a 6, and once with a 7...
  5. rcreed1

    Repeating a header

    In a report that I had created it displays the results of a query. We will say the columns are: Unit,Depart area, flight number, and destination. The query places this information sorted in the order I want. The problem is when the report is made it displays the titles for the columns at the top...
  6. rcreed1

    how do you sort by two fields?

    I have a feeling this is an easy one but not easy enough for someone like me. I have created a database to keep track of all of the equipment in my office. (I am in the Army so we have a lot and of course we track it all with serial numbers...). Anyway, we will say computers and printers. I...
  7. rcreed1

    Printing Datasheet view problem

    Hello, Whenever I print information from my database as it gets further down the page the information starts to get printed ontop of the lines, and no longer stays within the boxes created. any help would be greatly appreciated. Is this a printer problem? SFC Reed
  8. rcreed1

    Problem typing in field

    I won't be able to test the computer for a couple of days. (I am in the Army stationed in Korea, and the computer is on another post). However, I failed to mention that when you are typing in the field if you hit the right arrow key the cursor will move and accept the next letter in your entry...
  9. rcreed1

    Problem typing in field

    Hello, I had created this database and made several copies of it to install onto other computers. When I gave a copy to a co-worker we ran into a problem... When it brings up a form and you go to type the information in the cursor does not move. Instead it just types on top of the letter you...
  10. rcreed1

    finding dates within 30 days

    Hello, I have created a database to keep track of soldiers here in Korea. I have a query that finds soldiers who are scheduled to leave (Korea) in 30 days. It uses this... Between Date() And DateAdd("d",30,Date()) It works great but I realize that if that soldier is not erased from the...
  11. rcreed1

    Removing Security features

    Hello, Ok I have been trying to learn access and I made a great database for use here at work. While creating it I thought it would be neat to make a security feature to it. Well now I am using that database to make a smaller database to give to people to use and send me their reports...
  12. rcreed1

    Remove MS Access Security

    This is what I have it doing currently.... When you start your computer you can click on the icon and the database will open. If you do that while holding down the shift key it will show you the menu bar and tool bar. However if you add any information into the database and exit. You can not...
  13. rcreed1

    Remove MS Access Security

    Hello, I have a database I created using MS Access. I had installed security groups and so now it prompts for username and password. I had also made a custom menu bar (no controls). I did leave the hot keys in place so I can still make changes however, now I am trying to make copies of some of...
  14. rcreed1

    If Then statement to set font color

    Thank you, Didn't realize it was that easy. thanks
  15. rcreed1

    If Then statement to set font color

    Hello, I have two text boxes one is named "WARDENS ASSIGNED" and the other "MIN WARDENS NEEDED". I was hoping there was a way that IF WARDENS ASSIGNED < MIN WARDENS NEEDED then forecolor is red else blue? If there is such a code I would also need to know where to place it. Both of these text...
  16. rcreed1

    Sum values in a text field

    Awesome, You have no idea how much you all just helped me. Just so you can possibly get a little gratification... I am in South Korea and this database keep tracks of all the people (wardens) who ensure noncombatants (civilian businessmen, military families.....) are taken care of and alerted...
  17. rcreed1

    Sum values in a text field

    ...but now that I got that to work (actually the only one I was able to get working was the =DCount("[Duty Pos]", "[NEO II]", "[Duty Pos] Like '*WARDEN*'") I was wondering if there was a way I could add a where statement to this. Another field in my database is "MSC" which is a list of...
  18. rcreed1

    Sum values in a text field

    Sorry, I owe you all a big apology, and a thank you. As I was double checking everything I realized that "Duty Position" was changed to "Duty Pos" so now I got it to work. I had shortened the name so it would fit better in the title bar of the spreadsheet. Thank you for your patience and all...
  19. rcreed1

    Sum values in a text field

    PHV, It gave me "# Error" Thank You
  20. rcreed1

    Sum values in a text field

    Sorry, one other thing that may help is the text box I am trying to display this in is called "Text 19" thank you

Part and Inventory Search

Back
Top