Search results for query: *

Thanks everyone! Changing the joins around was the right thing to do. I tried the code as suggested by PHV and it seems to be working. Thanks for the quick response!

Hi all, I have a query where I want to list all of my processes and the number of completed tests per process. If no tests have been completed, I want the process to be listed with a zero in the column on number of tests completed. My query so far: SELECT tblScopeProcess.Process...

Hi all, I am attempting to create a dashboard that reports back the status of my project broken down by process. I have a form built for my startup page to display the following info: # of controls # of tests completed # docs outstanding # remaining Process First, I have a...

You got it! That was the issue. Thanks for your help! Derek

Hi all, I have a form that uses the cascading dependent combo boxes concept (choices in txt2 depends on txt1; txt3 choices depend on txt2, etc.) Everything is working great so far. Then I decided to make this form a subform of another one to allow me to filter and navigate through the records...

Hi there, I copied a subform and renamed it as I needed to store data entered from different phases of the project into separate tables. I changed the recordsource of the "new" form to my 2nd table. However, when I do that, Access also automatically changes the recordsource of the original...

OK, let's say I cave and go the VBA route. I have found the option used in another post where in the Print event of the report's Detail, the designated vertical lines grow to the size of the biggest field's height. It still leaves me with a slight gap and in some records the biggest field...

I am attempting to make a report in Access that is very similar to an Excel spreadsheet I was using previously. The challenge now is creating lines that would simulate the idea of cell borders in Excel. I've tried a couple of different ideas. First, I looked at the border properties of the...

Hello, I have a query where I am calculating a new field from the SUM of some other fields. This result coupled with a value from another table would be used to return a value (should this be in a table?). Here's an example: qryRiskRating Select (tblRisk.Category1 + tblRisk.Category2 +...

Hi all, I was wondering if it is possible to use JavaScript for the following scenario: When a user clicks on a link, I want it to prompt for a password (there is actually only one valid password, so I shouldn't need db connectivity). If the user enters the appropriate password he is sent to...

Hi all, I have two tables - one is linked to a SQL database and the other is my local Access version. I need to create a form that will allow a lookup of the available info in the linked table to ease data entry in the local table. Example: I have employee info for a parent company. These...

Hi all, I have a table that contains information about meetings for my team including date, start time, end time, location, description, etc. I want to create a nice looking monthly calendar (i.e. grid with boxes format) and populate it with information from my table. Does anyone have ideas...

Hi Rob, Yes, I actually tried that first before going the code route. So, maybe that implies that my query isn't returning a null value but in fact returning spaces? Any other ideas would be great! Thanks! Derek

Hi, I am creating a report where under a column with a header titled people, I am pulling in information from 3 fields in my query. I have actually sized the control so that each field would come on a new line. However, occasionally one of the fields for a given record will not have data. I...