Recent content by fvd

re Thanks for the tips, but as i said previous, i'm a total beginner with VBA, so could you tell me a bit more specific how i should edit the code to use the BCC field? And about the other question of mine: i know there are ways to put all the mail-adresses in the To or BCC field separated...

Hi, I use the code below to send e-mails, but i would like to make some changes to it. First problem is that i send e-mails to different people, let's say 10 persons, but i need to click on the "Send"-button in Outlook for every e-mail (so 10 times). What do i have to change in this code to...

Hello, Please excuse me if my question already exists is this forum... i'm not familiar with VBA (unfortunately) so i've made my entire database with macro's and queries instead of VBA-code. But now i have a problem that cannot be solved with a macro, so i need some VBA-code that i can use. I...

What exactly do you mean with the BeforeUpdate-Event? And how do i have to use it? Thank you for your help!

Hi there, I have a form (let's call it form1) on which it isn't allowed to skip a field, they all have to contain some data. But putting those fields in the table to required is not an option because there are other forms based on that table on which it is allowed to skip some fields (because...

Hi there, I have the following problem; Sometimes when i try to open a form i refuses to open and i get the following error: "You are trying to lock a table at opening, wait a few moments and then try again" but waiting and trying again won't help :( The only solution so far is closing the...

Hi There, I have a example of a query that makes a backup of a table: SELECT Persons.* INTO Persons IN 'Backup.mdb' FROM Persons But i would like to make a copy of ALL of my table's, so i tried something like this: SELECT * FROM Persons, Inventory INTO Persons, Inventory IN 'Backup.mdb' FROM...

No, i am the only user and for all i can see, the other tables and forms are closed. So i don't know the cause of this problem. (yet) :)

Hi, sometimes when i try to open a form i get an error (i'll try to translate it correctly from dutch to english...) that says: "you are trying to lock a table by opening, but the table is in use. Wait a moment and then try again." Does anyone know the reason, or the solution? Thanks already.

Hello, I've compacted my database, and now i have a form (it's my main-form on which i have placed commandbuttons that opens all my other forms) that doesn't open anymore. Not even in edit-mode, so can't reach it anymore! I really don't know what could be the problem, i compacted several...

Hi Neil, Thanks for your reply, i'll certainly think about it the next time i make a database!

Hi there, I've made a database with 5 tables, bud did not make any format's or input masks there. But now that all of my forms and reports are finished, i tried to fill them in in the tables. But the forms and reports did not take them over (if i look in the properties of all the textfields...