Search results

Thank ya, Thank ya Thank ya ! Duh, I did not even think of the easy way! I guess when I get stuck, My mind goes blank ! :-) thanks to everyone who responded and sent samples ! I went with Doc's idea and it worked fine ! Hope you did not have to much Mardi Gras ! My head still hurts after...

Hi you all, I am developing a database to track employees. Basically to see if they are at work or at home. We have approx.190 employees. we work two shifts of 7 days at a time. Lets call them A and B shift. What I would like to do is have an area that todays date is entered. Once the...

Hey you all THANKS ! Just wanted to drop all of you guys a big thank you for the help. Once I realized that I needed to use the record ID instead of the employees name it worked like a charm. to all of you have a happy and safe holiday season. Thanks Andre':)

Hi, I have a form that has records on employees training. I have another form where I would like to press a button and select a specific record sorted by employee. On the second form, I have a unbound combo box to pick employees names. After i pick the name, I press the macro button to open...

I would like to do this.... Using a macro. I have made a macro using the macro wizard to open form#1. and sort off of the field name employee#1. I have put the following syntax in the where box of the open form command [employee#1]=[Forms]![form#2]![employee#2] all it brings up is form #1...

Hi, I have a form that I put records of employees that have certian training. I also have a startup form on my data base. I would like to place a combbox on the startup form that list the employees names. When a person chooses an employees name from the combo box, I would like the other...

No Prolbem Access 97, we are switching to office 2000 in about 6 months. We are always about 6 months behind the world.

Tried a different way Hi, i put the string as you described in my SQL statement on the combo box. This is what I have so far. I see the combo box, In it, is the list of wells. I choose a well and all I get is a report with the first well in the query with all of the information entries for...

Nope, that did not work. I tried as you said. But it did not work. What happens is that I have the combo box listing all the well numbers. As I choose one, the query starts running and a criteria box still comes up. I would like the query to choose all records associated with the well...

Hi, I have a report that shows information on oil wells. This report is generated by a query called "print report by well". when I run the query from a button on a form. It opens a criteria box to input a well number. Thus, generating the report by well number. We have 145 oil wells in our...

?? Sorry, I do not understand. What I would like the query to do is to print a report based on the well number I would select from a combo box. Please explain a little more. Thanks TM

Hi, I am making a query to pick from a list. I set the criteria to look up by well number. when I run the query, I get a box asking for a well number. How can I make it open as a combo box to list all the well numbers I have in a well table????? Thanks Trackmedic

I have an invoice form that pulls items from an inventory table. On the form, I have a field that reflects quantity sold. If I have ten of an item in my inventory table ex: 10 coffe cups. and I sell 2, how can I subtract 2 coffe cups from the 10 coffe cups that I have? Any help would be...

Hey People, I have revised a database that I was working in and I would like to copy information from the old version of my database to the new version. How do I do that??? Thanks trackmedic

Hi Ya'll, Isn't there a way to "strip" down a database so it can run on a machine without the Access program installed on it? Thanks in advance!!!

Tried That!! Thanks for the reply. I have the syntax right. Where I'm running into the problem is that the choice is showing up on my form but not transferring to my table. Thanks

Ok, here is another one to pick your brain. I have a form that has a combo box that looks up cargo stored in a cargo table. I have also made this combo box able to have information entered into it freehand. When I choose an item in the cargo table through this combo box, I want the serial...

Thanks!! I feel so stupid. I thought the column widths was just to hide or show columns. Makes sense now. Thanks for all your help !!!

Hi, I have made a combo box on a subform. This combo box displays two columns from a table. When I pick the combo box, the two columns show up but the first one is scrunched up and hides some of my data. The second column is to wide. How do adjust the columns so I can see the results from...

THANKS !! Thanks for the info. It opens the directory, but, it keeps it minimized on the bottom of the screen. Just need that last step to keep it viewable without having to go to bottom windows bar and open it up. Thanks