Search results

I can create queries without any bother in the back end... not sure if this is advisable, or indeed if it gives any clue as to the issue, other than it is either in the front end or in the linkage between front and back? I can then export the query to the front end and it works normally.

So i've gone in and changed both of these, and despite the fact some of the queries will be have to be rewritten from scratch as the original error was preventing me for getting into them anyway, I still cant create new queries from the original tables, which suggests this hasn't fixed the...

When I went into the MSysRelationships table, there wasn't any rows with blank columns unfortunately.

I think I've found something actually. MSysCompactError table has logged the issue, however it is saying it is actually: '|' is not a valid name ... and it is logged in the table MSysRelationships (error code -1002) Trying to open relationships, the original error pops up. In full, it says...

With empty tables, I've now deleted all queries, forms, reports and macros. Tried and ultimately failed to create a new query with the same error repeating. Ooft.:banghead: Edit: will try re-entering queries Edit: putting in queries one at a time still draws the same error. I can't post the...

Hey, sorry for the ambiguity, but you are correct, that is essentially the state of things. I tried emptying all the tables and then checking current queries and new queries, and the error has remained.

I am aware that this error has been discussed numerous times and is, or at least was not uncommon. Originally, there was an apostrophe in the address link. This has been removed, both backend and front end have been compacted and the links re-established. This has not affected the frequency and...

Worked brilliantly, thanks a million

Hello. Creating a patient database. Patient ID is 10 numbers, with the 9th number being indicative of gender, even numbers are female. I've an unbound text box ("gender") using =Mid([ID],9,1) to pull out the relevant number, then using the following code to autopopulate another unbound text box...

Perhaps as it was only a query and not a table? From there I essentially copy pasted the DoBs (as date, not text) into the table without any issues. Subsequent functions to calculate age have also worked out. Thanks again for your help.

Dob: DateValue([Day] & "/" & [Month] & "/" & [Year]) I built a second query on top of the first to use the fields day, month, and (year + 1900) and it has worked finally. Indeed, even ID numbers starting as 010101 (1st Jan 2001) are defaulting to 2001, and not 1901, so it has worked perfectly...

Ah yes, excuse. In my ID number, 1412893553, I'm extracting 14 (day), 12 (Month) and 89 (Year 1989) The issue with 89 is that it could be 1889, etc, so access is having trouble, or rather, I'm having trouble making it explicit to Access. Incidentally, how would it handle someone born in 2001...

Mid function works brilliantly, so I now have 14, 12, 89 respectively in 3 fields in a query, but the datevalue function is a little trickier to get working... The examples on the link you provided only show named months, years (i.e december, 2002, august, 1999) In which case would i need to...

I have a 10 digit ID number (i.e 1412893553) which corresponds to a date of birth (14th Dec 1989) and 4 random numbers. Is there code I can use to work out of the date of birth from this ID number? Cheers

so there is no way to bring up other fields from a multi-record table when running a max of date query from that table without pulling all records?

If I add in just surname, forename, etc, yes it works fine. However I want to be able to see if that one appointment was attended or not attended. If I add that in, it pulls all records. EDIT: sorry I should have originally mentioned that being able to see whether that appointment was attended...

so qsMaxActive query works fine, but when I go to join it with tblPatients, it is again pulling all appointment records (around 11,000). Is it the type of join? Would an outer join be better?

thanks for the simple explanation. I'll give it a go and let you know how I get on

Hello, I realise this is a fairly common issue and have found some help on google, however the reasing/code behind the answer is fairly confusing to me unfortunately. I’m trying to create a query to pull a list of all patients’ most recent appointments. I’ve a base query of ‘active patients’...

I deleted and rebuilt the report, linked the command button to open report, that was linked to the query, and it worked. No idea what I've done differently, but I'll be sure to make a note of all the settings I've for this. Thanks for your help guys, I'll be back for help when it inevitably...