Search results

Complicated? Your are right, RainLover, but a few weeks ago I've seen even more complicated ones (in this forum)! Nevertheless we have to find a solution here. U-Doo, you will find the one I developed attached. - The development included several changes / modifications. I... - renamed the...

I have difficulties to understand what you are looking for. First you say you want a list of tasks created by the user and also a list of tasks assigned to him, that is two lists, right? But later on you say you don't know how to populate a list of tasks by the user and the assignees together...

Pat, your questions are actually entitled. But the answers are quite simple. First of all, I'm hard-coding nothing. Neither I load the value list from a table, I load it from a collection (of class objects). Why is that?? Imagine the following: you want to fill a combobox depending on the user...

You are welcome.

No, go to the file tab, click Options, go to Current Database. In the first section you should see under Window Options some buttons. Click the option Overlapping Windows. I hope you'll find it because I'm not working with the english Access version. Afterwards you are asked to restart your...

No problem. I got the combo to just show the role name by setting the columnwidths property to 0, a not really logic Access trick. Normally you do it as explained by Pat, you set the ID column to 0 only (example for two columns: 0in;1,532in). If you have a combobox with 3, 4 or more columns you...

I always use value lists (up to appr. 500 items) because my user interfaces aren't (directly) bound to any data backend! The combos are filled by the AddItem method. I say this to you, Pat, because I consider you as an expert. For beginners (and small size applications) a table bound combobox is...

Have a look...

Welcome in the forum, 105ben! To answer your question: they are copied and stored twice. Normally you only store the ID (as the bound column) in the staff members table. But... sorry for saying it, you should not use any lookup wizard columns. In order to get a proper table structure which - as...

You were right, there was another way. - So I hope you feel better now. ;)

And what about this: SELECT DISTINCT digid.KlNr, First(digid_1.Voorl) AS Voorl, First(digid_1.Tussenvoegsel) AS Tussenvoegsel, First(digid_1.Naam) AS Naam, First(digid_1.Adres) AS Adres, First(digid_1.Huisnr) AS Huisnr, First(digid_1.Postcode) AS Postcode, First(digid_1.Woonplaats) AS...

Well explained Pendragon536, but in order to give you the right feedback I would like to have a thorough look at your application. Would it be possible for you to upload it with only a few sample records?

Alright then... good luck with your project!

Ah, understood. If you want to have more than one record in Klanten related to a directory then I think using a separate table (e.g. tblDirectories) would be the best. The number (or name) of the directory is the foreign key in Klanten. In the form you use to add new clients you should put a...

What exactly is your field "Klnr"?

Anissa, don't take this wrong but with your post (# 5) you got me confused. I'm not quite sure if I understand you well. Originally I thought your intention is to append certain records from ORDER_FINAL to Master Invoice. The only criteria for this are that these records should not exist in...

Please upload your database with a few (non critical) sample records. The reason I'm asking you this is that I know nothing about an "update query".

Create a new table (e.g. Klnrs) with the field Klnr as the primary key. Create a relationship to table Klanten via that field. Then change your query to: SELECT Klnrs.Klnr, First(Klanten.Voorl) AS FirstValueOfVoorl, First(Klanten.Tussenvoegsel) AS FirstValueOfTussenvoegsel, First(Klanten.Naam)...

I cannot find any fault in your SQL statement. Did you check your table for duplicates?

Further to Isskint's and spikepl's comments: INSERT INTO [Master Invoice] ( [Customer Name], [Address 1], [Address 2], CUSTOMER_City, CUSTOMER_State, CUSTOMER_Zip, Weekending, Quantity, [ITEM ID], Description, [UNIT PRICE], Amount, WHSE_DESC, [Customer ID], [Displayed Terms], [Due Date]...