Search results

Just an idea but how about using the OnFormat event of the report to set the picture code? (Very much like setting the font etc. in an earlier post)

The easiest way is to create a form where the users select the criteria that they want to report on. This criteria is then passed to a query to limit the number of records and then final report uses the query as its feed

Looking at your statement you are trying to sort by a field that isn't there. In the select statement the field is Required Date whereas in your order statement it is Required Ship Date. Do you have a field elsewhere in On Tim Shipping Subform that is called Required Ship Date?

Create a duplicate date field so you have Datefiel1:Format([Next Insp Date],"mmm-yy") and Datefield2: Format([Next Insp Date],"mm/yy") and sort on Datefield2. You can uncheck the datefield2 Show box so that it isn't visible but it will sort it in the required order. HTH

The way to do it is change the date field bit being formated "mm/yy". Have called it Mnth in example SELECT [Surveyor Name], Format([Next Insp Date],"mm/yy") AS Mnth, Sum([SumOfIU's]) AS [SumOfSumOfIU's], Sum([SumOfIU's]/23) AS Expr1 FROM [Work Due Grouped qry] GROUP BY [Surveyor Name]...

One way of doing this is creating a query based on the information that is being fed to the report, which counts the number of records and then use that to feed your summary report. Think that you will need one query per main report and then union the reults together to feed the summary HTH

In the OnFormat event of the Detail section use this code: {Using txtNumber as the name of the textbox} If Me.txtNumber < 0 Then Me.txtNumber.ForeColor = vbRed else Me.txtNumber.ForeColor=vbBlack End if HTH

I agree with Jeff's comments. If it was created at your present place of employment then you need to check your work contract and the staff handbook to see if there is a section on Intelectual Property. Nowadays most companies will have a clause in the contract saying that any ideas that you...

If the database is an MDE file then no go Otherwise try Window / Unhide and see if that shows up the main database window. Failing that look at the security settings. If it is password protected then you will need to search for a program that can decode passwords!

If you are trying to get all records which have the word ADEL in the field 'Group' then all you need to do is: stSQL = stSQL & " WHERE ((Year([ImplementationDate]))= " & CInt(txtSelectDate) & ") And ((tblChanges.Group) = 'ADEL')" If though ADEL is a string variable that you have assigned a...

shot in the dark try: Set rst = db.OpenRecordset("qryCreateForm",dbOpenDynaset)

MyDate = txtSelectDate stSQL = stSQL & " WHERE (((tblChanges.ImplementationDate)=#" & format(MyDate,"mm/dd/yy") & "#));" HTH

The module name cannot be the same as that of Functions, Subs etc Rename the module PublicFunc or something and it ought to work HTH

First: Your database really ought to be redesigned. You should have a table with an ID field and the computer details eg asset number, serial number etc. Then you should have a table with Comp_ID and Software. This table would then have 10 records per computer (if there are 10 pieces of...

The order in which they are sorted is by the furthest left of your fields. So if you want to group by date and then within the date you want to sort by customer if customer is ColumnA and date is ColumnB you would need to create ColumnC as customer and you would sort on that, so that date is...

Have an active field being Yes/No. Also have another table that contains the dates that the active field for a customer is turned on / off

OK. Simple way is by opening a form and clicking OK which will display the report. 1/ Create a form with 4 checkboxes. Call them chk1, chk2, chk3,chk4 2/ Create a button which has a label of "Launch Report" or "OK" 3/ In the OnClick event of the button past this code Docmd.OpenReport...

Not sure if this helps, but not knowing about pdf output here is an example using SnapShot Path = "C:\MyDocuments\" TitleName = me.txtBox.Value 'Where txtBox is the name of the box that has the report title DoCmd.OutputTo acReport, "QueryName", "SnapshotFormat(*.snp)", Path & TitleName &...

You can have code on the OnOpen event of the report which opens a form. On that form you have 4 check boxes, a cancel button and an OK button. When you click OK, code will then look to see which box is selected and will then set the visible property of the textboxes on the report to True or...

Why not get the report to take its data from a query rather than a table. Then in the query you could bring in the SigIDDescription field