Search results

Shipped is the name of the checkbox but i dont know where n hot to fit it. I tried using it but in vain

Home is the name of t he Form Customer is the name of the field too pen the forms of that particular Customer aa is the field on current form here I click n it takes me to the 2nd form

Im trying to click on Customer name on the form and it takes me to "all" the forms related to that particular customer. I have two types of records for each customer i.e. Shipped orders & Pending Orders. No I want to have separate code or buttons for it. when I click on the Customer name under...

any way around?

Do I need to put condition on the particular field? I have no condition on that field. Any idea how to achieve this?

Hi friends I have one report that is based on checkbox. If checkbox is ticked, it reflects in the report. Now the situation is that e.g. I got a report of ticked checkboxes today. Now for tomorrow I only want the report of new entries and not all. What condition should I put in query. Plz...

Thanks for that code. i tried that but it send all the records whereas I only want the current/ opened record to be emailed. Any solution for that?

Can u plz elaborate. Whr is that function n how to use. Im not too well versed with Access

Hi thr I want to know if I can get an email form button on my access form. I have an access form and sometimes I would need to email via outlook a particular form. I want a button for that. Kindly help me out.

I tried that in control source of [my field] but I didnt get anything.

Whr shd I enter this? In query?

Hi thr I have a checkbox (yes/no) in my form. Is it possible to display this as yes in report? If yes, how? Any help is appreciated. Thanks in advance Khushi

Ok I got the visible property and set it to No for the new unbound box. Now i would need to copy the entry automatically to the unbound box. How to achieve this?

But how to achieve that. Where can I get the visible property and how to copy the data there automatically. I liked ur idea but being a novice, need a little more detail plz. Thanks

The data entrants will enter digits in Ref and as soon as they press enter, it will be converted to the code. Now how can I copy the exact same number automatically to the unbound textbox Because I dont want them to enter twice.

No, I need to make the Ref field visible on form n the unbound invisible on form. Because I dont want the data entrants to see the pricing. ref is actually pricing so we have coded it.

This seems to be a good idea. So u mean to say I make an unbound field on the form and make it invisible and then in the report I display that field instead of the original Ref field??

Private Sub Ref_AfterUpdate() Dim LResult As String Dim L1Result As String Dim result As String result = Me.Ref.Value LResult = Replace(result, "1", "E") L1Result = Replace(LResult, "2", "Q") L2Result = Replace(L1Result, "3", "B") L3Result = Replace(L2Result, ".", "/") L4Result =...

I want this in report only. So where to use the replace function. Please elaborate a bit. Thanking you

I used a Replace function in the afterUpdate event of a form which replaces 1 with A, 2 with B and so forth. So if I enter 12 and as soon as I press enter, 12 changes to AB. Which is fine, sthat is required. Now for the report, I dont want it to show AB, I want it to show the original 12. Is it...