Search results

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

Sounds shifty. I hope no one has ever used one of those against me. It'd be a shame for someone to cheapen my favorite game by reducing it to a download contest. Sounds like something a grade schooler would do. Maybe I'm just old fashioned, but I don't like the sound of it.

Thanks for responding x0reset, but I don't think I understand. So you're saying I need to make my count control bound to something in the recordset? Also, I don't think I explained very well that there is only one record per district. So if there are four records in the zone grouping (the...

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

Aha. That should do it. Thanks Rich. ps. Sorry I didn't explain well.

Okay, I am an idiot. I had that in the wrong event. Now that it is in the AfterUpdate event of the entrydate combo, I get an error. The changes you requested were unsuccesful because they would create duplicate values in the index, primary key, or relationship. After that, the debugger...

Thanks for the quick reply, Pat. I tried entering the code just the way you posted it, but it doesn't work. I think that in this case the problem is definately between me and the screen. When I update the combo it's based off of nothing happens. Dim rs As Object Set rs =...

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?

I am still hoping for some help. I need the form to go to a record based off the values in three controls. This is the code that the wizard comes up with for a lookup from one combo. ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...

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

Thanks for the answer guys. When does the before update event occur? EDIT: Nevermind that. I looked up the answer in the help file. (Duh.)

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 think I made a mistake. I said 'lookup' when I meant 'find' and I didn't explain myself very well. I am trying to recreate the third option in the combo box wizard 'I want my form to find a record based off of my combo box' or something to that effect, except using multiple selections to find...

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

Dlookup was the piece of the puzzle I was missing. I looked that thing up and it works like a charm. Thanks for your help! I hear that Dlookup is unpopular. Why is that?

Thanks for responding, I have tried to reference it the best I can, but I really think that is exactly what the problem is. As far as I have seen, I have never seen a [Thing]![Stuff]![Doohicky] kind of identifier referring to a field in a table or query. Is that even possible? Like...

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

I must admit if I COULD do that it would simplify things. Thankyou for you help and patience, just one more question. Do you know of a way I can return John only once with his highest ID? Lets say that the table is populated with names and IDs, like the imaginary one, is there a way to return...