Search results for query: *

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

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

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

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

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

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

SELECT PriceTable.PriceID, PriceTable.Service, PriceTable.Price1, PriceTable.Price2, PriceTable.Price3, PriceTable.Price4 FROM PriceTable; This is my Record Source of my 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

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

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

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

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

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

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

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

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

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

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

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

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