Search results

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"...

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...

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...

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...

Hello I have the following problem and was wondering, whether anybody could help me with that. I have a table, that has a unique identifier (ID) plus an image as an attachment (Access 2007). What I now want to do is the following. ON a form, display the (say) 10 first images of the table on an...

Hello, I have the following situation: Consider a table with the following fields: ID, A, B, C, X, Y, Z ID is a unique (long) identifier (autonumber), all other are strings. The A, B, C fields are pretty repetitive and contain "long strings", while the X, Y, Z fields are variable, and...

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 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...

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...

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...

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...

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...