Search results

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

[Solved] Dlookup date criteria that is null hi. i'm assigning and returning thumbdrives using 2 command buttons. so now i want to disable the assign button when they already have a thumbdrive assigned. my code is this: Form_current() Dim HaveThb HaveThb = DLookup("pkThbID"...

I'm trying to track my payments of vouchers in my current database. i have 3 tables that stores the voucher numbers and payment date of the paid vouchers to our clients. and currently, we have an excel file that goes something like this: date received|voucher...

[Solved] Do While ... Loop help hi all, i'm trying to add payment records when my clients' status is pending payment. i came up with this code, but it is giving me an error at this line(highlighted in red), saying that i can't go to the specific record. i have just realised that this happens...

hi all, i'm trying to write a code that checks if the field was modified before popping up a message box. however, i think that the me.dirty is not working here. is it because my [exprTotal] is a calculated field? if it is so, how can i check if the field is modified without me.dirty? code...

hi all, i've a code that returns the flow type based on their average results. my code is this: "qryavgload2" is a query i created, which selects the ID and average. no error came up, but the results are "heavy" for most of the records, even if it should be "moderate" or "light". only...

hi all, i have created query that look like this: example: Name| Date| Project| date-project 1| 10 apr| eggs |10 apr - eggs 1| 10 apr| bread |10 apr - bread 1| 11 apr| chicken |11 apr - chicken how can i make it into like this? example: Name| Date| Project| date-project 1| 10 apr|...

Hi all, I'm working on creating a database, and i've already set up the tables and relations. Right now, i'm stuck on the forms. My idea of forms is just forms with subforms, so you can update all the related data in the same form. But now that i'm designing the forms, i find that my forms...

Hi all, I have 2 tables, tblCustomers and tblTest. tblCustomers CusID - pk Customer name tblTest TestID - pk CusID - fk Test status I want to prevent users from adding a new test status for a customer when he already has a test status. i'm using a command button to create new test...

Hi all, I'd like to know if i'm going in the right direction with normalization of the tables. I've attached the database. Also, i've got a question regarding importing data into this database. I have 4 tables of data in excel, and one of my excel table is a combination of tblCustomer...