Recent content by OZmc

What i have: I ahve a select query that displays ALL [names] their [values] and the [date] when it was recorded. Several [names] have multiple records and thus multiple [values] I have a report based off this query. the report takes this data and graphs it. The problem: as the database grows...

Sadly I think I will need someone to look at it. I was able to get the exact same DCount coding to work on a different form (looking at different fields) but when I apply the same coding to my target form I get an error. :banghead: I attached my database and color coded things a bit so you...

I think I have discovered the source of all my problems. I neglected to mention that the information contained in Qname (the query field) is a dropdown list. Doing some trouble shooting if I redirect the DCount function to another field that contains a string of text it works. is this...

you were correct. One of the fields was named something else. I fixed it but im still only getting 0 as a result. I worked with the coding and have this currently: =DCount("*","Qcount","'Qname' like '" & [name_id] & "'") Qcount = Query Qname= Query field (Text) name_id=Form Field (text)...

I cant tell you how much I appreciate this. I also cant imagine how difficult it is to debug something you cant see yourslef. I made the changes you suggested. Changed the names so that they arent conflicting with reserved words and such. It turns out that one of my tables was recording the...

great thanks for the help! I unfortunatly get a #error. Whats odd is if chage the form field name (record/name) to another field on my form I get a correct calculation of 0 in my text box. here is what I have: =DCount("*","record_count","[Name] = " & [Record/Name])

I have a query that totals the number of records related to each person. In my form I would like to have a unbound text box display the number of records associated to that person. so i need a IF statement to do the following if the query field holding names is equal to the form name...

the main form that is giving me issues is the daily records form. any suggestions / tips are appreciated.

*bump sorry, ill only bump the message once.

I can't have a continious form placed in a form that already has a subform in it. my goal is to have a form setup like this: Main form -subform(1) -subform(2) <--- idealy this would be my continous form ---subform(a) Subform 2 could be setup with a button to just cycle through the records...

I have a main form that has multiple subforms from different tables. In the main body of the form I have a SET of subforms that I would like to display a diffiernt record each. ie. instead of of cycleing through the records they are all displayed at the same time on one form. Bassically i want...

One way I was thinking of doing this was generating a form that at multiple subforms that were "hidden" and would only become visable based on the number of "residents" is this a good way, or is there a better way to do this?

I am trying to generate a form that will have multiple sub forms conditionally based on how many observations need to be made. Another way to think about it is this: Let’s say I wanted to record information on individuals inside a household, across multiple households. The parent form would...

lol doh....

Great thanks! I have a module setup with: Public strVar1 As String Public strVar2 As String Public strVar3 As String Public strVar4 As String Public strVar5 As String --------------------------------------------------- then on the form I have: Private Sub Command90_Click() Var1 = [field...