Search results

Hi, As fas as I know, it's only possible with looping through the recordset. But make it easy for yourself: Public Function CopyRecordset(RstFrom As Recordset, RstTo As Recordset) Dim fld As Field Do Until RstFrom.EOF RstTo.AddNew For Each fld In RstFrom.Fields...

Hi, This seems to work: Me.cbo.SetFocus Me.cbo.Text = "FOL" Me.cbo.SelStart = Len(Me.cbo.Text) Me.cbo.Dropdown Succes, Bert

Hi there, Is there any method to retrieve a message (such like an event) when the user resizes the main Access-window? Thank you in advance, Bert

Hi, I'm looking voor exactly the same! Does anybody know? Thanx! Bert

Did you also disable the Access Keys ? If not, press F11 when running the database to show the database-window, or ALT+F11 for the VB-editor. Else you can set the AllowByPass-property to True from another database using DAO

Hi, You can GroupBy address (look at View, Totals) or maybe it will do when you use SELECT DISTINCT instead of only SELECT in the SQL-statement (View, SQL)

Great!! :D I didn't see that there was a change in the number. One of the effects of not asking a question?

Help what? Have you got a question? Dim j As Integer Dim s As String For j = 1 To Len(Bridge) If Mid(Bridge, j, 1) = "-" Then s = s & "\" Else s = s & Mid(Bridge, j, 1) End If Next j Bridge = s For Access 2k or higher, use:Bridge = Replace(Bridge, "-", "\")

dcx, for a normal query it isn't required, but for a crosstab-query you have to. Don't ask why, but based on experience, it works only if you specify the parameters. thank you for explaining the syntax when I was sleeping :)

Hi, Instead of DMax, you can use DLast. DLast returns the latest entered record in the table (that not is deleted) and not the last one based on PK or sorting order. See also the KB: http://support.microsoft.com/default.aspx?scid=kb;en-us;208190

Re: Cheers Bert Yes it is, because it's a safety-setting for blocking virusses and unknown mailtraffic. If it could be set from VBA, the setting is not functional.

Hi Rop, The SQL-server edition that ships with Office Developer is not a run-time edition, but a developers-editions. You're only allowed to use that version for developing and testing and can not ship it to your customers. If Access is the right choice depends of the type of application you...

Yes, that's possible, in the same way is in a normal query. Only one thing: you've to assign the parameter also in the parameters-property of the query (Menu Query, Parameters)

Hi, In the same folder as the setup.exe, you can find 'setup.lst' Open that file with Notepad. In the [Setup] -section you can find DefaultDir=$(ProgramFiles)\YourAppname' Change this into the correct pad.

Hi, Try to import everything from your old 97-database in a new 97-database. Then Compile your VBA-code and Compact-and-repair the whole application. Then try again to convert to Access 2000

I'm sorry IMO, but that doesn't work with Oulook Express. I'm not working with an english version of OE, but it's a safety-setting in OE: Extra, Options, Safety, the first checkbox "warn me if other programs try to send e-mail" or something like that. Clear that checkbox and you'll not get that...

Okay, then here an existing one: http://global.bsa.org/usa/antipiracy/

Andy, Leave the "=" in criteria.

You can give the command "DoCmd.GoToRecord , , acNewRec"

If Not IsNull(.Room_Number) And .Export_ctrl = "4" Then