Search results

A few alternative approaches to age calculation: Calculate age

Hi. I'm afraid I don't have much time right now. But I'll set up something this week-end.

See if this thread may help. Show/Hide custom Menus

I believe a better approach would be to update your underlying records by running an update query, then refresh your form.

I am not sure I understand correctly your situation. What do you mean? -Do they display basically the same thing and are based on the same recordsource? You would be better served offering a filtering feature for a unique form then. Applying to a report the filter applied to a form is easy...

The following will work with full Access versions installed (not with run-time): RunCommand Conquer by Terry Wickenden

it is possible to set up the paper type programatically for each report. Look at the entries PrtDevMode (property) and PaperSize Member (form paper size codes) in Access Help for more details and code samples. Re-post if you need further help.

If you know how to do that for one listbox, there are not many differences with various ones. For one listbox, before opening your report, you build a string that is the equivalent of a Where clause in SQL: strFilter. For various listboxes, you'll just have to further complete this string by...

Since you did not provide details about the strucutre of your db I am assuming that you have 3 tables at least: Tbl_Customers - CustomerID (autonumber PK) - CustomerLocationID (foreign long integer key from Tbl_Locations ) - OtherDetailFields... Tbl_States - StateID (autonumber PK) - StateName...

I am not sure i understand where your problem lies. Provided that you've set up your db design structure properly, you should be able to retrieve a customer's city easily through a query or in the very table wher your stored your customers' details. It seem that you just have to base your report...

At first 'sight' I'd say a possible approach would be to have 3 queries: your first one that gives you the 0s. Your second one that treats the 0s cases. A third one, a union query, with a select clause to skip unwanted records (with 0s), would merge results from both queries. There may be a...

It may be possible under certain limits. Give us a better idea about what you want to do: what checkbox(es) do you want to toggle (current record or other(s)) under which circumstances, etc.

Zip and email me your DB if it is not too big. Make sure to indicate the report in question

I believe that what you are after are cascading combos based on two tables (Tbl_States and Tbl_Locations) with a one (Tbl_States) to many (Tbl_Locations) realtionship. If you do a search on 'cascading combo' you will find many threads indicating how to set this up.

Sorry, I forgot to provide the declarations to use along with the PrtMip property: Type str_PRTMIP strRGB As String * 28 End Type Type type_PRTMIP xLeftMargin As Long yTopMargin As Long xRightMargin As Long yBotMargin As Long fDataOnly As Long xWidth As Long...

If I understood well your pb, from the OnOpen event of your reports, refer to the controls on your opened filter form (pop-up I suppose) and use the .Left and .Top methods like in the following example: Forms!YourFormName!YourControlName.Left = value HTH

The first two arguments must be string, so either: - string variables - or names surrounded by double quotes as in your case The third argument is the equivalent of a WHERE statement in a query. It must compare fields of your domain (the table "tblInput") or expressions based on those fields...

A few ideas that may help: If not already done, I think you should split your DB into BE/FE to divide the pb into two parts: - The global trend for the BE containing data should globally be to continue to grow (that's life ;) ). Not much you can do for that but set up regular compacting (on...

MS paper "Database Replication in Microsoft Jet 4.0" underlines the interest of anonymous replicas in case of sync over internet, but also underlines a few limitations of such replica. I already heard other restrictive advicea on the use of anonymous replica, namely the in following article...

This is the kind of situation where I would store the value in a table holding 'fundamental' variables. Easy to update values. No code maintenance. TblSystem - SystValueID (AutonumberPK) - SystValueName (Text) - SystValueDescription (text) Store/update values through a 'system' form /...