Search results

Sean Sean ... That too works well! However I have consulted the Manufacturer's data protocol document once more and my definition of what constitutes a Header record needs tweeking slightly, as follows:- If character 56 = "T" this denotes a Training flight header record. Where this arises...

Thanks Sean ... I'll give this a roadtest as soon as possible and give feedback!

Sean Just now analysing the output in tblTEMP ... I actually need to preserve any and all leading spaces e.g. T)GB10 N099519HC927209400J13103612050000000000000000000000000000000000000000 ... needs to include the leading spaces (two in the particular instance) T) GB10...

Post #15 shows Sean's code that I'm using at present, and which seems to work ... I tried to copy it into this posting without success.

Unfortunately I cannot control the number of races written into the racedata.txt file ... this is the hardware manufacturer's choice/control. It's also frustrating that the racedata.txt file has no common/linking text in both the header and sub-records ... again this is the hardware...

Food for thought ... Just to clarify from my perspective that the ORDER that the records appear in the freshly-populated temp table is NOT in any way important ... what's important is that the correct association/prefix is made between each header record and all associated sub-records. The...

Multiple files not envisaged ...

ok Sean ... that works great too ... ! One (last) question ... I need the query to delete any existing contents of tblTEMP (or perhaps even delete the entire table?) else it seems if the command button I've created is clicked twice or more the existing records get edited/prefixed with...

OK thanks again Sean! By the way, I've often seen the Me! expression used ... does this mean the current form?

Sean DELIGHTED!! Running your code gets me the following:- T)RPRASO0217000008273120511140759************************T T)GB10 N099529HC92A20B100O12233012050000000000000000000000000000000000000000 T)GB10 N099507HC924E08400M13091312050000000000000000000000000000000000000000 T)GB10...

Apologies Dave I edited my last posting #17 giving a bit more info ... happy to answer any additional questions you have

Sean I'll give your code a whirl and report back! Dave Welcome to the world of PIGEON racing! The three header rows represent a Training flight plus two Race flights The detail records represent information about each pigeon timed in each flight The first header record is a Training...

Unfortunately my workaround is not workable ... it puts too much onus on the user to manually delete unwanted records ... so I'm back looking for a solution that identifies 'header' records (the first 19 characters will be exactly the same e.g. in our example "RPRASO0217000008273") and then...

I have a right 'funny' going on ... I have a database with many standard command buttons running reports e.g. Private Sub Command244_Click() On Error GoTo Err_Command244_Click Dim stDocName As String stDocName = "Portrait Pedigree4" DoCmd.OpenReport stDocName, acPreview...

Yes, don't see why not ... On your menu form create a formatted (date) text box, that is blank that can be entered up if required. Create the same on each of your pivot forms Get your pivot queries set date criteria of [menu form]![date] or [pivotform]![date] So long as one of the date...

You didn't answer, so I'll ask again, what has happened in terms of operating systems, software installs, data directory creations/movements, external data links, etc since the database was last working? Not sure that there's a version 11 though!

Sounds like you may want to build a SUM query from your main data table, linked to your Budget table e.g. Summarize income and expenses by Period, compared to single budget figures held in the Budgets table ps if you save and upload the database in Access 2003 format (.mdb) a few others...

I think you need to take a step back at first ... The database WAS working ... now it isn't ... so ... what has happened in terms of operating systems, software installs, data directory creations/movements, external data links, etc since the database was last working? A few other questions...

No worries ... you'll have many greater challenges ahead I reckon but if you love Access it will love you back!

Sounds like you need a Sum (Totals) Query where you use the "First" total control to limit the query output to one record per item. I wonder whether you are storing multiple photos in the same data record in fields such as Photo1, Photo2, etc ... ? If you are, then there's a better...