Search results

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

Hi. I am a novice with VBA, but I know a fair amount of C++ and Python. I am trying to create a Copy button that copies the values in set of fields in one form and a paste button that when called will enter the data into another set of fields in another form. I was thinking global...

this is a weird one. I have a form that inputs a short date into the target table on load. now I want to make a query that returns all records made today or yesterday. I am using a query that looks in the date_record field: the total field is "where" and the criteria is Date() Or (Date())-1...

Nevermind I got it! thanks!

This is what I got is VBA: Private Sub Date_check_BeforeUpdate(Cancel As Integer) If Not IsNull(Date_TIME) Then [Date_check] = Date End If End Sub Doesnt seem to work though. Should it be AfterUpdate?

I know how to program in Python but I dont know how to program in VBA. How would I write a function in VBA to do the following: Begin sub: If [field1] IS NotNull Then input date() in [date_check] end sub Then as a second function I want a checkbox to compare the current date with the...