Search results

I guess the real question is 'how do I make a selection in a combobox programmatically?'

On my form(a), I have a combobox with ten columns. When a selection is made, the rest of the fields on the form(a) fill, based on the column values. My problem comes when the value for the combobox is passed from another form(b). It looks like it gets the value, but fails to fill in the rest...

I don't, I just put those in to make things easier to read.

Fuck a duck. I did it like this: strWhere = strWhere & "TSP.[CEAID] = " & ctl.ItemData(varItem) & Chr(32) & " Or " as MSAR suggested and I had tried before. The SQL looked ok. So I put it into a query and tried to run it. At this point Access reminded me that I had the table open. So...

This: strWhere = strWhere & "TSP.[CEAID] = " & ctl.ItemData(varItem) & " & Chr(32) & " Or """" gives me an error 13 type mismatch this: strWhere = strWhere & "TSP.[CEAID] = ctl.ItemData(varItem)" & Chr(32) & " Or " inserts ctl.ItemData(varItem) into the string, as opposed to the...

this is not right, as it doesnt work: strWhere = strWhere & "TSP.[CEAID] = #" & ctl.ItemData(varItem) & "#" & Chr(32) & " Or """ I put a watch on strWhere, and it shows up as WHERE TSP.[CEAID] = #7# I just want to flag ctl.ItemData(varItem) as a number, so I dont get the 13 mistype error...

Well I just kept clicking submit until the number reached new numbers. No idea why it chose to randomly start with record 15, but now that we are caught up, this works. So I say solved! YOU CAN GRAB AUTONUMBERS!:eek:

according to wayne This was exactly what I was looking for. So i did it like so: Dim db As DAO.Database Dim tblSubProj As DAO.Recordset Set db = CurrentDb Set tblSubProj = db.OpenRecordset("tblSubProj", dbOpenDynaset) With tblSubProj .AddNew !Date = Now !ABRID =...

1. I don't see Infinitely complex system as an analogy, this is my string-theory+ of choice. No more an analogy than any god. An arbitrary word construct, representive of an idea I might concede, but we're not arguing linguistics. 2. RE: my comfortability with process. I'm not sure sure I...

eh, nothing really. I meant to reference Ptolemy's (and more famously Copernicus) model of the solar system, and their notion of the 'epicycle' to explain the apparent retrograde motion of planetary bodies. While these notions were adequate to explain the observable celestial phenomena of the...

although hesitant to call myself an atheist, I will answer as such, and concede that I've been to lazy to read this thread in its entirety. So this may have been touched on. I've never thought of these remarkable patterns as anymore than ptolemaic discriptions of an infinitely complex system...

not for amataurs 1. Refused (recommended album: The Shape of Punk to Come) 2. Cake (recommended song: Italian Leather Sofa) 3. Venetian Snares (recommended albums: Winter in the Belly of a Snake, or Winnipeg is a Frozen Sh*thole, or F*ck America / F*ck Canada) 4. Holst (recommended suite: The...

hella rad! I knew we'd have an expert around here! I'll try for all of the above! (hardwood im thinking. If you're gonna do something, do it right!):D

ahh fantastic! i had hoped as much. So on with the questions. I understand that wood is often added to charcoal to improve flavour, but I think I'd like to just use logs. I hear this could lead to uneven heating problems or the like. Any input 50? My plan went as such. 1. get some fine...

www.fruitfromwashington.com/whatsnew/images/PLAN7.jpg searching for the olde style "barbeque" was far more rewarding.

I always wanted one too. My greatgrandfather had one, so I could prolly consult family, but I'd really rather not talk to them. I've never done any masonry, but I dont think mine will need any. likely just a new grate and some cleaning. someone said you put wood below a stone, then grill...

fixed. I think. what would a grill like this be called? this is the only example i could find online...

So I found an old grill in my backyard, not unlike www.pizzamaking.com/forum/index.php?topic=5725.0 The question I pose, is how might I repair a thing like this? By Saturday. Admittedly mine is in much better shape than the one above. still has a front wall, and a few pieces of stone/concrete...

The gaggle of womenfolk in my family to be are having a Canada Day Pancake Breakfast for my future brother-in-law who's down visiting from the north country. Sadly I had to skip it...what with work, you know. :mad: ...Good thing I'm more of a waffle guy...

variant. http://www.xkcd.com/426/