Search results

Thx for the tip :)

Great, that did it! Do you have any idea why it doesn't load the results? I've used the same code with queries returning 200+ records. Is this just some Access quirk?

Hey all, i've got an odd problem with a query i'm trying to call from code. The query itself is nothing exotic, just a regular selection query with a few filters on it. When i run the query from the gui i get the correct results, 11 records, but when i call it from code it only returns 1...

If you only use the form to add new entries then you can set it so it always shows an empty one. On the form designer, get the properties for your form, go to the data tab (2nd tab) and there should be an option Data input or somesuch (i'm using a dutch version so i'm not sure anymore what it's...

You either have to lower the security settings for each individual user's access. I'm not sure if you can do it through group policy (which would be easiest). OR You can sign it with a digital certificate you make yourself. But each user still has to have it and accept it as well. That way...

If you rightclick your form field and check the element source, there should be an icon "..." where you can build the expression that will be the datasource for the element. You can have something like IIf (myfield="1";".";"") I think you'll be able to get your dots like that but not your...

A little more information about how you're trying to go about it now might be handy :)

If the field you want to address is included in the query you've based your form on then you should be able to reference it if you know it's name even if it's not >on< the form. You won't be able to access any other properties other than .value though. Try typing the first few letters of the...

First i'll wish you a good recovery from your hernia :) The "main form" i'm referring to is "Frm_Patienten". It's a non databound form with the tab control on it. The tab control contains one "subform" per tab. I'm personally not a big fan of using dutch in programs and programming but if you...

I will take you both up on that offer. I'm really wondering what i should have done differently to prevent such a thing to occur. Apparently the file was juuuust a bit too large (461kb) Here's the link where you can get it: http://users.pandora.be/limen/xfer/db.zip This is the 'real' app. I...

Eureka. i "solved" it. Or rather, i found a workaround. It's pretty silly to have to do it like this though. I don't know if it's a workaround or the way you have to do it but anyway. The problem was apparently a combination of 2 problems. The first was that the changes didn't get committed to...

Hey jc, i tried your suggestion of moving the code somewhere else. I first tried the Form_Current but that didn't do much. Now i thought that maybe i'd been going too far out looking for a solution so i tried something simple. Putting the requery for the forms in the tab1_click and tab2_click...

Thank you for the reply boblarson. Unfortunately your suggestion didn't work either. After working once cboRooms on the other form always keeps the same content and refuses to update while cboDept always instantly reflects the correct value. I'm assuming since its content doesn't have to change...

Hello all, I have been banging my head against a problem which seemed to me shouldn't have been a problem at all. Access seems to be of a different opinion however. Or i'm not doing it right :D I have a form with a tabview control with 2 tabs. Each tab has a subform (sf_1 on tab1 and sf_2 on...