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!

  • Congratulations TouchToneTommy 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: Skins64
  • Content: Threads
  • Order by date
  1. Skins64

    YES/NO Check Box

    Ok, I have a newsletter field then Subscribe/Unsubscribe check boxes. I need to make it so if you check one box, you can't check the other. Does this happen in the table or form, and how? Thanks!!!
  2. Skins64

    Access Form Combo Box???

    I have a table called ItemOrders, it has ItemID ItemName and ContactID. I built a form with a drop down box so that data entry can be done by selecting which item has been ordered, I need to be selecting the ItemID, BUT I need the ItemName to show in the drop box for data entry, how do I make it...
  3. Skins64

    Access 2003 Subfrom Help??

    Ok, I have a database that consists of a Contacts table (general contact data). I have three other tables, Items which consists 10 items contacts can order (free)...this is yes/no check box. Another table for trainings attended. Last table contains a couple newsletters contacts may sign up for...
  4. Skins64

    Cannot open report!?!?!

    We have an Access database on a shared drive, on one machine (in the entire company) I cannot open the report in the database..I can open the table and form in the database buy I cannot open the report. What could cause this? Again I can open the report from other machines without problem...
  5. Skins64

    Trying to Include A Total in Report in Access

    I have multiple Companies and a revenue for each, in my report I need to include the sum of all revenues at bottom...do I use a text box, if so, how do I make it add all of the revenue...please help....thanks!
  6. Skins64

    Ok...One More Try...Update Query

    I have two access tables both contain a field that contains a Work Order #....tblconsulting contains work order numbers that may or may not be in tblsalescredit ....I need to update a field called SalesCredit in tblconsulting with the data in a field called credit in tblsalescredit according to...
  7. Skins64

    Update Query

    I have two tables....I want to update a field called Inv# in table "Consulting" with the data in a field called Invoice in table "SalesCredit"....what woyld the update query look like? Thanks!!!
  8. Skins64

    Try this again, query.

    I have a field called "Dear" which contains "Mr Smith" "Ms. Jones" etc....This field also contains preferred names like Bob or Ted or Buck. I need to update a field called "Preferred Name" with contacts who have a Bob or Buck etc in the "Dear" field. Do not want to update preferred name with...
  9. Skins64

    Update a field from another?

    I have a field called "Dear" which contains "Mr Smith" "Mr. Jones" etc....This field also contains preferred names like Bob or Ted or Buck. I need to update a field called "Preferred Name" with contacts who have a Bob or Buck etc in the "Dear" field. Do not want to update preferred name with...
  10. Skins64

    IIF Statement

    Help Please....probably is simple for most of you. I have a field called Public...if the company is Public the field returns a P if it is Private then it returns an N and if it is blank then of course it is blank. I need to write a IIf statement the replaces fields that contain the letter P...

Part and Inventory Search

Back
Top