Search results

I have used this formula successfully in A2003 databases to establish the Network ID of the User of a database, and use this identity to determine what menus and/or features features are made available to that User. A2007 seems to dislike this formula! :( For now, I have found a 'fix' of...

Thanks Pat ... I might try substituting the Query with a Table and see if that quietens things down any. I'm not using any "D..." formulas at present ... in fact no formulas at all right now.

Hi I have a database with its main form consisting of eight subforms, two of which have a Master/Child links to one or more of the other six. I'm getting a noticeable 'flicker' effect on these two subforms, one of which feeds off a Query, the other straight from a Table. I just wonder if...

You can achieve this, but as RainLover hints, it would be best to have this linked to and feeding a Form that you can load on startup or from a Menu.

If you are looking for just the LATEST record for each failure (?) then you need to add the SUM functionality to the Query and on the FailureDate field select the Max total property

In Access 2003 ... Tools>Options>Advanced Tab>Default Open Mode=Shared

From what you describe I think you need to build a QUERY that concatenates the First and Last Names with the following Expression trim([FirstName])&" "&trim([LastName]) then use this Query in the lookup field in your table ps Trim() just gets rid of any leading, duplicated, or trailing...

Part of the Import Text Wizard allows you to tick a small box that declares the First Row Contains Field Names ... that's what you need to do.

OK ... I think I'd be looking for remote network access/login capability for my users as Synchronisation will always prove troublesome.

Can your Inspectors connect to your Network and load the Database from remote locations? If so that's your answer.

You'll need a combination of Tables and Queries, plus of course some Forms and Reports You'll need a MASTER Videos Table (Serial; Title; Category/Genre; StockedSinceDate; etc) that logs Master Details of each and every video. I know you have multiple copies of each Video but (if you haven't...

If you're able to ZIP and Upload the database in A2003 format, and advise which Form/subform contains the errant formulas, myself (not an expert) or an expert on here might be able to assist.

Just taking a wild swing at this, but have you perhaps named the [Field] with a 'reserved' name? What's the Name you've assigned the field? Whatever it is change it temporarily to [Text999], change your formula accordingly, and see if the problem persists.

Your subform sounds like it is displaying data gained from a QUERY? If this is the case, link a new REPORT to this same query and attach it to a COMMAND BUTTON on the form so that the report always outputs the data filtered by the User.

Rather than GRIDS, could you instead draw/introduce LINES between the fields. These shouldn't get distorted. Alternatively, don't allow fields to 'grow'. Rather, set comfortable widths for all fields.

Yes, you could use Check Boxes (Yes/No) built into each record in the data table. So no VBA required, the QUERY feeding your report will be instructed only to load 'checked' (yes) records.

First thing to know is that SAVE buttons are not required for Data Tables, unlike in WORD or EXCEL. Records are automatically 'saved' the moment you move onto any other record. So, in the event of a crash the most data you can lose is just one record. NB: Saving discipline does become more...

Build a DELETE Query off the Data TABLE, and BUILD the criteria in the unique field you wish to use as the record(s) identifier as [Form]![Field] where [Form]![Field] is the open form and field you are viewing Attach this Query to a command BUTTON on the same form. I use such queries all the...

Couldn't you continue using the Spreadsheet function and LINK that spreadsheet to the Database?

Link Tables A and B in an UPDATE query using [SL Number] in each table as the link then update [TableA]![Status] with [TableB]![Status]