Search results

Hi, Got a bit of a strange one here. When I use docmd.execute I get a different result to when I put the exact same sql into a query: SELECT Count([moduleID]) as [noRecords] FROM [Module] WHERE ([code] like "03*"); When run in a query I get returned the number of module records where code...

I'm trying to set a text field on a form using a field from the recordsource called 'name'. Setting the control source to... code works correctly, showing the code field, and name also works correctly, showing the name field, but =code & " " & name returns the correct code field, and then the...

Is it possible to add a subform to a form programmatically? I've been hunting around and I can't find anything that says that it's possible. I'm trying to solve a problem which is causing the "3084 - Cannot open more databases" problem (thread...

Cannot open more databases - arghh! Hi there A couple of days ago I split my project into the database backend and forms front end, and today whenever I open my main form (and others for that matter) I get told that I "Cannot open any more databases" This seems a bit odd to me since just...

Hi all :) I'm using a subform datasheet that I want to use as a list of current records for the parent form. I want to be able to click on a record which fires oncurrent to search for the record in the parent form. I've used this technique elsewhere - but only when the datasheet isn't a direct...

Hi In quite a few places I need combo boxes that have the first item as a blank entry, with an associated value of, say 1000. I need this for filter purposes so that the combo box for that field stops filtering when the blank option is selected. I use VB to tie together all the different combos...