Search results

Thanks to both of you for your quick reply: 1) Yes, it does indeed work for the selecting the First (as in: First in the recordset) name and if there is only one (or few "don't care" fields, which need to be reproduced. This way of doing it won't work, if I were to select e.g. the Min() (as...

Hello, I have the following query problem. Consider the following table (field names and content): Code, Name, OtherInfo A1, Peter, Soandso A2, Paul, Blabla A1, Mary, Othertext A1, Jack, Otherstuff What I'd like to get back from my query is: A1, Peter, Soandso A2, Paul, Babla In...

Hello, thanks for the idea. Unfortunately, it's not so much a question of forcing the content of the spreadsheet to become numeric (e;g. by suppressing the asterix), but rather for the import to also accept text values, when the first few entries had been numeric... So in that sense, I want the...

To make changes to this field, first save the record I also have a problem with the initial error code mentioned "To make changes to this field, first save the record" Consider a three-tier table hierarchy, let's say IndustrySector (SectorID, OtherSectorFields) Customer (CustomerID...

Hello folks, I have problem, which I can't resolve. I use a the transferspreadsheet command in a form's module to import a certain portion of an excel spreadsheet into a table -- nothing spectacular: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "AC_Import", Me.Filename...

no, I'm afraid, I haven't...

I'm afraid, I don't understand. Is there anybody, who can help on this? Many thanks

This is probably an easy question, but the issues drives me n... Consider a situation, where I have 1:n relation between 2 tables, say: tblSupplier, with fields: SupplierID, AllKindsofInformation, CountryID tblCountry, with fields: CountryID, CountryName, Flag With all fields being strings...

Although it seems a very straightforward thing, I guess, I can't express myself clearly enough. There is a 'test' table, that would provide combinations like: wood/square/red/heavy plastic/circle/blue/light metal/square/yellow/heavy wood/triangular/red/light ... and there is a 'criteria'...

The answer to this is easy: When none of the specified criteria are met: then takethe last entry, which doesnt have any criteria... 200 in that case. Still I don't know how to do the query/function.

Hello, I have a question for something, which only seems obvious on the surface. I have a lookup table that contains information (let's say minimum time for something) depending on the characteristics of some criteria (let's say material, shape, color, weight). The lookup table doesn't contain...

Here I am, still with the same problem. Please help! Many thanks Jan

Hello -- anyone any thoughts on this? Thanks

Update/Add is allowed Yes, everything update, edit, add is allowed. Mind you, the update of a pre-existing record does work. It just won't add new records... Also, it doesn't seem to be a form issue, rather a query issue, as the same problem occurs, if the query is edited directly. Thanks

Hello folks, I do have the following problem, and - please do tell me- if I don't see the obvious. I changed to Office 2007 and am busy changing an Access Application. In the course of that, I included some .gif files in an attachment field, which were hitherto stored in external files and...

Hello, I have a performance, probably related to my query and calculation structure and would be seeking your advice. The DB is basically an airline schedule, with to make things simple, an entry for every flight. (tblSchedule). This table has information of origin and destination, airline...

stupid or blind...? Hey, thanks for the reply. However, next to being stupid, I must also be blind... can't find the relevant thread. Could you help? Thanks Jan

ok -- so how? OK, how wouldI do that?

Hello, this is what I'm trying to achieve and I don't know how: Based on a recordset (let's say entries in a table), I would like to create a graphical user interface, that shows a box/textbox/commandbuttom (actually an appropriate) at a certain position in the form for each record. The...