Recent content by mrlw00r

I use the execute method by default just because that's how I started programming in Access and I'm used to it! I don't need to use the query - I was just copying the SQL into it to see if it worked (which it did) because I new that I should be getting back a different result from execute.

What?! Look next to the post reply button!!!! Blimey... (sorry... been a long day...)

Oh... yes!! I do of course mean an ADODB.Connection object, not docmd! It seems like the problem happens only when a like expression with a wildcard in it is used...

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...

Oh. That's a shame isn't it.... There really are some things one should check up on sometimes...! I always name controls appropriately, makes everything a lot easier. As for this field name, it doesn't appear to be causing problems elsewhere (at the moment) so it's not essential to change it...

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...

Thanks! (Should have RTFM for that one really!!) Will post another message pending success/failure ;)

Ahhh!!!! Bingo... Yes - that sounds ideal! I would need to reconnect child-parent fields - how can that be done?

My database has ~50 tables, and when I say I have over 100 open, I'm counting every occurrence of a table being referenced (ie through query, form, combos etc). This means that I'm really only looking at data in about 20 or so tables, but the references build up. I agree I should rethink my...

I've tried to create a reference to the Controls collection in an attempt to add the subform directly, but: Private Sub Form_Open(Cancel As Integer) Dim c As Collection set c = Me.Controls End Sub gives a type mismatch...

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...

I've started trying to reorganise my forms so that things will work better, and I thought I'd manage to fix the problem by setting/clearing recordsources when changing tabs. When I tried running the database onsite - when it had been installed - I started getting the error again, and so I had...

I think the answer here is that you can't easly.... I agree that it's a perfectly acceptable thing to place subforms on top of each other, and then use code to switch the things on and off, but when designing it makes things pretty hairy. You can consider a few things: Plan the design of the...

Thanks all, that's a great help. The solution to my problem is to only assign a recordsource to the top level (big) forms when they are to be viewed. This can be done through the onclick event of the tab page, so each tab will kill the recordsource's for the other tabs, and set it's own when...

Where I said "maximum number of reports on a form" I really meant maximum queries - anything which requires one of these table-id's to be open.