Search results

I once saw in this forum a link to a table that had instructions for referencing forms, controls, subforms and all that good stuff depending on which form you are on. I have searched and searched and I can't retrace my steps to find it again. Could someone please point me to it? Thanks. -Dave

Well, thanks to SJ McAbney I have a nice chart on referencing subforms from the main form and what not. I'm still having trouble making it work, so I am sure there is something that I don't understand here. Private Sub cmdNewCat_Click() Me.frmNavSNewCat.Visible = True...

I understand that these questions may be very simple, but I would ask that you humor me. 1. I am wondering if there is a way to get a multiple page adobe pdf file embedded in a field on a table to display properly in a report. Right now when I put a control linked to that field in a report or...

Hey everyone, merry christmas. I have a question. I have a report that shows a detail for each district in a zone. The report forces a new page for each zone. So there are usually 3-4 details on a page. The report is designed for the district leaders, so I need to find a way to easily print...

Is there a way to add criteria to the Sum() function? I would like to have two seperate totals in a section footer. Which total each record is calculated into should depend on a value in one of the fields. Does any one know a way to do that?

Hello all. I have a form for entering information about sales teams performance relevant to certain dates. As the form is, the user selects a 'team' from a combo box and then a reporting date from another combo box, then enters numerical information about their performance. The problem is...

Could someone please explain to me the way forms save information? I always understood that database tables automatically save information as you enter it. But the command button wizard and also the Better Mousetrap example use special save buttons so it seems different. I would like to know...

I apologize if this has been adressed. I searched but did not find it. Partially I think because it won't let me use the word 'two' in the search. That's kinda important in this case. I know how to make a lookup combo box. I used the wizard and copied and pasted the code, actually. What I need...

Is it possible to use a subquery as a default value property setting? I need to use a value from a table that is not the focus table of the form, I have tried to identify it with a subquery but it returns a #name? error every time. I hate those! Any help would be appreciated.

I have created a query to delete duplicate records. I followed the instructions on the following help site: http://office.microsoft.com/en-us/assistance/HA010345581033.aspx#15 I created a join on the two tables just as required, on one of several fields that sometimes duplicates. I have two...

I need to make a query that only selects data that is in another query/table. I have tried to do this using a query with IN criteria as follows. SELECT fldOne,fldTwo,fldThree, FROM tblOne WHERE (((tblOne.fldOne) In (Select fldOne from tblTwo)) AND ((tblOne.fldTwo) In (Select fldTwo from...

Ok, this is a quote from MS Office online. So, from what I understand of this, if any of the fields in the record (or row, whatever) repeat then it is not displayed. Correct me if I am wrong. The problem is that when I try and use it in my DB it return all the fields regardless of the...

Hey ladies and gents, Just so you know, I am new at this. You probably guessed. I am trying to learn how to make a specific type of form here and I feel like I am wading through an ocean of instuction books and help files, I was just hoping someone could point me in the right direction. Just...

Wow, seems like this is my favorite place in the world now. My problem is that I need to append data from one table to another, on the condition that any of the fields in the record have changed since the last time the query ran. For example, tblEmployee has the fields 'EmployeeID', 'Name'...

I need to know if it is possible to make a query that selects the highest or lowest value below or above a number that a user or form defines. For example, the attached database has a history of which of three children held the position of mom's favorite by recording the day that they became...

I am wondering if it is possible to use a table/field identifier as part of a criteria expression in a query. The field that I need to use in the expression is not a part of the focus table, so I think I need to use a full identifier, if that is possible. I have seen such identifiers used for...