Search results

The corruption is caused when the FE loses connection with the BE because of a network failure or power loss (living in SA we are unable to avoid this). The first symptom is usually that some of the queries in the front-end seem unable to recognise the field names - so that they read...

Hi, I have a database split into a back end and front end. I am having trouble with the database corrupting (long story - cannot change the situation). What I want to do is write some code to copy the table structures from the existing BE to a new clean database and also copy the objects in...

Thanks JHB. I found one error in qryReportBaseLevel2 and fixed it and ran the query with no problem. I still got the error. So I am trying for a sixth time to find a different way to do the whole thing and think I have found a way. Fingers crossed! Thanks for your help!

pbaldy - the database itself is indeed normalised - however what the client has asked for demands this sort of query - I have tried about 5 times to figure out another way to do it - without any luck. JHB: here are the 6 variables and the code to create a querydef from it. The resultant...

Hi JHB, I tried the above and I am still getting the error - and it still breaks the line in the middle of a field name. I'm getting a tad frustrated! But thanks for your and Paul's suggestion.

Hi Paul, Is the underscore the line continuation character? The code that produces the statement is really long - but basically it checks what fields should be included in the query based on what the user has selected on a form. I can post it if you think it would be helpful. That code is...

Hi, I have built in code a long sql statement as follows: SELECT Age, BirdType, Flock, House, [Lab#], Organ, Origin, SampleDate, SampleType, Site, Source, SourceGroup, [VT#], ProfileID, APIName1, APIAmts1, APILevels1, FullVals1, Match1, APIName2, APIAmts2, APILevels2, FullVals2, Match2...

Thanks, I will check that out. Can I just ask though, if the relationship allows the record to be written to the table, why would it not be retained? I was wondering about the relationships anyway though so will keep looking. Thanks!

I am sure the records are saved because I can see them in the table - they only disappear later. I have added the code used to add records to the tblSKAProcessesLink as well as tblSKARolesLink, and attached a picture of the relationships in case that helps. The only table that is losing...

Hi, I am building an Access database. I am using code in a form to add records to a table (tblSKAProcessesLink) that has two related keys (SKAID and ProcessID) with a many to one relationship with tblSKAs and tblProcesses respectively where the related keys are primary keys in the latter two...