Search results

Not sure I'm good at the explanation stuff, but what you do in VBA isn't necessarily supposed to be immediately visible in the interface - think of it - the user isn't even supposed to see the database window ;-) But, say you append a field to a table, next time you open it in design view (or...

Yes - http://imdb.com/title/tt0095250/

In no particular order Le dernier combat Le Grand bleu Leon Blade Runner

As is said above, case sensitivity is determined by the Option Compare statement at the top the module in which the code runs. If omitted, it defaults to Binary (which is case sensitive). Your two subs are proably located in different modules, where one module has Option Compare Database, the...

Seems to me Insurers_Informed is a control on your form. If so, the AfterUpdate property of it, is a text property, I think, not a Yes/No thingie. Is Insurers_Informed the combo? Does it contain "Yes" or "No"? If so, you might try 1 - use the AfterUpdate event in stead on the on Change 2 -...

TheVariable = "NameOfTheControl" MsgBox me.controls(TheVariable).Value me.controls(TheVariable).Value = "Some Other Value"

The problem is that Vista comes with ADO 6.0, and previous versions of OS comes with/uses ADO/MDAC 2.#. When creating a db with 2007/Vista, lower versions doesn't cope (isn't able to understand that it should use ADO 2.# in stead, and gives such message), while when creating the db on lower...

Try hard to convince yourself that you don't ;)

I thought that CacheSize was meant to give you the possibility to have control over caching with server side cursors. I e, use it to determine how many records are read initially into the cache (determined by CacheSize). Then when you reach "outside", fetch the next N records. I think clientside...

Set "Print preview" as Default View. Disallow Layout View, perhaps also Report View, whatever that's supposed to be.

If you open the report from code or the navigation pain, it is supposed to close by hitting the close button, sometimes also when using Esc, or by using some of the other closing methods (ctrl+w/ctrl+F4). If you haven't opened the report, but switched from design view, some of the above methods...

Yes, I think that's what it does if you switch to preview from design, then hit Esc, while it should usually close by Esc or Ctrl+w/Ctrl+F4 if you've opened it from the navigation pain or directly through code.

Also, according to http://support.microsoft.com/kb/281998/EN-US/, you can only bind a form to a recordset with client side cursor, when using ODBC sources, which means it seems client side/static is the only option, if the documentation is correct.

Ah, yes Alt+Enter, of course... :o

I think all code in a form or report class module and all code expecting parameters in standard modules gives the macro window.

When in table design view, bring up the properties sheet (Alt+F4), then in the validation rule property (among the table properties), enter [Field1]<>[Field2] What you were probably working with, was a column level validation (i e, working with the validation rule property of a field), while...

I can link to SQL Server views here on my setup. Here, this also seems possible http://www.access-programmers.co.uk/forums/showthread.php?t=108763. You should be able to do so through the "normal" procedure (File | Get External Data | Link ...), and it should appear as if it was a table, at...

I don't understand. If the object you wish to base the report on, are within the database container, you can assign the name of the query or table to the recordsource of the report. If you by view mean a SQL server view, then you can link to a SQL Server view, then assign the view (typically...

The hint is that the message is true - you cannot assign an ADO recordset to a report in mdb files, only ADPs. But I don't think I'd use that as the reason to switch to ADP. The impression I'm getting by MS lack of efforts with the development of the product, is that it is on it's way out. I...

The code rsJobs.Open "SELECT thePK, Memo FROM Jobs WHERE JobReference= '" & find & "'" was meant as a bit of "pseudo" code. I will sometimes fetch both the primary key field of the table, in addition to the field(s) I wish to edit, hence "thePK" - The Primary Key, whatever it is called. You'd...