Search results

Try me.refresh in the after change property of the record you are adding... Maybe?!

Go to the properties of your combo box, click on the data tab and then set your bound column. Sonja

Pat, thanks for the information. I tried to do this, but I am unsure which fields to use in the other table. I can use ProjectID and EmployeeID, but in your example, there is a BookingDate - I don't have such a field I can use. I will be assigning more than one employee to a project, and each...

I have a form which is used to input information for projects. I want to put a list box on the form that shows all employees. I want to be able to click on employees to select them, them move them (with the click of a button or by double-clicking them) to an empty list box (All employees that...

Pat, me.undo works if the record is not saved yet, but how can you clear all controls when the record has already been saved? Sonja

Steve, I tried your code, but the system comes back with an error message saying that it cannot apply a value to c. Sonja

Thanks Jack, I will try that. Sonja

I want to be able to have a form, where a certain set of users sees only the screen to add new records - and after they have added a record, they can only see those he/she has added. Any ideas?

How do I go about sending an email notification when a new record is added to my form? Any help is greatly appreciated.

Did I post a stupid question? Or did I not formulate the question correctly? Or is there no way to do it? Please advise, I would be more than happy to provide further insight.... Thanks, Sonja

Wedding Database Hello there, if you let me know what level of experience you have with designing an Access database, I can give you some pointers based on that info. Don't want to bore you or overload you. :)

I have created a database and a nice form with some VBA in the background to do certain things. Now I am told that they want the form to be a dynamic form that can be accessed from each employee's browser window. I have looked into the data access pages, but they can only be based on tables and...

Awesome - Thank you so very, very much! I have been headaching about this for a while and this forum is really wonderful. I hope I can return the favor sometime.

Rich, Thanks, that worked, I had the task table in the overall query and removed it - now everything I want to show up does. However, when there are not tasks, there is a blank space on the report for where the task would normally appear. Any way to have the subreport be invisible when no...

I have tried that as well. The problem is that if there are no tasks, the Objective will not show up. I just tried it again to make sure - I have one report, the Objectives are in the detail section and the task are a subreport in the detail section as well - if there are no tasks, the objective...

There will always be a Fundamental Objective, there are one to many tactical objectives for the fundamental objective and there are one to many task for each tactical objective. What I want to do is show the Fundamental Objectives, show the tactical objectices below AND if there are any tasks...

Thanks for the answer David R. That sort of worked, however - maybe I need to outline a little better: I have one Fundamental Strategy that has many Tactical Objectives, and each Tactical Objective can have many tasks. Now, if I use the code you gave me, both the Group Header1 and the detail...

OK, I have a report that has tasks and subtasks. When I set up the report with subreports, then if there are no subtasks, the detail section on the report still shows up. I can use the code listed earlier in this thread: If (I don't want to see detail) Then Me.Section(acDetail).Visible =...