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 Chriss Miller 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: *

  1. jdwm2310

    Please Help

    I have a query that will tally up employees with medical elections. I would like the query if possible to calculate the totals. Can this be done??? If so, please HELP! Thanks.
  2. jdwm2310

    Outer Join Query

    Please help...i am trying to create an outer join query. I have two queries one with a criteria to include spouse information and the other without spouse information. How can I join these separate query to create one query?
  3. jdwm2310

    Text Color in Email

    No answer yet. I would appreciate if someone could lend me a hand...thanks
  4. jdwm2310

    Help Multiuser Environment

    Hi created a database which is shared by 5 users. It was working perfectly however something went wrong. The users create tickets however I am not able to view their tickets. It seems that the users are working on an individual database instead of a sharable database. It seems that I lose my...
  5. jdwm2310

    Email

    Hi, I currently send my forms via Lotus Notes. I would like to change the font color of the body text in the email. I want to distinct some text in the message. How could go about doing that? Please review my code, thanks: SendNotesMail "Ticket number " & TicketID & " has...
  6. jdwm2310

    Enabling a CheckBox

    Bigsteve42, Let me explain what I am doing. I have a form call frmHelpDesk. the users use this form to enter tickets. If they click on Route to, the ticket status is "Open". If the user would like to see that "Open" ticket. They go to the Main Menu. In the Main Menu...
  7. jdwm2310

    Enabling a CheckBox

    Hi Guys, I have a form called frmOpenTickets, a user encounter this form from a menu list. This form stores all the tickets that have a ticketstatus of "Open". The user would open this form if he/she decides to close the ticket. On form I added a checkbox stating that "Please...
  8. jdwm2310

    Multiple Parameters

    here is the sql: SELECT HelpDesk.CallerName, HelpDesk.CostCenter, BusinessUnit([CostCenter]) AS [Business Unit], HelpDesk.[Date Call], HelpDesk.Area, HelpDesk.UserName, HelpDesk.[Date Closed], HelpDesk.[Route To], HelpDesk.[Call Source], HelpDesk.TicketStatus FROM HelpDesk GROUP BY...
  9. jdwm2310

    Multiple Parameters

    Hello, Is it possible to have more than one parameter in a query? If so, the query that I am working with will not generate the result for two criteria. When I remove one criteria the query will work by reporting the parameters result.
  10. jdwm2310

    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Ok...I have a main table called tblHelpdesk..here is where the users enter information (i.e.; CostCenter) I want to create a query using the tblHelpDesk and link it with the tblBusinessUnit and tblCostCenter. In this query I want to have a criteria that states "Enter Business Unit&quot...
  11. jdwm2310

    Help with Query!!!!!

    Hi, I would like to create a query that looks up the data for a specific business unit. I have three tables: tblCostCenter - has the costcenter # tblBusinessUnit - has the name of the businessunit per costcenter tblHelpDesk - is the form that everyone will use. The user will enter the...
  12. jdwm2310

    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    zerosandones, On the second table, tblCostCenter, the BusinessUnitID is a number, right? I entered the SQL in the RowSource but when I click to view datasheet there is nothing in the combobox. I entered the BusinessUnitName in tblBusinessUnit. I did everything you wrote: I created the two...
  13. jdwm2310

    Help Me...

    medic133, Thanks for you suggestion. I added some If and then statement to check the form before closing. It works great. Thanks again!!!![thumbsup]
  14. jdwm2310

    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Ok on this everything you said...now how can I get the users to enter the business unit name and see all the records for that particular unit?
  15. jdwm2310

    Please Help Expression is going crazy

    Well when I removed the Criteria. It works but I want my users to specify a business unit. How could i go about doing that??
  16. jdwm2310

    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    zerosandones, I removed the criteria and it works. How could i insert a parameter that will allow my users to enter the business unit of their choice?
  17. jdwm2310

    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    zerosandones, Your comments were well put, I appreciate your help and suggestions. Now I created a table with CostCenter and BusinessUnit. How would I go apply it to my query with a Dlookup function..I want the user to enter the Business Unit. And allow the query to pull up all the...
  18. jdwm2310

    Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Hi, My query was working but now it doesn't work. I get an error of "Undefined Business Unit in expression" My expression is Field: Business Unit: BusinessUnit([CostCenter]) Table: Blank Total: Expression Sort: Blank Show: Blank Critiera: [Enter Business Unit] I created a module...
  19. jdwm2310

    Please Help Expression is going crazy

    I have a query that works great in my other database however I copied it into my current database and it gives me an error stating that "the expression is typed incorrectly, or is it too complex to be evaluated." Here is my expression: BusinessUnit is a module I created...
  20. jdwm2310

    DLookup

    Ok something is not working right probably b/c I am not giving you enough information... I have a form which gets it field from HelpDesk, CostCenter is from this table. When the user goes to create a ticket, and adds the caller name the costcenter is autmatically filled which is obtained from...

Part and Inventory Search

Back
Top