Recent content by voslica
-
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... -
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? -
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 -
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... -
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). -
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? -
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... -
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
-
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... -
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... -
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... -
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?