Search results

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.

That's what this person found: http://dbforums.com/arch/201/2003/1/645495 But no, I'm pretty sure there're no circular ref's going on. For the moment I've put the tables back with the forms and its ok. I then found this thread (which was at the top of a google query for "access error 3048" which...

Had a thought about this - could it be down to the number of subforms I have? I have three tabs which contain one main subform each, so in total I've got around 30 forms coming off the main one. Is that too many? How might I go about doing a quick redesign to get around this. I like the tabs...!! :)

Would there be any point in introducing automated moderation? The obvious one is to disallow any swearing etc, but that's always hard and there'll always be some cnut who just swaps letters around... A potential solution for multiple postings is to do a search against the forums using the new...

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

I haven't work on this now for a few days and I saw the light just now... I looked at the record that is in common in the whole form, and placed the two parts of the current form as subforms in a new one. One subform contains details of the record, the other contains a list of the different...