Recent content by sunset1215

EDIT: I browsed around on amazon, read some reviews, and saw these books. 1. Alison Balter's Mastering Microsoft Office Access 2007 Development 2. Access Database Design & Programming, 3rd Ed. (Steve Roman) 3. Access Cookbook, 2nd Ed. (Ken Getz, Paul Litwin, Andy Baron) I want to start...

Hi all, I want to learn more about Access VBA. Are there any books that are like textbooks? For example, there's a topic on recordset. So there's some explanation of what it can do, how it should be done. And at the end of the topic, they give you some sample scenarios to let you work out the...

hi speakers, i wonder if you could help me again? i followed your suggestion and have started making the changes to my database. the setting of allow edits/additions to false works, however, 2 of my forms have a combo box filter. setting the allow edits to false makes me unable to select values...

i just saw your edit. by holding the credentials inside vba, do you mean like below? EDIT- ah, i just realised that you meant i should not code it in vba. my bad. so it's good to create a table after all, right? dim user1 as string dim pass1 as string user1 = username pass1 = password...

actually, my database only deals with info on clients. it's a small database. thanks for your suggestion! i'm really grateful for the help! :)

oh! haha! yes, it sounds really simple. for the validation of username and password, i have to create a table that holds the usernames and passwords? a side question: i've splitted my database to BE and FE. if and when i have to create more tables, i have to go to the BE and create them?

how can i create this? is there a sample i can download or website that helps with this? if you would tell me what i would need, i could create it myself.

it would be best to create user groups with different access levels, but i would seriously need a step by step guide to help me on that. i've set a password for the BE file, so i think it's ok for it to be in the shared drive. about the FREE Runtime 2007 license, i guess it's an external...

hi all, i have almost completed my database and is now considering how to implement security. i created my database using 2007, so i don't think i should convert to 2003 just to use the user-level security. actually, for this database, i am going to be the only user who is updating the data...

Hi, from your forms, i would assume you have 2 tables, tblSitesMain and tblSitesAccounts. you said this: i don't think this makes a difference, but is your tblSitesMain and tblSitesAccounts linked in a relationship? they should be as you have fkSitesID in your frmSitesAccounts. when you...

hi, this might be the problem. instead of this: stLinkCriteria = "[fkAccountID]=" & Me![pkAccountID] you need a space, so here.. stLinkCriteria = "[fkAccountID] = " & Me![pkAccountID] your form names also, if there's no space at the end, u should remove it.

i've thought about this myself over the weekend, and this is what i came up with for my database. i will have 3 tables. tblTransactions pkTranID fkCusID Payment Date tblGroup pkGrpID Voucher Type Voucher start number voucher end number date received amount tblVouchers pkVoucherNumber...

first off, i have to say i'm really happy you're willing to help. big thanks to you! ok, now to answering your questions. Actually, i have split them into 2 fields. VoucherType and VoucherNumber. The field VoucherNumber is a text field, as the NTUC $5 stack starts with zero. Currently, we...

after some trial and error, i got it to work. i apologize for not thinking more thoroughly before posting. edited code here: Form_current() Dim HaveThb As Long HaveThb = Nz(DLookup("pkThbID", "tblThumbdrive", "[fkPerID] = " & Me.pkPerID & _ " And IsNull([dtmThbIn])"), 0) If...

some additional info: i can pay out multiple vouchers to a client in a single transaction.(as the value of each voucher is only $5). when this is the case, i would think that tblVouchers would have a fkTransactionID. however, it is not possible to have transactions without any vouchers, so...