Search results

masteripper, r u employed as an access developer? if u r not y does your boss say he will sack u?

In the report footer place =Max([DayField])

Dear all, I have a query which outputs to Excel. The results show projects for Project Managers. I then check the data for non conformity and hightlight it. I then want to send the Excel sheet only to Project Managers who projects dont comply. Problem I got is how do I only select the...

Not 100% sure how to do this but I would look to do something like set a count field up to count the number of orders and then grow the detail section appropriate to the count by cm. I'm sure some one will offer a better way!

Dear all, I'm a little confused as to where the syntax such as dots and with statements should be used when I attempt to control excel from access. Especially when I want to format excel cells. Any pointers most welcome Thanks Mark

You can use the following as the last line of the crosstab sql query: PIVOT YOURMONTH In ("1","2","3","4","5","6","7","8","9","10","11","12"); This will fix a twelve month period.

They both use VBA in the newer versions so the answer is yes and i bet there are plenty of links here related to the populating the Outlook Object Model!

What email system do you use? I only ask because many email systems provide what you want and printouts also. Why reinvent the wheel?

Meltdown, Does the contract state the expected response times for loading a form? or are you offering any SLA with the app? If not then there is scope to increase your earnings by offering to investigate the performance problems and offer resolutions?

use a crosstab query. how did you create the one field inside a table which is dynamic depending on other fields in the table?

There are a couple of things you could do, such as place or use an existing field on the main form to determine which sub form is allowed edits or visible? e.g You enter data onto the main form and the sub form frmAirOrder is visible because a field met criteria. if me.txtCriteriafield is...

s0rtd, One point to note is that for example you may have 10 calls for a P1 and 9 of these calls were resolved under 10 mins BUT you the other call took 4 hours. Therefore your average will be distorted by this outlier. Maybe using the median would be better and then create an exceptions...

post the db here or screen shot the query

See if the attached is along the lines

Group by customer, place the data in the detail and add a page break OR you could group by Customer then Orders, place the first lot of data in the Customer header and then set force new page before section on the Customer.

Why dont you say that the level of security required in the system did not nesesscitate using only the built in Access Security, which is most commonly used. Therefore you investigated other security options and implemented the Select Case option. And a recommendation/follow up you may include...

have a look at attached

post the db here and it will get looked at

I have a recordset that store mandays, month and year. I need to group a report so that if an employee has data in 2002 mth11,mth12 & year 2003 mth1 that would be one group. Then they have no data for 2003 mth2 but then they have data for mth3,4,5 & 6, that would be another group. Basically I...

www.mvps.org or do a search on this forum as there are postings from many experts.