Recent content by jan@BRU

Hello, thanks for the reply. I have done as told. Thing is, the only thing I can find in the way of Sharepoint server space is something that costs upwards of 30$/month just for that service , while my regular hosting is something like 5$... Two additional questions on that: - While I...

Folks, I appreciate that this question is absolute rookie level, still I hope you forgive for still asking it. I have been developing ms access desktop applications for some time, works ok, for what it's worth. Recently moved to access 2010 and discovered the "deploy it easily on the web"...

This is getting embarassing, with all your help ;-) Unfortunately the db example isn't exactly what our need neither, although it seems to go in the right direction. As a matter of fact, the criteria (which you are getting from the form) is always set... It's the "rules" in the tables which...

All, appreciate your efforts very much. But this one is not working neither. Again, I would like to have exactly one result from this table. If it's an exact match (all 3 criteria matched), then that one. If no entry like that in the table, try 2 criteria match, if still not, 1 criteria match...

Hey, thanks for this reply. I have tried the suggested solution before (with a parameter query): SELECT SCH_MGT.AircraftType, SCH_MGT.AirlineDesignator, SCH_MGT.Airport, SCH_MGT.MGT FROM SCH_MGT WHERE (((SCH_MGT.AircraftType)=[AircraftTypeSel]) AND...

Friends, I have a problem, which seems straightforward to solve, but I can't get around doing it. I have a table (tMGT) , which contains the following fields: AircraftType, AirlineDesignator, Airport, MGT MGT is minimum ground time. The table actually contains the minimum ground time for...

Hello folks, following on to a in issue I had earlier, I am still struggling with my form. Issue is the following. I have a form, where a textbox is linked to a datefield. I want to be able to enter a time into this field both in the hh:nn and alternative also in the hhnn format or be able to...

Hello, I have a problem, which seems banale, but I can't get it to work... any help is appreciated. I have a (large) table (>1 m records), which contains several fields, storing time (and time zone bias) information. In order to reduce overall size of the database, I have not used date/Time...

Stopher, would you mind repasting the link ... Many thanks jan

Brian, yes this is perfectly what I want. 2: 00000010 3: 00000011 11: 00001011 applying a bit-wise AND 2: 2: 00000010 should yield a 2 in all case, as, it tests, whether in 2, 3, 11, the second but last significant bit is set (which is the case for all of 2, 3, and 11). Guess, I will...

Hello folks, I have a short question with respect to the usage of the AND operator in queries. in VBA, "AND" can be used to make to make a bit by bit comparison of integer numbers, e.g. ? cbyte(47) and cbyte(254) yields 46 It's precisely this function that I would like to reproduce in a...

Yes, you are right, for this. unfortunately, it only works with one level, not with a cascade. Problem is that i need to know the newly created keys in (your) subtable, in order to do the same in subsubtable (Table 3 in my example)....

thought about that, but for many reasons, it won't work for me, not the least of which being that I'm already on a subform. Anybody knows, on how to get those unbound attachments to accept and display stuff, that's already elsewhere in the database? many thanks jan

Hello, yes the first question - sorry I forget to mention it. The purpose of the whole process is to create a the starting base of something, that will be changed subesequently. So yes, initially it would be duplicated, but be modified aft rthat... so no problem with data integrity. Well...

Hello I have a database, which has the following structure: Table 1 (Files) (ID1, Filename) Table 2 (Schedules) (ID2, Airline, ...., ID1) Table 3 (Flights) (ID3, Flightnumber, ...., ID2) Table 4 (Additionalinfo) (ID4, Soandso, ...., ID3) As you can see it's a real non-redundant structure...