Search results

I see what you're asking here, and I think that there may be a slight usability design flaw. Create two separate buttons for loading these instances. Designing interfaces like this this confusing for a lot of users. One step towards a better design would be to use this: [ TEXTBOX ] [...

Instad of .. & "" Try .. & vbNullString Its a good practice. In smaller routines such as yours, it won't make too much of a difference. But if you're using it in a larger routine, it will. using "" creates a new isntance of a string. Where when calling vbNullString, you're calling a...

The joys of remembering things from other environments >.< Thank you pbaldy. =]

Hello Friends! :) I have a query that is quite onerous and have decided that it can be cached rather than running every time the interface changes filters. My question is, why isn't it letting me have two queries separated by a semi colon. I've done it before, and can't figure out what's so...

Why don't people use ByVal & ByRef in front of their parameters >:O. Call me OCD or RCD but it zaps my brain every time I seem them missing. lol

And I'm getting the feel that I don't completely understand your issue lol

Oh uhm, If it does work for you, you would have to sub Width for Height and Left for Top

http://www.access-programmers.co.uk/forums/showthread.php?t=277576

I think that if you do a search you'll find that someone has already asked this question and I've already answered with a decent solution. I would post it again, but I deleted it off my computer. sorry

ORIGINAL CODE Private Sub Command35_Click() On Error GoTo Err_Command35_Click Dim stDocName As String stDocName = "Room Info" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Command35_Click: Exit Sub Err_Command35_Click: MsgBox Err.Description Resume Exit_Command35_Click End Sub MY EDITS...

Its been awhile, but I've gone through many iterations of this n figured I'd post the most elegant way of doing this that I have found. Int(CSng((NZ(sessions.session_end,Now())-sessions.session_start)*24*3600)) AS Duration This calculates the duration in seconds. Found in this...

Welcome Babs!

On the load of your initial form you could try turning warnings off and querying one of the tables, then turning warnings on again to see if that initial failed connection allows for a seemingly clean start. Just a thought for a workaround until you find the fix.

Which function are you using to print?

I'd like to think that you don't want to go around to every user's machine and change their registry, which is the first place I'd look to suppress that dialog on the event of printing. My second strategy would be to try and capture the Hwnd of that dialog and make it transparent. Let me look...

reinitialize your odbc connection. remove the old one, or two?, and create it again from a clean slate.

I'm willing to bet if you do this backwards it will do the same thing. Opening the top two first won't work, then after that opening the bottom 4 will work. I'm thinking the initial parse to the database is thrown back as a fail, but continues to open the gates to success afterwords.

The problem is that it isn't automatically initializing the connection on launch of the access database?

If you're looking to get rid of the access look entirely and just see the form's you're working with, I found my old code. Attached is an example form. HERE This form demonstrates both the applications transparency, and a transparency key set to the form.

From what I can tell, if you wish to look into refactoring your design for ease of mind in the future. Look into splitting these values by ' ' and storing them in a list control with multi select enabled. Once that is done, you'll be able to code it so, like in most forms, you're able to...