Search results

Np, ya you can get tons of help with many things on these forums. I haven't been around a whole lot lately as my job shifted from the main access developer. I never really played Omaha, always Texas Hold'em. The biggest thing for sure is knowing all of the odds vs knowing all of the pot odds...

Hello, I used to play $5/$10 or $10/$20 Texas Hold'em on Pokerstars, since I've graduated I havent had enough time to grind 5-6 hours a day anymore, so I rarely play. The problem in your hands demonstrated is that you don't seem to understand the rules of Omaha. The rules state you must use...

I am gonna ask how you know for sure his diagnosis is incorrect. If for example, you did have mental issues I'm sure you wouldn't know about them or ever admit to them.

Wow, I had no clue that a simple Group By clause could cause that.. you're correct, I ran a quick test on a second recordsource and it worked perfectly. Thanks very much. Now, do all queries that use an equation (Sum, Count, etc.) have to have a group by? In reality all I want is the WHERE...

Table, and this is the code that declares the recordsets: Dim rstProgram As DAO.Recordset 'Set and Open the Queries and Recordsets Set dbCurrent = CurrentDb Dim rstProgramSQL As String rstProgramSQL = "SELECT tblPrograms.ProgramID, tblPrograms.ProgramTitle...

Hello, not sure exactly where to put this one.. Am using VBA code to open an instance of Excel, and copy data into a premade template. I have memo fields that are often over 255 chars, and when pasting it into Excel only 255 chars appear. I need a way to fix this. Access 2003 -> Excel 2003...

Hello, If you wish to design a front end that controls, let's say many backend individual databases, is this manageable? Let's say I have 20 backend databases that I want controlled through a single frontend, would it be manageable as long as I had a specific prefix for each 'module' or...

I work for Canadian DND, I'm not mentally ill :( On a serious note, I'm actually gonna miss the entertainment that thread provided, maybe I'll reread it! :)

Hello, On the afterupdate event of your combobox you need the following: [Forms]![frmMain]![frmSub].Form.Filter = "[Field] = '" & Me.ComboBox & "'" [Forms]![frmMain]![frmSub].Form.FilterOn = True This will set the filter property of the subform.

WE GOT A PICTURE OF HIM! QUICK! GO GET HIM! You definitely arent getting any longer, you look like an old cracked up nutcase. PS Tim: The pictures you pasted on the bottom of page 58 were actually pasted a long time ago by you, roughly around page 15-20 if I recall, the other is around page...

Tim, can I get a reading on your IQ level please? and if possible, your EQ. Mike: You participated in other free offers? How silly! You must be what brought Tim here, he had to have found us somehow. One of those free offers you took was a ploy to find us here!

If you use a continuous form for the subform. And place a button on that form that refers to me.PrimaryKey, it will retrieve the value of the primary key of that current record, for example: Continuous Form: Record 1 PrimaryKey="1" Button (Returns 1) Record 2 PrimaryKey="2" Button...

No you idiot, he's calling you and your friend CRACKERS, CRACKED UP. Since they don't answer any question with a shred of evidence or explanation even when asked, can't we just have them banned from here for good?

I play Poker, Chess, competitive gaming. You play at Pokerstars? If so what limits?

Np, feel free to post any questions on these forums, they're an excellent source of knowledge. Sorry I couldn't get it working for you with the listbox. If I get a chance tomorrow I can try and do up an example file for you to download.

To do it Simon's way, it'd prolly be best to use a bound form as he suggests and a filter. (I was assuming unbound form, and listbox as in the initial criteria). Also with Simon's way, instead of a lot of code you could even just use a subform to "list" all of the data, and the continuous...

No problem for the help, glad I got you 75% there... let's see if I can get you 100% there. The combobox should have the primary key field for the Customer hidden as the main bound column of the combobox. I believe it's Customer.ListID, meaning your combobox should be: SELECT Customer.ListID...

I only play online games, so my favorite is definitely DooM II ! Still being played hardcore by a bunch of people :) Quakeworld, Quake3 CPMA, X-Wing vs Tie Fighter, WarCraft 2, all receive honorable mention from me.

In all honesty, I get bored at work writing VBA all day sometimes, why did *I* never think of stringing people along all day with something completely retarded? I mean, this would be pure entertainment for Tim Brewer, he'd never have a boring day at work EVER. Pure genius. If he was serous...

If you want to go with the listbox idea, you can use code that looks like the following in the AfterUpdate procedure of the Combobox: Dim strSQL as string strSQL = "SELECT blah blah blah WHERE PrimaryKey = " & cboSearch me.lstBox.RecordSource = strSQL me.lstBox.Requery The strSQL needs to be...