Search results

That site says it's an alternative to the full run-time environment. The full run-time should have more functionality and is located here: http://www.microsoft.com/download/en/details.aspx?id=4438 However I haven't used it. I would advise making a test copy of the database and testing the...

Surely it's still load once for each subform though, meaining 3 loads? Even if the filter/criteria means no records are returned, all 3 recordsources would be checked upon load, right? Or does the 0 filter have a special meaning that stops the recordsource being checked?

I've not used excel as a front end, however if I were doing it in Access VBA I would use a recordset which has the date criteria and loop through each record. I can go into detail on how to do that in Access VBA, but you will need to find someone with more "Access automation via Excel"...

Really? We are comparing: 1. Open 3 subforms @ form load, each bound to a different query 2. Open 1 subform control, bound to either the first subform (& the associates query) or nothing @ form load I wouldn't expect 1 to be more efficient unless the end user changes which query they...

A quick google search displayed no exact matches, so I'm not sure what "Access viewer" is. Is this basically a run-time environment to replace an install of MS Access on the end user's PCs?

An update query with this as the "update to" (which may not actually be what the row's called, but it's something like that) should do it. If you want to check beforehand then create a select query with the appropriate criteria (copied from OP: "recdate>=startdate and <=Enddate") and add the...

If it's returning exactly the same fields then the controls should have no problems linking to the appropriate fields. You can test if the form will work with each query by manually changing the recordsource in design mode and opening the form for each query. If they all work correctly then...

Certainly better for the end user than record locking.

Try this: DateDiff("d",[RecDate],[ProcDate])

I use this all the time. I find the easiest way to do it is to display the LAN ID (and/or the access level from a table like the one mentioned in the post above) in a control on the switchboard (.visible = false so it's not seen by the user) and check that control each time I need to check...

Then I stand corrected. Given that you can't get the max number, add 1 to it, create a record, use the max+1 as the value and save the record instantly I guess you have 2 choices. 1. Deal with the slight possibility that 2 people will click the new record button at the same time. 2. Have...

Assuming the paramaters are set as Date/Time the potential problems are limited, but I admit that forms offer additional checks like ensuring the end date is greater than the start date, etc. Custom coding in VBA offers a much greater degree of control than using the Access features. re...

If you know of a part of Access which is glitch-proof, let me know. :)

You shouldn't need to. If the fields are the same (and therefore the controls are bound to the correct field names) then all you have to do is change the forms recordsource property. I gave an example above but click into the property and press F1 for help on it, I believe it includes...

If I have very customisable queries (i.e. at least 5 fields which I allow the user to filter on) then I'll create a search form for the user. However if it's a simpler database where the only criteria ever used on that report / query is the dates I'd likely not bother with a form. Here's...

The DateAdd is adding the appropriate number of hours to Now() for whatever timezone is involved. If Date() were used then it would assume the time is 00:00:00 which would mean it doesn't always return the correct date (e.g. 19th Sep 2011 00:00:00 - 8 hours = 18th Sep 2011 whereas 19th Sep...

Barring things like corruption and deleted records (which would effect manually generated numbers just as much as autonumbers) autonumbers should do what you want. Plus it's generated at the precise moment of record creation rather than fetching the number, creating a record and then saving it...

You can add an extra stage if you want the current table to be the one that ends up with the good data. First create a temp table, then copy all records into there (dupes and uniques). You can now run a delete query on the existing table to empty it. After that you basically follow the...

Are the fields returned exactly the same? You can change the record source of the form simply enough vian the command button's on click VBA event (e.g. me.record source = "qry2"), but if the controls on the form don't match the fields in the 2nd query you will have issues displaying the data.

I'm not sure what you mean by access flips in seed/sequence/sign. And I'm assuming that by "secure 100%" you mean have a 100% certainty of being a unique number?