Search results

The reason "1" doesn't get returned is your use of the "Max" control in the Query ... change this to "Group" and "1" then returns multiple values You could then create another query with the original query as it's source table, and sum the values in the original query? Obviously you know...

Forgot you'll also need a Suppliers table (code, name, address, etc) You'll end up writing a suite of Queries linking all these tables together, for example in creating a purchase order Form where you first select a Material then create a drop-down list linked to your Prices table to enable...

You will reach a wider audience if you can save a copy of the database into A2003 format (.mdb) What you want is achievable, though I think you may wish to consider something less complicated and rigid than a matrix (assuming I've understood fully what that means). I would consider the...

Microsoft Access Runtime 2007 (free download) gives a user all the functionality and features of Access 2007 but without 1) Access to the objects (database window is automatically hidden) 2) Right-click button is disabled ... again restricting users' access to objects 3) You don't have to buy...

Here's a few things I'd do (far from a definitive listing) Hide the database window Perhaps even consider issuing the frontend file under a FREE Runtime 2007 licence (this will protect all the objects so long as the user doesn't have a full licence of Access loaded on their PC) Lock all Form...

Found this on Microsoft's website ... suggesting 255 users http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx

Thanks to both of you for your interest and assistance ... much appreciated. For now I've developed a classic 'PaulO' workaround whereby I parse and load all the data into a holding table, linking to the first header row, and then display all the parsed records in a Form and allow the user to...

I have a full data dictionary/map in the Protocol, which I'm following as best I can. However the text file itself is a bit of a mash with no clearly defined or consistent structure (especially when looking at the detail records which on occasion hold 'like' data in different character...

Apologies, the original .txt file is attached to my first posting. The second attachment shows how, perhaps, I'd like to amend that file to look like. I'm afraid that we can't assume that "RP*" defines a header row, nor that " GB" prefixes each detail record, as all these codes may vary...

That looks kinda logical, but you're talking to a right VB numpty! Looking again at my text file, and referring to the hardware manufacturer's Protocol document to which I have to refer to, it seems that Characters 56 and 57 define the Header set (not just character 56). However these...

Yes ... ultimately I end up with multiple fields of data extracted from the long text strings ... this part of the process is complete and works and even works with the three datasets now being worked with ... but ... they are not referenced correctly to their Headers which is the current problem.

OK good point ... modified (desired) .txt file attached

I've been working steadily on a project involving the connection of an Access database to some external RFID hardware, invoking and then reading a .txt file and then parking parsed data in my database. All has gone well thus far albeit I was working under the misunderstanding that there would...

Sounds like the database itself is not at fault So:- 1) check/repair the Access 2k installation 2) make sure you have all the latest windows updates installed on your computer 3) check for any missing references (Tools>Macro>Visual Basic Editor, then Tools>References)

You perhaps need a 'Calendar' table with two fields (Date; Fiscal year) and 365 records for each year (except leap years of course). e.g. 01/04/2011;2011 02/04/2011;2011 31/03/2012;2011 01/04/2012;2012 etc Link this table into your existing source query for the report, and drag the Fiscal...

I think that, somewhere in the source queries or forms used to feed the report, Access believes there is a record being edited. I think all you can do is examine the data trail beneath the report.

You need someting like this as your query field criteria:- >[Enter Start Date]-1 ... where the date you type is what is used between the [] Then, the query will return data where the Date is greater than the date you typed in ... remember to type the date in the same/correct format as the...

I think this has something to do with Track Name Autocorrect Info and/or Perform Name Autocorrect features found under Tools>Options>General as this is an error that drove me nuts a few years back and so I unchecked both these features. Whilst I think that will solve your immediate problem...

Not sure that adding a calculation field into a table is the correct approach ... others may of course disagree. Personally I would use an Update query, using the same expression/logic, it's certainly worth trying.

If you are using a normal Select query to source the Report, you just need to set a Criteria on the Serial No field in the Query like =[FormName]![SerialNumberFieldName] This should limit the Query's output to the required record ...