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

  1. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    Argh-- one problem. Now that I populate this, it is showing all products in the database no matter which client I am viewing on the form and not highlighting or indicating which products the client is in. This is my .sql: SELECT Products.Product, Client_Overview.Client_ID...
  2. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    Thank you! I believe the first cut of the database is final, and I'll work more to get a better grip on the query function so that I can cut data in more ways.
  3. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    I used the wizard to set it up and I now show both joins. However, my results list every product entry in the database--one product shows up 26 times instead of the products associated with one client ID showing up. I assume I'll use the query for the listbox. This is the SQL as I have it...
  4. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    Thank you all for your help. The database is 85% of the way there and I am working on the first major form, which will be the main interface and data management place. All my fields work perfectly except the pesky products, which still displays only one product per client, not all the products...
  5. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    To link the Products and RM/RM support, I made a Product_Overview Table: Product_OvID Product_ID RM_ID RM_SupportID I think the quarterly report information belongs here as well and added those accordingly. Am I wrong? Chris
  6. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    I will add the numeric IDs and rearrange the tables as suggested, but I think I need the consultant_contact on the client_table as well since it is a contact specific to a client just like the "primary_contact" and "secondary_contact".. Answers to questions: Client_Visit(Schedule)...
  7. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    Here is the full database structure. Primary Keys I denote with an *, Foreign keys I denote with a # For reference, Clients may or may not have a consultant contact, so they are a client field along with the primary and secondary contact. The products table I list a product and the services...
  8. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    pwise, I keep getting the error "The number of columns in the two selected tables or queries of a union query do not match. (Error 3307)" This is the code as I entered it: Select 0,"Fund" from Products UNION select Fund from Products; Products is the table, Fund is the only field in the...
  9. cbpwc01

    Selecting multiple entries in a field Access 2003 -- I am rusty

    I am creating an Access 2003 database, and I haven’t built a database sine 2005 so my skills are very rusty. My main table is set up with the following fields: Client_Name Product Consultant Consultant_Name Primary_Contact Secondary_Contact Notes The field “Product” is set up as a lookup from...
  10. cbpwc01

    Inserting multiple slections from form list box into main table

    I am working on designing a database at work and have the following tables: Main Table Article Name Publication Article Date Hyperlink to PDF Summary GP Client Topic Topic Table List of Topics I can categorize articles into Client List of...
  11. cbpwc01

    Hiding Labels in cases where the value is "null"

    I am running a report from a query of 50 individual datapoints, the results stacked vertically. I have set both the details section and each individual text box as "can shrink". Since the data is stacked vertically, the can shrink fundtion will not delete the labels. Is there a method to get...
  12. cbpwc01

    "Greying" out a button when using its macro

    I have a forms with two buttons linked to macros--one that put the form into "edit mode" and one that puts the form in "view mode". I want to have the button that is in effect to have the font appear a diiferent color. For example, when we are in edit mode, the text on the "edit mode" button is...
  13. cbpwc01

    Making a drop-down query criteria

    try eliminating any spaces in your table headings as sometimes access will not process them. for example, change [Data - Job Data] to [Data-JobData] Just a thought. Again, probably not the best solution.
  14. cbpwc01

    Making a drop-down query criteria

    You can also try this: Click the criteria cell under the field "industry". leaving the cursor in that cell, go to the top toolbar, click on query, and then click on SQL specific. Copy and paste the SQL codes from earlier in this post (adjusting names, etc), and hit enter. This is how I managed...
  15. cbpwc01

    Printing Text Box on form

    I have a complex form comprised of two subforms linked to queries, a data entry subform that links directly with a table, and a text box where users have to explain differences in the displayed results (the calculated allocations) and their entered allocations. I need to be able to print this...
  16. cbpwc01

    Error in SQL for Query of Crosstab

    Beautiful! My brain was fried so I was having difficulty writing this. Thanks!
  17. cbpwc01

    Error in SQL for Query of Crosstab

    ...PMFI, PMFII and WCMRT. The code I have thus far is as follows: SELECT [TypeCrosstab] , TypeCorsstab.aurora , CInt([aurora]/TotalofAllocation)*100, TypeCrosstab.PMFI , CInt([PMFI]/TotalofAllocation)*100, TypeCrosstab.PMFII , CInt([PMFII]/TotalofAllocation)*100, TypeCrosstab.WCMRT ...
  18. cbpwc01

    Making a drop-down query criteria

    Thank you both! Its up and running--I had put in the wrong name as the combo box, which is what took so long.
  19. cbpwc01

    Making a drop-down query criteria

    Thanks to both of you for your help. I'm creating the switchboard now and will set it up to open the form before you can run this query. I will keep you poseted on how this progresses.
  20. cbpwc01

    Making a drop-down query criteria

    Tranman, Sorry, I will specify. I keep getting "The expression you entered contains invalid syntax", but each time I change or alter the entry, I get the same response. The form is not open when the query runs, do I need to add a command to open the form before the subquery runs? Thanks!

Part and Inventory Search

Back
Top