Recent content by Numpty

Like it Centurion, Like it.... Cheers CJ that worked. Took a bit of filldling about mind 'cos the MSDOS names were not all ~1 due to similar folder names but works now!! Once again bailed out by Access World Forums ;)

I have an Access database which is held in a folder on our network - to access the database a user needs to go in via a shortcut - this is because the database is secure and the shortcut points them to the correct wrkgrp. Anyway the folder that I have had to place it in makes the pathname too...

That one works as well rich but will still display the extra column in the query result. anyway I can hide that so I'm happy enough for now! Once again... Thanks

Cheers for that one as well CJ. I wouldn't know how to get the sex into it though:rolleyes: I've basically done what you said though and have included ALL from EthnicOrigin so it does now show three columns. I've hidden that column when the query runs so the result looks good now. Although I...

Cheers Fizzio, I see how that would work - although I'm doing about 12 similar queries so would have to repeat that 12 times!!

:confused: Where did that get to :D

That gave the same result as the others Rich. But.... I have now managed to get it to display the Nulls by changing the Join properties in the query to the 3rd option and include ALL records from EthnicOrigin but it now also displays and extra Column <> which is populated entirely by zeros...

Worth a try! Unfortunatly produces the same result though..... Any other ways to substitute a zero for a null????

Cheers Dcx, I don't know what you mean about forcing the column headings to display the zeros though. I've tried to change my expression to use the Nz function but it still won't display the null values. Nz((Count([DelegateID])),0) Any idea's? :(

I have created a crosstab query which displays the number "Delegates" within our database who fall into certain ethnic categories, also listed by sex. The query I have created so far will display the count of delegates within a category as long as it has an entry. What I would like it to do is...

Cheers for the replies. I've put it into the On Delete event to check for the ID of the particular record. Works fine. Thanks

IS there anyway to protect a single record so that it cannot be deleted? The main way a user would delete a record would be from a button on the form - I've coded the button so it's disabled when that particular record comes up but the user could select the delete record option from the Edit...

I'm back!! OK, the datbase they want me to import from has it's data set up in a completely different way. Table: Registration RegistrationID - Autonumber ProviderName ProvAddressID - Linked to Table: Address TelStd TelNum FaxStd FaxNum EmailAddress Table: Address AddressID - AutoNumber...

OK, cheers for that. I'm off to have a looksee at the db they want to get data from, I'll look into what you have said when I get back and I'll have a go! I'm sure I'll be back asking for help though!

From what I have read on this subject so far it would appear that to import data from another db the table structure, field names, data types etc have to be exactly the same. Is there no way around this? Perhaps using a query that can select information from a tables field in one db then...