Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aliceapraham
  • Order by date
  1. aliceapraham

    opening an email application within a form

    Hi, I need help again guys. I have a form, & I want to put a comand button in it, so it when the user clicks it, it opens an amail (Outlook for example)application & lets him send that specific record (page of form) to a specific email address. can it be done, & how? Thank you Alice
  2. aliceapraham

    How to make the Property box go away

    Hello there ya Aceman1, I DID IT, thanks a million. I don't know what I would've done without you guys & bthis beautiful fantastic site. Thank you again & here is a star for u. Alice
  3. aliceapraham

    How to make the Property box go away

    I have this form as startup, I have it coded DoCmd.Maximize so that it maximize but the property box always opens, I need to put a code so that it doesn't show, unless I open it myself. ANy Help??? Thank u. Alice
  4. aliceapraham

    put a calculated field frm a form in a table

    Oh.... now I get it thank you MajP, & all who were trying to help. So I can save that field in a report, but will it be saved in the form also everytime i open it up? & new records added. Alice
  5. aliceapraham

    put a calculated field frm a form in a table

    gadget3302:Your posting was intresting but i couldn't ymake it work. i put a cmd button, & that button should take FROM the FORM I have a field called calculated (which does the calculations in it), I want that field to be referenced (PUt IN a Table) . Tbe saved in a table How do i do that? Alice
  6. aliceapraham

    Lock a date in a form

    I have a combobox for customer that has a Row Source: SELECT [Customers Query].CompanyName, [Customers Query].BillingAddress, [Customers Query].City, [Customers Query].StateOrProvince, [Customers Query].PostalCode, [Customers Query].FirstName, [Customers Query].LastName FROM [Customers Query]...
  7. aliceapraham

    Lock a date in a form

    SELECT PriceTable.PriceID, PriceTable.Service, PriceTable.Price1, PriceTable.Price2, PriceTable.Price3, PriceTable.Price4 FROM PriceTable; This is my Record Source of my form
  8. aliceapraham

    Lock a date in a form

    Yes, it has but it's grabbing from one table only, which is the product table. But i also have fields in it that's grabbing from the customer & employee tables, (is that wrong). LAice
  9. aliceapraham

    put a calculated field frm a form in a table

    I don't want to put a calculated field in a table. The calculated field is in my form, but i want to put the result of that calculation in a table, that's the problem. Alice
  10. aliceapraham

    Lock a date in a form

    actually my form is not based on anything , it has several field from several tables, & I want to bound it to drop couple of their fields in a specific table (which i couldn't).so the date field is stande alone thing, which actually i have a field in the order table i can link it to, but it's...
  11. aliceapraham

    Lock a date in a form

    ok got u, but when I'm hooking it up in the control source with the date in the Ordertable, it's giving me #Name? error I don't know why. any suggestions? I know I'm doing something wrong. Alice
  12. aliceapraham

    Lock a date in a form

    What I understood is that it will be 2 dates fields, right? but i only want one field that doesn't change after i put the date in it, (actuallly i want the date to be put my the computer not the user). but pls will u tell me what is those codes.. it might help me understand more.\ thanks Alice
  13. aliceapraham

    put a calculated field frm a form in a table

    i have a form that has records from multiple tables, like Companyname (table), Salesman (table2), Products (table3), now, in my form i have a calculated field, that has the product, Wty & total so i want that form to be saved in a table (which will be (Table4), that has Total, product Qty fields...
  14. aliceapraham

    Lock a date in a form

    Hi, I have a form that has a date in it =Date() & i want to lock it, as whenever i open the form I don't want it to give me today's date, I just want it to give me the date that it was formed that page. Like I opened a new records today, so it will right today's date, but then totmorrow when i...
  15. aliceapraham

    Multiple line of products

    pls somebody answer me cause I'm desperate. thank you
  16. aliceapraham

    Multiple line of products

    OK the Qty field has: Private Sub Qty_AfterUpdate() Call PriceGrabber End Sub This is my Price grabber code: Public Sub PriceGrabber() If Trim(Me!Service & "") <> "" And Trim(Me!Qty & "") <> "" Then If Me!Qty > 0 And Me!Qty < 10001 Then Me!Price = Me!Price1...
  17. aliceapraham

    Combobox updates.

    It's ok It worked. I'm gonna post another question in another posting, if u could help there. Thank you again Alice
  18. aliceapraham

    Combobox updates.

    Ok, The error code is 2448. My After update code is: Private Sub Combo35_AfterUpdate() Me![Address] = Me![Combo35].Column(1) Me![City] = Me![Combo35].Column(2) Me![State] = Me![Combo35].Column(3) End Sub and it highlights the first line: Me![Address] = Me![Combo35].Column(1) what am i doing...
  19. aliceapraham

    Combobox updates.

    well this didn't work it's giving me an error, i don't know why, I also tried renaming the fields that you wrote to: Me![Address] = Me![combo53].Column(1) Me![City] = Me![combo53].Column(2) Me![State] = Me![combo53].Column(3) As My combobox's name is [combo53] & the txtboxes are [Address]...
  20. aliceapraham

    Combobox updates.

    it has an sql query code which is : SELECT [Customers Query].CompanyName, [Customers Query].BillingAddress, [Customers Query].City, [Customers Query].StateOrProvince, [Customers Query].PostalCode FROM [Customers Query]; So what do u think what should i pu in the afterupdate code? Alice

Part and Inventory Search

Back
Top