Search results

Hey Bob, Just a quick little update on this. I had to change a few things that you had in the code. I figured that I would repost my results. I placed it on the next control's GotFocus. The numbers represent the PaymentMethodID numbers: Charge = PaymentMethodID 2 No Charge = PaymentMethodID...

Thats exactly what I wanted, thank you very much Bob

That is what I want to do, but I don't have the knowledge of how to write the code for that. Could you perhaps offer me a snipit of code.

I have a combo box called cmbPaymentMethod it includes several choices such as: Cash Check Visa MasterCard PayPal Charge No Charge Also I have a field called txtPaymentAmount. What I want to do is if the user picks Cash; Check; Visa; MasterCard; or PayPal and they come to txtPaymentAmount...

Thanks for your help with the conditioning ForeColor property. It works perfect. I modifed it just a bit and here is the result. $#,##0.00" Amount Owed"[Red];$#,##0.00" Amount Of Credit"[Black];"Zero Balance";"Null" And once again I appreciate you taking time to READ my post. Have a great...

What I'm wanting to do should be very simple, but for the love of all things, I can't figure it out. I have 3 textbox's on my MainForm: txtTotalCharged txtTotalPaid txtAmountDue The first 2 textbox's are calculations from Sub1 and Sub2 and Sub3. What I am wanting to do is when txtAmountDue is...

Update to the problem Well, I can't believe it but I found it. I had to go into the regedit and find where it was. Here is the location: C:\Users\YOUR NAME HERE\AppData\Roaming\Microsoft\Access Now this path is on a Vista Ultimate machine running Office Pro 2007. I got a safe or unaltered file...

Well, I can't believe it but I found it. I had to go into the regedit and find where it was. Here is the location: C:\Users\YOUR NAME HERE\AppData\Roaming\Microsoft\Access Now this path is on a Vista Ultimate machine running Office Pro 2007. I got a safe or unaltered file "system.mdw" off of my...

I am running Vista Ult. and Office Pro 2007. I have tried to find the system.mdw and cannot. You said "It is in a place you wouldn't think of." Could you please elaborate on that for me and give me the path that you took to find it. Thank you, Tom

Thanks Banana for the link. I tried to find the system.mdw and can't locate it. There was one person in that post that found it, but they didn't explain as to how they found it or where. If this helps, I am running Vista Ult. and Office Pro 2007. If anyone knows where to locate it please let me...

To whom ever can help. Last night I was going through some of my many sample db's and I think the last one I looked at required me to login. After trying many things to access the db, it occured to me to type Admin and then the password, which I used password. Well, It worked and so I looked...

First of all thanks for responding. I have looked it over and it seems to me to be a little bit on the complex side of things. The following is the way that I see what you are saying. First, build a table tblCredit then make a relationship with tblCustomerDetail. Next, build a Form...

Next time build a query with the table that has the addresses in it and use the following: Address: [Field1] & " " & [Field2] & " " & [Field3]

I have a problem with figuring out how to implement what I call “Paid In Advance”. If a customer pays 4, 5, 6, or 12 months in advance, I for some reason can’t think of how to set this up with tables, queries, forms, and reports. The example that closely matches my db is “Order Entry” from...

Thanks Pat, I had a brain freeze.

To who ever can help? I have a report that has 4 post cards “accounts” on each page. The control source is a table. The post cards have the customer’s info and their service charge amounts. What I need is a way for only the post cards “accounts” with a $0.00 service charge to not show up when I...

I knew it could be done, I just didn't know where. Thanks Pat.

Hi All, Here's my problem, I have a form with a text box "txtINPCD" and a command button "cmdPreview". On the report I have a text box "txtCopiedINPCD" that gets it's info from the text box "txtINPCD" on the form. The control source of the report text box "txtCopiedINPCD" is...

It works perfectly. Thank you!!!!!!!!!!! PS: It was so simple to.

THANK YOU ................ :) That is exactly what I wanted. Ok so if I have the Customer form up and I want to look at the image that is assigned to the Customer account number, I simply apply the code you supplied, to the OnClick event of a cmdButton and it will go and retrieve the image as...