Search results

Printer Are you sure you still have a printer set for default in your control panel>settings>Printers? Can you print a Word Document?

Adobe See if this helps.... http://kb.iu.edu/data/ajpo.html

I created a table with a date field. ADate=12/31/2006 in this format. I then created a query as follows: expr1: Format([adate],"dd/mm/yy") expr2: DatePart("ww",[adate],1,1) I made a report grouping on expr2 in ascending order and it worked fine on my end. Doin it this way is OK as long as it...

count You could use a subreport which uses your entire table and not just those dates used in the criteria. Hope this helps.

joins Are you using a left outer join on those queries?

Database Mick, When I get into work this week I will set some time aside to go through your project. Good luck with it. Rick

records I went back to that link on got the same thing you did. I will do from my pea brain memory Place a textbox called textboxcounter in the detail section of your report. set it's control source=1. Set the running sum to Over Group. In the On Format section in the Detail of your report...

records See if this helps: http://www.experts-exchange.com/Databases/MS_Access/Q_21824417.html

uhmmmmmmmmm What you talkin' bout Luis?

fields After adding a field to your table you have to go into design view of your form, add a text box with that field as the data source.

days There are a few ways to do this. You could use the On Print of the Details section of your report to read: If [theday]="Saturday" or [theday]="Sunday" then [theday].forecolor=whatevercoloryouwant else [theday].forecolor=blackorwhatevercolor end if

open file Here is a post from the OLDSOFTBOSS............ I use the following on a cmdButton or double click event: Dim strProg As String Dim strFile As String 'Open File strProg = "C:\Program Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe" strFile = Me.FilePath 'Where Me.FilePath is the...

second largest Found the following for you on the Internet: For example, if you have a spreadsheet with the following values: A1: 11 A2: 92 A3: 45 A4: 28 A5: 37 To return the 2nd largest value of the series, which would be 45: =large(a1:a5,2) To return the 2nd smallest value of the...

formula Place a text box in your inventory detail form footer with the following as it's formula:=Forms![inventory detail]![Inventory transactions].Form![Units in stock]. Almost forgot, put this formula in your Units On Hand in your subform(replace what you have with this) =Sum(nz([Units...

large Did you try MAX(A1:A20) for whatever range of cells?

Labels Most companies I have been at typically only use between 1 and maybe 5 or 6 different types of labels(sizes) . What I have done in the past is just create 5 or 6 different label reports such as report1,report2, etc. Since labels contain a small amount of data this takes very little time...

pages Well, you could use [Pages]-1. Then in the On Print event of the Page Footer you could hide the ="Page " & [Page] & " of " & [Pages] if [Page]=[Pages]

I feel your pain I worked on something somewhat similar with an individual that owns a small business. He was unable to send/receive emails after a restart of the PC. He had Outlook Express and MacAffe anivirus. What was happening is that after a restart his POP3 was resetting to the internal...

Examples Take a look at the Order Entry and/or Inventory database that comes with MS Access. This should give you some ideas.

report I have attached a file that shows what you need to do. In this folder are 2 pictures and the testing db. Copy the folder MyPics to your C: drive. Open up the tesing db and the pictures will correspond to the unitid. Look at the On Print Event of the detail section of the report to see...