Recent content by krillin

Damn, i missed that. It works now, many thanks for your help

Bound Column = 1 using this string SELECT Contacts.[Display name], Contacts.Department FROM Contacts INNER JOIN Storage ON Contacts.ID=Storage.ID WHERE (((Contacts.Department)="DIV2/RT/223")) ORDER BY Contacts.[Display name]; even if i use a straight query, it skips the same records (almost...

Nope, nothing. I checked and double checked. Isn't this weird or what!

I have a combobox on a form wich uses a Query and returns only names wich matches to a string "DIV/RT/223", it returns almost all names but skips a few. I have looked in the database but i can't find any reason why i should skip these records. Anybody??

? anyone

Just a simple question (i hope), i have a field with the path and filename of a word document. I know how to open the file, but here comes the catch. Is there a way to make this file read only on opening tnx

anyone

I have a form problem, on this form a filter has been applied and several Query's. When these query's are used the data on my form changes while my CurrentRecord stays 1. But when i press any command button (filter, close form) the data on my form writes it back to record 1. I can use the DCount...

BTW i have created an FTP account for all access users who has problems uploading there files with the forums limit of 100KB, so if you have some larger files then upload them to ftp.clanbba.com username access password access greetz krillin

Here we go again I have tried several hours to find and read the answers to my problem but i didn't find it. There are some problems left. But i don't really understand wat to do:( . So here we go People who have read this topic know how my table's look like question1: The combo box i have...

tnx colin :-)

Thx for your comment ( i think). I know what you mean but i have several reasons to duplicate the ProjectName field in table2. And this field is a unique field In table 1. However i do understand your suggestion and will try to create a better way for this. Reading through manuals is a great...

tnx colin, it works. I know enough to proceed with my project, i will run into some other problems but i know were to place my questions greetz a newbie

Colin Tnx colin, again, i hope i'm not boring you. But wat if i have another row in my Table1 called ProjectLeader and i want to show it on the form aswell, with only the selection of the combo box

TNX thanks, it works. great support on this site, just one question left i understand what i did wrong but i don't understand the function of the bound parameter. anyway thanks alot