Search results

I also realize that I could just copy past the subform query and put criteria referencing each main form, and then also build 3 separate subforms that point at the queries, but I am trying to keep things a bit tidier.

The record sources are 3 queries that are pulling data from the same projects table. I only need certain fields for certain projects, so i only query the fields I need. On top of that, I am filtering on the project type. I have a subform that shows ALL other projects that a company is...

Hello, I am going to struggle to describe what I am doing, but here goes: I have 3 forms that all use the same sub form. The 3 main forms show 3 different project types, where the sub form shows what other projects that a company is engaged with. Rather than create 3 different queries for my...

I should mention that I don't really know where it's failing. I tried stepping through the code, and the error comes up in the error checking section. I do know that it is this line: strFieldValue = Nz(rs(strFieldName).Value, "") It looks like I need to somehow avoid certain field types...

Hi All, I found this code on a website that uses a form to search all tables in my database. Problem is that when I click "search" I get an invalid argument error. I am guessing that there is a problem with my SQL string. Missing space? Missing quotation marks? etc etc.... Anyway, here is...

Yup, this is pretty much what happened to me. I had very little data in my developement database, therefore the system wouldn't crash. It was only when I tried to run that query on my master database that it would start crapping out.

I had this happen to me because my query was joining on text fields. Not really sure what I was thinking when I made that one...

I'm not following. Do you want the second box to update? If I am understanding correctly, you want to update the second combo ONLY the first time you select an agent and want the 2nd combo to be "null" when you again select an agent?

What if you comment out the last line? All that code is doing is defaulting to row zero of that record source.

Me.cboDate.value = Null Me.cboDate.Requery Me.cboDate = Me.cboDate.ItemData(0)

Here is an updated, clearer jpg of my relationships

So I have read the material that you posted and still have no idea how I could possible get rid of the relationship between tblproject and tblJoin_HQP_Project. For the record, HQP stands for highly qualified person. My problems are that: 1) each project must be associated to a company 2) each...

Ahh...sorry about that, I was in the midst of re-designing so that I can assign more than 1 company to a single person. The tblcontactscompanies table will be removed and tblcontacts will have a 1 to many with tblcompanies.

I have a project management database that includes a projects table, and a companies table. In the projects table, I need to track the company that the project is for, and I need to track what ASP (Approved Service Provider) is assigned to the project. This requires me to have CompanyID and...

Ha, I figured it was trivial! Thanks alot!

I am trying to add a quotation mark on the end of my textbox value using this code: =[BuildResolution] & " " " It will not work because it thinks I am adding a string. Is there any way to do this? The value displayed in the textbox would look like 0.01" Thanks

Thanks for the input. The real problem we are having with finding a suitable system is that its part project management and part investment tracking. We invest in companies, and then track their project progress in a broad sense (quarterly reports). The thing is, we don't control their...

I have attached a photo of the dashboard that is using all of the Dsums. Back when I developed this, I had taken advice from this forum on how to do it, which is why this was made the way it is. BTW, most of the textboxes use either DCOUNT or DSUM and all are unbound.

If it was up to me, I would suggest the company purchases a pre-made system. As it stands right now, I am in the requirement gathering stage, to find out if the design is feasable for us. As a sidenote, I am not a database designer, so that will factor in to my decision to take on this project...

Thanks Marla, that is really the reply I was looking for. When I was thinking about the forms I need to make, I suddenly had a bad feeling that I should be using all fields for all programs. Now that I know its ok to have unused fields for specific programs, I won't worry about it!