Search results

As far as I know, you can pass a form to a sub/function as a parameter. Are you 100% sure you are passing the right form name? RichM

Well.............. it sounds like the cast/roles may be not what I described. That's OK, I was just guessing. Any way, it looks like you've got it. RichM

Newman/nobbie, I think it's kind of like this: The "Line Operator" goes to some Access form and selects the Line from a combo box and the Problem from another combo box. The Operator clicks some "Add" button and a new row is created in the Problem table. The Technician arrives at the Line...

Newman << Hi RichM, You got me confused here... Where is my mistake? How could you know who worked on which lines if there has been no problems? >> I think we were replying at the same time. I would use ProblemID and TechID in the junction table because we probably want to know which Tech...

You wrote << One tech can possibly, not usually work on more than one line each night. Also one line can be worked on by a number of techs. >> That's the classic "many-to-many" relationship (illegal in several states) You need a junction table to relate Techs and LineProblems. The junction...

How about: "Honey, would you like to.................. for our anniversary"? I need a good answer for this one ASAP. Thanks, RichM

You wrote << Is it not possible to pass values from a subform? I would have thought so but it doesn't seem to find or recognize the subform? Any ideas on something I'm overlooking? Thanks for any assistance. >> It's not too clear from the code what you are trying to do. If you have a subform...

You wrote << I do not want anyone changing information in the database, except me or another person I train. Is there a way that I can give only switchboard access to the office and maintain total control of the database myself? I was thinking about maybe making this web based, how would I go...

Go to www.mvps.org and then go to "AccessWeb" page. You will find a sample. RichM

Jurgen, I do not have a direct answer to your question. I suggest 2 alternative approaches: 1) Make and save a query. Put functions to get values in "criteria" cell of the query. Make a module of "property" functions to set and get values from user-entered values from the form. Do this in code...

The "Fields" collection is the default collection of the DAO "Recordset" object. Therefore; myRS.Fields(0).Name is the same as myRS(0).Name RichM

<< I sthere a way to reference it by its index?? for instance does the first field in a recordset always have an index of "0"? >> Yes. RichM

Gee Mike, Care to give us a clue about what you changed? RichM

Create an "Update" query. Drag the new column name to the grid. Put zero in the "update to" cell. Run the query. RichM

Then don't use &"'" RichM

Wrong ===== StrSQL = "SELECT * from EmployeeInfoTbl WHERE EmployeeInfoTbl.Employee = Forms!LoginForm!employee" Right ==== StrSQL = "SELECT * from EmployeeInfoTbl WHERE EmployeeInfoTbl.Employee = " & "'" & Forms!LoginForm!employee & "'" RichM

This is what you do: 1) open the FE data base 2) go to the Tools menu 3) select the Security item 4) select "User and Group Permissions" 5) select "Database" from the list box 6) select "Groups" from the radio button 7) select the group named "Users" 8) uncheck the option boxes for "Open...

Mike, See Access Help for the "Column" property. You will find explanation and examples. RichM

To call a subroutine or function from 2(or more) forms: 1) go the the Modules tab 2) create a New module 3) make a "Public" sub or function 4) call from any form HTH, RichM

Ole was on his death bed. He turned to Lena, his wife of many years, and said: "Lena, when I'm gone I hope you will remarry". "All right Ole, I will". "And Lena, it's all right with me if your new husband lives in our house. And I guess it's all right if you and he sleep in our bed. But...