Search results for query: *

Duane - This works great!!! Me.subformctrl.SourceObject = "Query." & Me.cboQueryName (from the DynamSubFrm.mdb). It accomplishes exactly what I need and I can merely rebuild a dynamic query def using VBA as I'm already doing! THANKS!!!!!! (*star to ya')

Please accept apology in advance if posted in wrong section… it feels like a QUERY question to me…. This question assumes Access 2003 delivered in MDE format. I've been developing Access apps for 7+ years, and have a particular app with 8-10 users. These users are not database proficient, so...

Remou - Finally had a chance to try this...works perfectly and accomplishes exactly what I need. Can now cycle through 250+ HTTP addresses and get validation within 60 seconds without any intervention. Wonderful!

Thanks. I'll take your code snippet for a spin after lunch and tweak as needed and see if this produces the desired results in validating a URL address.

Unfortunately, these are all HTTP addresses (EX: http://dpi948.myserver.com/cobprod:/Sarbanes Oxley\SOX 2007\Enterprise-Wide Controls\Financial Controls\PSO\PSServices\Process Documentation\PD_APT002_PSO_PSServices_CrteSvcPO_nar). DIR doesn't handle these. Thanks though.

I have an Access 2003 database that allows a user to click an icon to open a Word document (if one exists) that defines the process associated with a displayed control. This Word narrative is maintained in a separate and independent enterprise repository that provides for archiving, versioning...

Not sure about the event order or if it really matters. I generally do this in the Open Event: Me!subform_name.RecordSource = << insert appropriate source>> Me!subform_name.Requery This effectively controls the record source for the specified subform ("subform_name" would obviously be the...

"fullscreen" is still supported in IE, but it still doesn't MAXIMIZE the window.

Need to be careful not to confuse "full size" window with "maximized" window..... not the same. You can easily control the window size as mentioned above, but can not MAXIMIZE the screen using JavaScript. The effect of not being maximized would be that vertical scrolling may not function...

I've been doing this for years and it's pretty clean though it might have to be modified a fair amount to work for you in your environment. But it provides a lot of relief for me in that I never have to worry about "are my 60+ users running the latest, greatest version." I "front-end" all of my...

I have a similar situation (problem) and had already done this "move" and "resize" technique described above. However, taking it one step further, I need the new window to open "maximized" so that the user doesn't have to click the windows maximize button. As a matter of fact, I need the...

Thanks Steve! The code snippet I'd included earlier was not an exact cut&paste from my module but rather a simulation in general context that admittedly make it appear a bit more &quot;scattered&quot; than it really is. The fact that I didn't have the: DB.Close SET DB = Nothing will hopefully...

Steve, Sorry for how long this code section might appear but if it helps in debugging this 3048 error then it's worth it. This is the code for &quot;updating&quot; a record.... there's a similar module for adding a new record with only difference being &quot;.AddNew&quot; instead of...

I have a multi-user Access (Version 7.0) database with FE/BE database files...actually three back-ends. One of the &quot;back-end&quot; files contains only 1 table as it is the most dynamic table in the system and with issues of file corruption it made sense to be able just to be able to backup...

Setting properties alone to &quot;general number&quot; will definitely work and result in a generic Access error message when the user enters something other than numerics... which isn't always the easiest text for the user to interpret. If the numeric text field is fixed length, you may want...

Why not take a slightly different approach...audit the text box data using the &quot;Before Update&quot; event. In the example below, I'm expecting the field to be 3 numeric characters (if input): Private Sub txt_DeptNbr_BeforeUpdate(Cancel As Integer) Dim ErrMsg As String If...

Just did a keyword search on this site for Too few parameters and found a post from 3/12/01 on this same subject in the Other topics forum as: Programmers Area - Microsoft: Access Other topics Forum GeneJohnson (Visitor) 3/12/01 (posted 3/12) 2 responses Too Few Parameters - Error Msg...

Just did a keyword search on this site for Too few parameters and found a post from 3/12/01 on this same subject in the Other topics forum as: Programmers Area - Microsoft: Access Other topics Forum GeneJohnson (Visitor) 3/12/01 (posted 3/12) 2 responses Too Few Parameters - Error Msg...

I created similar thread titled Error 3061 on July 13 on this same issue. My personal experience has been that this method works fine provided that the query being used to build recordset (in your example above: &quot;qryRetrieveAvgTempProfile&quot;) does not contain any criteria that is based...

Rolliee, My constructed SQL Code looks pretty much like the SQL in the query in SQL view with the exception being I substitute Me!txt_UseThisSSN for where the query SQL view has something like Forms!Switchboard!txt_UseThisSSN. Occasionally, for debug purposes, I'll actually take the exact same...