Search results for query: *

I know how to do this using DAO techniques: You say you loop through a recordset, so you have one recordset open. You DIMensioned a RecordSet object variable rst to do this. (maybe you called it rst) You DIMensioned a Database object variable too (call it dbs) Dim dbs as Database Dim rst...

morcelli, Your suggestion interests me. Could you tell us how to programmatically change the user's resolution? I am guessing this is a Windows API call. I buy "geek books" all the time that give details of some API calls and how to implement them in Access with VBA, but I...

This has been done! ' From Access 97 Developer's Handbook ' by Litwin, Getz, and Gilbert (Sybex) ' Copyright 1997. All rights reserved. Check out this book, it comes with a CD containing a bunch of useful code, which I have found to work beautifully with Access 97 and 2000. It checks the...

Try this: In your For..Each loop, add "ctl.SetFocus" just before the With...End With block. This way each control gets the focus before you try to change any properties. Oh, maybe you should also open the form Hidden (.Visible = No) while all this jumping around occurs, then...

OK, I get it now. In Access 2000, With the 9.0 Calendar Control, you have to set the Value in the On_Load Event. As DougP stated, ActiveXCtl4.Value = Format(Now,"mm/dd/yy") sets the calendar control to today's date. Isn't Tek-Tips Forum great? I'd never have figured this...

Aviars, I tried both ways you posted of setting the calendar to today's date. Neither has any effect. Nor does setting these values in the Immediate pane in Break Mode. The control's Value will only accept a literal date entered from Design Mode. What am i doing wrong? I am using Access 2000...

[Calendar Control Name].Today USED to work for me (in Access 97). Now, in Access 2000, it doesn't! I can't say for sure what version of the control I had in Access 97 but in Access 2000 it's Calendar Control 9.0 Access 2000 Help files are horribly foreshortened! What happened to all the...

I've found the answer to my question before but have since lost & forgotten it. How to you get the Calendar Control to open with the current date? I tried DougP's code ActiveXCtl4.Value = Format(Now, "mm/dd/yy") in the Form_Open event code but I get an error "You can't...

Hello all, I'm in the same boat as Smack, and I took the "quick and dirty/fine tune later" approach suggested by MichaelRed. I'm reading up on ADO but all of my databases were built using DAO techniques. After converting my databases to Access 2000, I simply removed the...

Follow-up message: Removing the damaged report solved my problem. Now I just have to wonder what happened to damage it. All I did was add a Report_Open event (DoCmd.Maximize) and compiled the database. I wonder if this is something that only happens with databases converted from Access...

Thanks all for offering information and advice. I tried thornmastr's /decompile but it didn't help in this instance. By continued digging I found the problem to be with a report to which I had added a Report_Open event. This application displays a Switchboard form when it starts up. I stopped...

We recently converted from Windows 98/Office 97 to Windows 2000/Office 2000 at work. I converted a number of databases to Access 2000. In the process, I had to set references to DAO 3.6 (I haven't gotten a handle on ADO yet, so I haven't tackled re-writing all my VBA code). Anyway, this is the...

How are you selecting this "1 input"? Are you talking about a second query that gets its parameters from the first query, or perhaps a query that is self-modifying (which is a new one on me)? Please post more info if you want better answers.

Here are a few I have read and found useful: Beginning Access 97 VBA Programming Robert Smith & David Sussman Wrox Press ISBN 1-861000-86-3 Access Database Design & Programming Steve Roman O'Reilly Press ISBN 1-56592-297-2 Access 97 Developer's Handbook Paul Litwin, Ken Getz & Mike Gilbert...

I found this after extensive digging through the Access 97 Help files: To Hide Database Window ( Sometimse I put this in the On Open Event of the first form to open): Private Sub HideDatabaseWindow() DoCmd.SelectObject, acTable, True DoCmd.RunCommand acCmdWindowHide End Sub To...