Search results

you can have a look at Clashing Events/Appointments at Allen Browne's site.

you could declare a form module variable like Dim WithEvents mobjRpt As Access.Report By selecting mobjRpt in the upper left dropdown list in the code window you'll have access to all public events of the report. After opening the report you have to set the object variable to the report. I. e. '...

If you use a bound form for the table [tbl: Revision], you can simply change it's Filter property. I.e.Me.Filter = "SKU = " & Forms("Products")!HiddenSKUNumber Me.FilterOn = True In the navigationbar you can see the number of affected records or you can simply set the control source of an...

try a query likeSELECT T1.PCODE , T1.SMONTH , T1.VOL , (SELECT TOP 1 APRICE FROM Table2 WHERE SMONTH<=T1.SMONTH ORDER BY SMONTH DESC) AS AVGPRICE FROM Table1 AS T1

you could use the following querySELECT CDate(Format([booked],"Short Date"))+ (CDate(Format([booked],"Short Time"))*1440\15)*15/1440 AS TimePeriod , Sum(costs) AS SumOfCosts FROM YourTable GROUP BY CDate(Format([booked],"Short Date"))+ (CDate(Format([booked],"Short Time"))*1440\15)*15/1440

try this querySELECT Sum(acd_calls) AS SumOfacd_calls FROM tblstj WHERE fdate In (#5/4/2003#,#5/11/2003#,#5/18/2003#,#5/25/2003#,#6/1/2003#,#6/8/2003#)

you could use the CurrentUser Method. For more see your help file.

Have a look at Various Date manipulation functions

There is also a good step by step explanation with additional screenshots and a bunch of drivers (uncertified) and batch files (i.e. email pdf-files) on how to install Ghostscript in combination with Redmon. But the explanation is in German. Rumborak.de - Mit Ghostscript einen kostenlosen...

i assume that your working table is joined to the two tables via foreign keys. So you already have comboboxes for your linked Department and Activities tables. An easy way adding new activities could be reached by using the Activities table in a main form and putting the linked table in a...

Does this mean, that you could use the form only once in an opened Access session? How is not working showing up? Did you get an error message? Do you have any code beside the buttons' code? Have you commented out error handling in lines with On Error Resume Next?

maybe you could create a PT query on the fly with DAO's CreateQueryDef function, set the connection string, make it a PT query, assign the sql text, open a recordset on it, read out the date/time information, close the recordset, destroy the query. I'm not sure, if the PT query also works with...

Have you tried doing your calculation in an unbound text control? If your calculation depends on more than one record, place the text control in the footer section. If this doesn't help, you can show us at least your query with the calculations and maybe some sample data.

I would restrict the selection for the vehicle by setting up a main form having the criteria from the postet query. You could accomplish this by either using the form's Filter property or assigning the query to the form's RecordSource property. In a subform joined via the VihicleID you couldn't...

if your subform is a bound control you need also information about the joined field. So I assume an unbound subform control in the following codeIf MsgBox("Do you wan't to create a new record for " & NewData & "?", vbYesNo) = vbYes Then Response = acDataErrContinue DoCmd.OpenForm...

you should get the available vehicles with a query likeSELECT VehicleID , RegistrationNumber , Make , Model FROM tbl_Vehicles WHERE VehicleID Not In ( SELECT VehicleID FROM tbl_Usage WHERE InDate Is Null) BTW: I would use the DriverID as a foreign key in tbl_Usage instead of the...

might never be true. Revise your logic. Setting the Cancel Argument of the Form's Close event to True, will prevent the form from closing.

you could accomplish your goal with a crosstab query on which your report should be arranged. It might be a little tricky to adjust the column headings in the report. In Roger Access Library you'll find an example (CrossTabReport).

Sue, if the db's relationships are set before appending any data you couldn't do it wrong. Add the field PUBID to tblReport in table design mode. Then you have to add a column for the field PUBID in qselReport. In qappReport add the PUBID into a new column and adjust the append to field...

Well, I decided to rename tblLocation to tblReportLocation and forgot to change that in the append query. The text of the query should look likeINSERT INTO tblReport ( REPORTTITLE , DEPARTMENTID , DATEPUBLISHED , PUBLISHERID , LOCATIONID ) SELECT R.Title , CLng(Nz([DEPARTMENTID])) ...