Recent content by rcreed1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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