Search results

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...

Cheers Rich, I was just going to leave the form open as it would just sit behind the report then close on exit from the report. Didn't even think to make it invisible though! A much better idea. Thanks

Actually I've just taken out the text box and its still doing it. :mad: I mustn't have checked it since I put in the command to close the date search form. Still unsure as to why it would need the dates again though when it has already formatted the report.

I've added a textbox with the following code to a report: ="Showing Courses from " & Format([Forms]![AttendanceDate]![StartDate],"dd mmm yyyy") & " until " & Format([Forms]![AttendanceDate]![EndDate],"dd mmm yyyy") Now I can preview the report fine and the textbox shows the correct dates...

Very interesting topic to me as well. I'd love to hear other peoples views on this subject as I'm in a similar situation. I took on a project to develop a database despite having very little prior knowledge - I wanted to learn and fancied the challenge. Anyway I've been completley on my own...

BINGO! Slight modification on what you gave their Rich but now appears to be working. =IIf(IsNumeric([DelegateHistorySubform]!Text28),[DelegateHistorySubform]!Text28,0) Cheers for that Rich, thanks Mile-O and neileg for taking the time to look at it.