Recent content by japyy

Yes: it's a real mess, and no: I don't know how to get around it neatly. One warning, though: using VBA-code will mess things up even more...

"broker = broker" means: broker(in tblBrokers) equals broker (in the same record, in the same table). What you want to is: "broker = 'Jimmy'" or "broker = 12345" (using numbers as a primary key is strongly advised). Of course, 'Jimmy' or 12345 are variable, you...

The Where-clause "[Broker]=[Broker]" isn't very specific: it's like saying "get anyone whose age equals his own age". You would need a stament like: "get anyone whose age equals " & TheAgeINeed, in your case something like "[Broker] = " & me.Broker

Consider it a sacrifice to the gods of Access you mentioned. Still seems to be a rather compicated way to solve something relatively simple but: if it works don't fix it...

Strange, maybe you're using Access 2000? I thought that didn't use DAO, but might be mistaken (and to lazy to check...) I tried Bob's code, and it runs fine in A97. Even simpified the idea to: Private Sub cmdSave_Click() DoCmd.RunSQL "INSERT INTO tblMyRecords ( recordid, recorddate )...

You can use the 'openargs' to pass information to the form you'opening.

I 'm not sure if I get what you mean, but let's try anyway. You want your combo to show something related to the first record in your form. When a form opens, it opens on the first record. So, if you set the default value of your cbo to the related field in your form it might already do the...

I think you still need a real macro called autoexe. You don't have to rebuild the old one though, just make the macro start your code.

Bob's coding seems to be OK, but it doesn't requery the form itself. Check if the record is saved in the table!

BEWARE! If you calculate a field there is always the risk of getting the same result twice, wich would mess things up rather badly if it's a primary key. Imagine what would happen in a multi-user setting. If you realy must calculate do it when saving the record. Private Sub...

Did you consider converting the macro to VBA?

Probably there's lot of people out there to help you, (I will if my boss or kid don't interfere) but more info is needed: * is there an invitation-list, so do you know in advance who is coming? * what are 'groups'? Companys you invited, or guests who happen to bring there inlaws without telling...

There is function that looks up a value in a table: DLookUp(WhatField;InWhatTableOrQuery;WhatConditions). So you could set the source of your textbox to: =DLookUp("initials";"personel";"id_personel=tasks") However, easier and faster is to make query joining the...

If it's a db you used to devellop in, and you made a lot of changes on the way, it might help to make a new (empty) database and import all objects from your old one.

I'd love to see that too. The syntax you use is obivously wrong, as "msgForm" is a string, and you need an object. Apart from that, I use load and hide in VB without any trouble, but never in VBA: I never succeeded in refering to an unopened form. The object-model is a bit confusing...