Search results

  1. K

    Combo box

    Hello. I have a combo box on my form in access 2007. It only has 3 choices in the combo box. How can I get the button below the combo box to only show the records that are listed in the combo box at that time. Like if F41 is selected, I only would like to see all the records that go to F41 at...
  2. K

    Relationships

    I have a problem with my query. How can I connect two tables with different fields. One of the tables has the date information and fiscal week. The other table has the # of units recieved. I created a date field in the table with # of units received to match the other. I have created a...
  3. K

    "Type in mismatch in expression"

    What is wrong when I see this error message? I was tryng to run the query I created and this popped up. I needed the query to use two fields a po received units field and a fiscal week field. Could this be the problem? If so, how can I fix the query to show me the # of units received by the...
  4. K

    Button Form

    I need help creating a form with a button that will export to excel once it is clicked. What are the appropriate steps to take? I have already created a form with a button up there. I need to know what do I need to do to make sure it exports to excel once it is clicked. 1. Do I need to do a...
  5. K

    query math

    Can someone please help me understand how to get a query to math calculations? Ive read several post and it seems that people have queries do the math for them but never say how or what steps they take to get that. Access is not my friend as of right now. The query would need to do this on a...
  6. K

    building a query.

    Hello. How can I build a query in access to show the # of units by warehouse and season description? The data comes from two different sheets in an excel spreadsheet. One called PO Status report and the other called season lookup. Any help would be greatly appreciated.
  7. K

    updating daily table

    Hello. I was asked to do a data project in access. I have no clue how to do this. I have never worked with access but have experience in the other ms office suites. The first thing I must do is setup a daily import process for a sheet in excel called PO status report. The sheet has 5560...
  8. K

    Clueless!!

    Hello! I need help creating a form in access. The form needs to have a button that can be pressed to export to excel # of units received by fiscal week whih comes from two different sheets in excel. One sheet is the master dates which has all of the fiscal weeks in it and the other is the PO...
Back
Top Bottom