Search results

If you can't open the original or a copy, you're toast. I'd create anew blank database and try to import all the "bad" database objects. Maybe you'll get some code. If unsuccessful, try importing from the copy. I've experience total failure before. It makes the case of backing up you program...

There's not such a thing as an Access "system form," i.e. a form whose name begins with a "S." The form is possibly hidden or it does not exist, i.e. wasn't saved when created. To unhide a form use the method described here.

The reports must be maximized with the last one on top. Why do you need them all opened at the same time? On each report's Report_Open even, move each report to a screen position and size you think appropriate, e.g. me.movesize per the method shown here.

I didn't say that. Each order has multiple shipments.

Each order has multiple shipments.

Build a junction table to handle the orders to multiple shipments, i.e. Orders.PKO (one) >> (many) JcnOS.FKS and (many) JcnOS,FKS>> (one) Shipments.PKS The JcnOS table handles to one to many relationship of Orders to Shipments.

I would create a shipments table related to the order table, both having primary keys and with the shipments table having a (foreign key) field which specifies the order (primary key). All table should always have a primary key, usually an autonumber datatype.

On the form OnLoad or OnCurrent event, as appropriate: If me.project & "" = "" then me.project = me.purchase or [the purchase value, where ever or what ever it is].

Add a subform with the desired calculated fields, calculating the datasource of each on some form event. One cannot use the subform_onload event because the subform with be loaded before the data in the main form. Try on the subform_oncurrent event, which may or may not work.

What does the form recordsource SQL and the data in a record look like? A solution my or may not be trivial.

The report are opened and stacked (overlaid) with the next report. Execute the docmd.openreports in the reverse order, such that X is the last opened, etc. The last opened will be on top of the stack,

Build a related subform for tithing history with the "datasource" property value filtered by the desired period.

Make a copy of your database, then do as the message suggests on the original, not the copy.

What do you mean by "php?"? I gave you Access VBA code.

No, its a enterprise printed form.

Thx for your prompt response.

My client has a complex pdf file which it desires to use as a bound report source object to display data from the report's record source.:banghead: More succinctly, bind a pdf report to a table so that report is populated with data at run time. :banghead: Of course, I can manually build the...

The Monday of next week after "AnyDate" is AnyDate + 8 - Weekday(Me.dt, vbMonday) Mod 8 Add 6 and you get the Sunday of that week.

If Date() is a Monday, is the next week the next Mon-Sun?

The next week interval depends on Date() and what you consider the next" week. Is it M-S, S-F, or whatever. It can be computed, but not with the info you provided. You can compute it in a function..