Search results

  1. C

    Joining multiple queries

    Hi, Is the third query (the one that joins the previous queries) summing up the number of failed jobs by region, company and workstack? From your data, I'd then expect a result of region company workstack failed Region 1 comp 1 1400 168 Region 2 comp 2 52 168
  2. C

    Send an email with protected spreadsheet in body

    Hi, My users have a small Excel spreadsheet that they mail out each week. Their own users fill in the unprotected fields and then email it back. This works just fine when the spreadsheet is sent as an attachment. But my users think it would be simpler and cleaner if the spreadsheet were in...
  3. C

    adding numbers from two tables

    Hi, Could you please explain the difference between q1 and q2, and a little about the source data? What you are showing is two queries that have the same two fields (fruit and count). Do they represent counts of fruits for different dates or locations, and you are trying to get the overall...
  4. C

    Opening a second workbook automatically

    Thanks so much, works great!
  5. C

    Opening a second workbook automatically

    Hi, Thanks, I've got the workbook open. Dim wkbkMenu_items As String wkbkMenu_items = ActiveWorkbook.Path & "\" & "Menu_Items_only.xls" Workbooks.Open wkbkMenu_items, 3 The problem is that this puts the user into the second workbook. I want the user to be able to keep working in the first...
  6. C

    Opening a second workbook automatically

    Hello, In my main workbook, Costed_Menus, I've set up a drop down list that references a second workbook, Menu_Items. (Yes, we are talking real, food-type menus here.) This works perfectly if both workbooks are open. What I want to do now is to set it up so that when my user opens...
  7. C

    Stretching Vlookup to the max...

    Working solution Hi, I have a solution using VLOOKUP that seems to be working. For each date, for each meal period, my user can enter up to 10 menu items and I needed to put these into a calendar format. When I started, I was calculating where, on my calendar, each menu item goes. For...
  8. C

    Stretching Vlookup to the max...

    Here's a sample workbook Hi, Here's a very simplified copy of my workbook. Sheet 1 in this sample is where I've taken the user input and calculated the calendar locations for each meal item. There's some cells that do date calculations there, too. (In my real workbook, there is another...
  9. C

    Stretching Vlookup to the max...

    Hi, I am pretty rusty at Excel, but I have been trying to create a menu application (real breakfast, lunch, dinner menus). The basic idea is to let the dietitians enter the date, meal period (breakfast, lunch, dinner) and the meal item on the first sheet in the workbook. There's an...
  10. C

    Open Form and have it Alphabetized by specific field, but different field each time..

    I've done this by having the column headings actually be buttons that the user could use to sort. So at first viewing, the screen is always sorted by, say, last name, but then the user could click on "department" and I just resort it for them. It's pretty intuitive for the user this way, just...
  11. C

    Fixed Date

    Wow, I've been accused of hard core programming! Pat is perfectly right about the date. Maybe what you really want is the fiscal year beginning and ending date for your firm, and you will need to keep this year's, and lasts, and you'll want to be able to put in next year's value as soon as...
  12. C

    Fixed Date

    Fixed date Is this is a date that never, ever, ever changes, ever? Or is this a date that maybe changes only rarely (yearly???) If it is a date that only rarely changes, I would put the date in its own table. Then you can use it on multiple forms and/or reports, and when it finally does...
  13. C

    report criterium

    I'm assuming that you want a detail section something like this: Name: John Doe Phone: (123) 456-7890 Other Phone: (123)987-6543 Create a text box. Set Can Grow and Can Shrink to "yes". Then create a control source for it, something like this: =IIf(IsNull([Other_Phone])," ","Other Phone...
  14. C

    Need advice: Word vs. Access

    Hello: Need advice about whether to do something from Access or from Word. What I have is a large number of Word documents that have lots and lots of bookmarks. I need to list all of the bookmarks in each document and eventually compare it to a text file from elsewhere. I have VBA built in...
  15. C

    Import Oracle Database to MS Access

    Have you considered just linking to the Oracle table? That way you don't need to worry about keeping the two tables synchronized. Otherwise, link to the table, write a SQL query to select your records and fields, and use that query as the source of a make table query to create the Access...
  16. C

    School Year - ways to handle it

    If the school "year" changes from year to year you might want to consider creating a lookup table to hold the beginning & ending dates of each "year". You'd probably have a field that would be the academic year (it would contain something like "20022003" and it could be text), a printable...
  17. C

    Page Setups for Reports

    As Rich says, you can turn off Name Autocorrect from code. If your database will be used by other people, that is probably what you should do. But, when you are changing a user’s Access settings, the really polite thing to do is to save their original settings, make whatever changes you need...
  18. C

    Passing Variables between two Access 2000 Databases

    What I have done in the past is to create a table that contains the security information, and to use that table in each database to control what the user can see. The security table has the userid and the database id as its key, then one or more fields that describe the level of security that...
  19. C

    Read two tables and Append to append

    Why not write an update query that does this and then just run that query from code?
  20. C

    Results Grouped in Accounting Month, not Calendar

    I don't know if this will help, but I have certainly worked often with accounting months. I've found that it is sometimes a lot simpler to put two hidden fields (fiscal month begin, fiscal month end) on the form. When the user has made their date selection & hit whatever button, I fill in...
Top Bottom