Search results

Instead of BeforeInsert: sub Form_BeforeUndate() if me.newrecordset then me.dtCreated=now() elseif me.dirty then me.dtUpdated=now() end if end sub

Use the date control BeforeUpdate event and test and date with the appropriate date criteria.

There is no click events on Reports. Look at the Report, Header, Detail, and Footer event properties.

Use the report OnFormat event, not the detail OnFormat event, to hide or show the detail section.

It's not clear if you want one query or merely a second on. If two, take a look at "Union" queries. Additionally look at "SELECT TOP 2 etc."

Link table(s) from each database, one database at a time.

On some form event use an update query. docmd.RunSQL "UPDATE YOURTABLENAME SET TRUCKNO_OUT ='" & ME.TRUCKNO & "'" THIS ASSUMES THAT TRUCKNO IS A STRING, IF NUMERIC OMIT THE ' (TIC). Note that subform records are updated one row at a time.

You're incorrect. They the relationships can be displayed. Click the "Relationships" button on the "Database Tools" ribbon, then the "All Relationships" button on the "Relationships" ribbon.

That is the issue.

From your jpg, I can see what you want to sum. Try creating the totals you want in a subreport, rather than in a group.

Column names must be the same too.

The columns of the 2 queries unioned are different; they must be the same number (of columns) and same data type.

Post the form record source SQL and if you're using the Filter property, the Filter property SQL.

A column in your query is not correctly specified.

It's probably a non-updateable recordset. Take a look at this.

I easily found your solution here.

I easily found your solution here.

Import your a data, use an Access make table query using the imported table to create a new table, maybe adding your new column and populating it in that query.

But why do they all have to be open in "preview" mode at the same time? Just open them, is really necessary. If a report is on another report, it's a subreport. What your saying doesn't make sense to me. I missed the acViewPrevoiew in your first post.

Attached is a simple form filtering a continuous form using 2 different methods: first using the form "filter" properties, the second modifying the form recordsource. Take a look at the VBA code associated with the form, it's very simple and basic very.