Search results

I suppose that you could always try to work with the font sizes in the report so that they will be reduced if your 22" limit is reached. That would allow you to jam everything together, but it would make things harder to read. Out of curiosity - what would kind of report would someone even...

Yes, my apologies, here's a code correction: strColorSQL = "SELECT red, green, blue " & _ "FROM tblColorPref " & _ "WHERE HeaderBox = " & """" & strColorName & """" & ";" The four sequential quotes designate a " character in the string. Obviously, just placing a...

I think I kind of see what you're looking for, but as another option, why don't you use the doubleclick event instead of trying to create a key down or key press event that is sensitive to the Enter key? Or add a command button that they can click that will reference the respective guest...

I think so... Sure - shouldn't be a problem. Provided that you've either determined what RGB values you want or the absolute value, you can place them into a table and open it up using a recordset. Something like this: dim rstColor as recordset dim strColorSQL as string strColorSQL =...

Unfortunately, I've been forced to create a report using an ADO recordset that is populated along the way from 3 different DAO recordsets, so I can't re-create the results in a SQL query. In order to do so, I've relied on an article from MSDN, but it was an Access97 item, and I'm in A2002...