Search results

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

almost almost there, i have used your suquestion and it works partially. It writes down the ProjectCode inside the box, however it doesn't write down the selected combobox value (ProjectName) into Table2

tnx First of all i want to thank everybody for their fast reply's. The reason that i'm using the same names is that on table2 the name can appear many times while on table 1 the name only can appear just once. The solution to my problem isn't solved yet, sorry about that but it returns an...

Not completely I have a combo box on my form in wich you can select the ProjectName derived from table 1, this value will be stored in ProjectName of table 2, this means that both tables has the same ProjectNames. In table 1 the ProjectCode is the primaire key, however i want to show a textbox...

I have two tables table1: ProjectCode ProjectName table2: ProjectName i have created a form for table 2 and i want to show depending on the selected ProjectName a tekst wich shows the ProjectCode from table 1, how to do this. Tnx in advance