Search results

Hello, I am trying to update a field and I am having a hard time doing it. I have two tables, tblInvoices and tblPmtDetails. I need to update the field InvPmt on the Invoices with the Sum amount of payments in tblPmtDetails "Field name AmountPmt" for that specific Invoice. I have this done...

Send me the excel file and tell me what you want to do.... I will try to get the results you want to have.... Daniel

Extacly what I wanted to say!!!! :O!!!! DOC is right use a form, access works with forms for data entry, meaning is better that way. This is what I was trying to explain, I thought you did have a form, didnt read good enough what you posted.... Thanks DOC, I am trying to help but need...

Ok, How are you populating the field Sex? Do users type in the sex or they pick it from a list? Daniel

Hello, each column in access is a field of your table. I think this is what youe doing, you have a field name cost, you want that cost to be added 500 if the field Sex=MAle right? Ok just do the following, if your Sex field is a combobox, "meaning you pick from a list" just goto events...

Hello, I have created a dlookup field on a form and a calculated field that calculates the number on the lookup *2. Now when I first open the form on data entry there is no record selected so I get en error on the fields. This is because there is no data yet. So how can I get rid of the error...

Hello, I am going crazy trying to set some bookmarks on word_07 to get some data in there from access. Pat had giving me a sample database with the bookmark example. I was able to make it work with the lease we were using.. Now Management changed the whole lease again!!! I have tried to make...

Hello, I have an issue with my DB. I created a form from different tables. Lets say I have a Client Table, Invoice Table, InvDetail Table and a Product Table. Relationships are; One to Many from Client to Invoice, Many to Many from Invoice to invoice Detail, Many to Many from Invoice...

Thanks Bob and Colin, I have modified the DB and its better the way you say.... I will post a new thread for the problem i see right now... Thanks again, Daniel

Hello, Thanks I knwo understand. Now I have another issue, I have created the main form and subform for the Leases, this is the setup or better yet I will upload the DB. Ok when I create a Lease I first fill out the Main Form, now it should not let me save anything on the main form if there is...

Ok, I understan that we should not use the autonumber as a PRIMARY KEY ON THE TABLE... I created a table that has a LeaseId and its the primary key on it. Now this number should only increment when you create a record right? Well this is happening to me, I open the Lease Form, the Lease...

Hello, Any business programmers out here?!!! Need a code for an access application am doing, is anyone interested? Please contact me at jdcallejas(at)hotmial.com.... Its not a hard code I just dont know much code and want to finish this project.. this is all i got left.. Thank you all!!1...

Hello, I am designing a database on MS Office 07, I am doing the forms but when I go to View the form it opens the form but it opens the whole page!! and cant resize it to be the size of the form I made.. In 2003 this can be done I guess there is a way in 2007!!! Thanks, Daniboy

Ok!!! I give up!!! jajajajaja I have been going crazy with this invoice issue... I think am not going to use INVOICES!!!!... I think I am going to just input payments with out invoices... More like receits... I am thinking of linking my payments directly to my leases. Then the user will pick...

Hello Mr.Wilkinson Yes I live in Gainesville, "The Swamp" jejeje, I also have family in Live Oak, what a small world!!!. Ok, I deleted all my leases and just created two leases with one tenant on each lease. I checked my combox to make sure everythig was written correct and still have the...

Hello Mr.Wilkinson, This helped a lot, thanks and sorry I hadnt reply to give thanks but i was still modifying this on the DB... I created the sunform based on the juctions table you created for me. I have the invoices come up from a combobox and then I manualy apply the payment. So far this...

sorry here is the db

Ok guys, I have tried to do this but am lost, I put my db back to where I have been stuck... I have an invoice and an invoicedetail tables and I have my payment table, my payment table has no relations at the moment, this is where you come in, I AM SO LOST please look at my db and help me figure...

Thanks Pono1 for your response, Well, I am not sure how to deal with this issue, I do not have a juction table on this program but I will put one if is necesary. What i have is a table called payments that it only relates to the client who is paying, I then thought I would run a code or query...

Hello Everyone, Ok, this is going to be long, I am going to try to explain what I want to do, here it goes; I have a table invoices and a table payments, what I want to do is somehow take the payment amount of client and if the payment amount is larger than the client invoice amount, update...