Search results

Hi All, I am trying to figure out how to build my query that returns equipment reservations where "date out" OR "date In" are between 2 dates that are specified on my form using [Forms]![Myformname]![StartDate] and [Forms]![Myformname]![EndDate]. The purpose of the query is to find the amount...

Perfect, thanks for answering my stupid question!

I am just wondering if there is an advantage to using a currency field type in a table, vs. just using a number field? This is assuming that I am not working directly in the tables themselves and am using forms to display the data. Thanks

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...