Search results

Hi, I have a relatively simple question. I have a field called "proposal phase" in my projects table. Sometimes the field contains numbers that indicate the particular phase of the proposal and other times there is a blank to indicate that no proposal was written for the project. How do I...

I have a relatively simple question. I have created a report with several fields, one of which is a Project Manager field. What I want to be able to do is this: If there is no Project Manager assigned to a project, instead of having a blank field if no project manager is assigned, how do i do...

thanks! Thanks for the help. Seems like in Access I can't hard code a relationship and then on the same query, use the relationship building (drawing an appropriate line between fields). Your suggestions have helped solve my problems. Many thanks

I have a problem. I want to create a relatively simple form to generate a relatively simple report. The form I want to create contains a dropdown menu (combo box) that lists all our clients. What I want to do is allow the user to select a client from this combo box and then click on a preview...

here is the design view screen capture here is the design view screen capture thanks,

here is a screen capture Attached is a picture of my front end interface. As you can see, in the client combo box, the last two entries after Zador Construction Services is Kinder Morgan and, Atlantic LNG. I can't seem to sort it so that when I add new entries these get sorted alphabetically...

Hi, I have what seems to be a simple problem but I can't seem to solve it. I have a form (report form) that has a drop down box that lists all my clients alphabetically. The form's record source is from a query that combines multiple fields from several related tables. The purpose of this...

thanks! it's Brilliant!!! Thanks for all your help!!

Thanks! Works like a charm. Is there a way to put the # symbol and a period after each numbering? i.e. #1. #2. #3.

Hi, I have a report that generates a list of project numbers along with a project description. I want to have each project numbered in the report. For example: 1. file 000456 - Bakery shop financials 2. file 000123 - Grocery store financials 3. file 000598 - Department store auditing 4...

Hi, I have a form that contains a dropdown box that list 8 project managers. The form also contains fields where you can enter a date range. The idea is to select a project manager and date range and have the form generate a report of all activity for that project manager with the date range...

Thanks for your reply. I think i should be more specific regarding my problem. I am trying to add a Project Manager to a Project File via a combo box. I have a main form called CLIENT_COMPANY (name of company, address info, url etc) and a subform called PROJECTS which contains my project...

Hello, I have been stuck on this problem for days now. I have a PROJECT form which contains a subform that contains information on the Project Contacts and the Project Manager. I have about 1000 projects and 10 project managers. What I want to be able to do is to select the project manager...

I have a problem adding fields to a table using a combo box. I have a bunch of project files that each need to be assigned a project manager. There are only 10 possible project managers. I want to enable it so that I have a combo box where I can select a project manager for each project...