Search results for query: *

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

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

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

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

I have a database that has a field called "duty position". On my form it is a list box and has the choices: Primary Rep, Alternate Rep, Primary Warden, and Alternate Warden.I am hoping to add onto the form a box that shows the total number of Wardens (both Primary and Alternate). My second...

Hello, I have started created two databases for my unit in the Army and now I am trying to tie everything together. One database has a list of names of all the people who are assigned positions for NEO (Non-combatant Evacuation Operations). Their titles are 'NEO Wardens' and 'NEO Repesenatives'...

I have another post on here asking how to email a current page of a form. I think through experimenting I figured it out. The problem is it will only send it in the style of an excel form. I am wondering if there is a way to email a page of an access form so when it is received it looks just as...

Hello, this may be an easy fix but I am a newby so bare with me... The labels to my fields have long titles. When I view the information on my table or in a datasheet view the column title is cut short. I can expand the width of each column but then the column is 3 inches long and the data...

Hello, I recently figured out how to print just the current page of a form by setting up a macro. I was wondering if the same could be done with sending that page as an email. In other words I have a form that every month a unit will be adding a page to. I want to have a command button that...

In the expression builder I need to take a value (we will call it 'X') and.. X /15 = take this value and round it up if it is not a whole number and *2 how can this be done in the expression builder? Thank you SFC Reed

I had already done this but I don't know how to do again and I can't decifer my actions...to repeat it. I have a form that when you open it shows a bunch of command buttons. They are labeled with months and years. ie. JAN 2004, FEB 2004.... I hope that when you click on a button it shows you...

Hello again Access Experts I just about have my form completely user friendly (thanks to you all) and I will need to make about 20 copies of that form, each with slight variations for each unit. I was wondering, for when I get there what is the best way to make a copy of a form so both the...

First I would like to say thank you to everyone who assists those of us with questions. This is probably an easy one but greatly important. I have a form that has command buttons for each Army unit that is covered by the database. When the choose their unit (we'll say 17th AVN) it takes them...

Hello, I needed to know if this is possible and how it could get done. I am new to access so it can not be answered with too much detail... My question is, I have a database that stores a monthly report from 35 units (I am in the Army. So on the form to enter the report information I have added...

If I have a combo box that gives you the selection: 1/11 , 2/11 , 3/11. (assuming these are text values, Army units)and if you select 1/11 the next combo box gives you the selection: A company , B company, D company. However if you selected 2/11 the next combo box gives the selection: E company...