Recent content by Kysteratwork

Stevecff, That's indeed the way I am now doing it and it seems to work. Thank you all. Regards, KaW

Hi SV, Thanks for your reply.. but I am not sure I understand. Can I integrate the fourth (or first) criteria into the same code range? It's of course no point me sorting by one criteria, followed by the set of three (which would nullify the first). Sorry if I sound daft. KaW

Hi, I would have to sort a large excel sheet by 4 criteria . Using the VBA recorder below is the code, but only for 3 criteria - if I add a fourth, I get an error message... is it not possible to have 4 criteria?? Thanks in advance for any indication you can provide. KaW Dim i As Integer...

Ah, yes, that helps. However, the company names and addresses are in the same table tblCompanies (and contain cmpstreet and cmpcity). I would the have to change this part CboModel RowSource: SELECT tblModels.lngModelId, tblModels.strModelName, tblModels.lngManufacturerId FROM tblModels WHERE...

Hi, I am trying to find a template for an idea: Situation: I have a contacts database tblcontacts and a companies database, tblcompanies. When I enter a new name in the contact database (frmContacts), I would like to allocate a company (and the address and web site, etc details that goes with...

Perfect, thanks!!

Hi all, I am wondering. In the following Design view of a query, how do I change the date tblDescription.EndDate to be only the first three letters of the month and the full year?? Description: [tblCurrencies.Currency] & " " & [tblDescription.EndDate] Thank you so much in advance!! Kysteratwork

hmmm ... this appears to be more complicated than I thought. My knowledge on VB is very basic. Would you have an example that I can refer to? Kysteratwork

Hi all, I have a table tblCountry. The user should be able to enter a new country in a pop-up (alerady created) which contains CountryID (autonumber), Country and Region (dropdown to tblRegion). After the user enters Country, I want to force him to chose a region, too from the dropdown. So...

hmmm... the thing is: I don't have to update the City in this form, nor the country or Region. These should appear as the company is entered in the form (which in turn is selected from an existing list) Also, some companies have a city and others don't, but they all have a country (and...

Hi all, I have problem: 4 tables: tblCompanies (with BusinessCity and BusinessCountry - both IDs linked to tblCities and tblCountries) tblCities (with Country (an ID, linked to tblCountries)) tblCountries (with RegionID linked to tblRegions) tblRegions I would like to have in a form the...

ZmrAbdulla, THAT WORKED!! Wow - I am sweating like a dog, but it works perfectly. Thank you all for your help!! Kysteratwork

Yes and they are all blank

I will try that - but can I add data to the TABLE tblInvestorNames like this? Or would the InvestorNames and Country only be together in the QUERY?

Actually, that is not going to work... The situation is as follows: I have a tblInvestorNames which I imported longer time ago. However, I forgot to import the respective COUNTRIES to the tbl. And now I am stuck, since the ID (autonumber) in tblInvestorNames are linked to other tables. How...