Search results

  1. V

    Question Code to send appointment from Access to nondefault Outlook calendar

    Can someone send me the code that will send an appointment from Access to a nondefault Outlook calendar. I know the code to send it to my own default Calendar...I just don't know how to change the code to make it go to another folder. I created a calendar in Outlook that contains all of our...
  2. V

    Assign a Row Number

    Attached is a sample document
  3. V

    Assign a Row Number

    Would it help if I attached a sample document of what my table currently looks like and the result I am trying to accomplish?
  4. V

    Assign a Row Number

    The ultimate goal is a Table
  5. V

    Assign a Row Number

    and I can't use a crosstab query because it returns blank values in some of the columns...I need them to all start on the left hand side of the query
  6. V

    Assign a Row Number

    I'm sure I'm going about this the wrong way. What I'm trying to accomplish is turning my rows into columns. My original table has the addresses listed in rows and I need to get the addresses into columns.The end result is to have a table that will look like this: ID --- Name --- Address1...
  7. V

    Assign a Row Number

    How do I assign an autonumber in a query?
  8. V

    Assign a Row Number

    ID = Person's unique identifier in table Address = Unique address of person Count = Assign a number to each address row (begins with 1 each time the person ID changes).
  9. V

    Assign a Row Number

    Yes, it's ID, Count, Address. I'm trying to get a unique identifier per row per person. Each time there is a new person in the row, the Count should begin with 1. Does this help?
  10. V

    Assign a Row Number

    I have a table that contains a person's ID and their address (there may be multiple addresses per person). Each row of the table contains a different address. I am trying to assign a row number per address for each person (Address Count). Here's an example of what I need it to look like: ID...
  11. V

    I have a table that contains a person's ID and an address field. There may be multiple...

    I have a table that contains a person's ID and an address field. There may be multiple addresses per person. What I would like to do is have a table or query that will return a Row Number for each respective address...should look something like this... ID Address Count Address 1...
    • voslica
    • Profile post
  12. V

    Subreport Page Setup in Report

    Unfortunately that won't work. There are 150 associates where the 3 reports need to be in sequential order by associate of which will be put into a binder for Executive review. My hope was that the printer would print each report on its respective color paper without any manual intervention...
  13. V

    Subreport Page Setup in Report

    But here's where I think the macro may be a problem (and correct me if I'm wrong)...each subreport contains associate information for many associates. When the master report runs, it groups each subreport by the associate name thus printing all 3 subreports for that associate, then the next...
  14. V

    Subreport Page Setup in Report

    Hum, views on my question but no responses. Come on you techy guys/gals...surely there is script that can be written that will allow me to do this. If there's not, can you respond stating that I'm out of luck and this can't be accomplished and that I will have to find another way to accomplish...
  15. V

    Subreport Page Setup in Report

    I have 3 subreports in 1 report. I would like the first report to print from tray 1 (white paper), the 2nd report to print from tray 2 (yellow paper) and the 3rd report to print from tray 1 (white paper). Can this be done?
  16. V

    Combine seperate date & time fields

    try using Format([new date],"mm/dd/yy h:m") where [new date] is your combined date and time fields
  17. V

    Running a module from a macro

    I'm looking to do the same thing. Did you ever find out how to run a module from a macro?
  18. V

    Switchboard

    Hope this helps! Question 1...When I make a switchboard is there any way you can go to a table? or can you just go to a form or query?" - I create a macro with a procedure to open the table. Then I choose "run macro" as the command of the switchboard item. Question 2..."and when you make a...
  19. V

    DateDiff Problem with Hours

    Please tell me why Access and Excel are calculating the hours this way... The number of hours between 18:00 hours (6:00 p.m.) and 24:00 hours (12 a.m.) should be 6 hours. Access and Excel are both returning a datediff value of 18 hours. If I change the end time to 12 p.m. (12:00 hours), then...
  20. V

    Data Access Page on Intranet

    I am putting a data access page on our company's intranet for multi users to enter data into one main table (could be up to 100 users - and I am not sure how many users would be opening the page at the same time). Are there limitations on how many users can open the data access page and enter...
Back
Top Bottom