Search results

I am constructing a database in Access 2002/3 which will link to a set of related photographs. The photographs will be stored in a specific folder structure and the filenames uploaded to a table. The pictures will then be displayed by giving the full pathname to the picture property of an...

If I read you right, then you need an Update query to populate the current record in the incident table with the held values in the template table. The combo box will need to have a unque id value as it's 'return' value. The incident table shouls also have a unique id to identify each record...

Thank-you GHudson. I had tried a variety of options but I was missing the step using Dir(currentdb.name). I have already written the code to pick up the links; but it was dependent on hard coding the "home" directory. I am new to this and will aim to use the search facilities more. However...

No it doesn't. Curdir() returns the current directory, not the directory in which the database is stored. Thus if the database has been opened from another directory it returns that rather than the "home" directory of the database - which is what I am trying to read.

I maintain an Access 97 database system with a number of front ends and two different back ends (for security reasons). The structure is replicated in different directories as there are training, development and back-up copies as well as the live system. I want the menu page to display the...

I don't know why, but it is true. In a footer, if you use sum, count ave etc functions and you have a mistake in one, all the controls will display wth error messages. I would guess, but may be totally wrong, that Access is creating a summation query, in the background, to fill in the footer...

I would suggest that you shouldn't be trying to repeat the data. The most efficient use of a database is to store the minimum data for each item in one table, using links to other tables to retrieve linked data. Un your bookings table you would store the engineer id, the job id (or barcode)...

Thanks for your reply. I suspected that I might be in the wrong forum, but I have never used one of these sites before and I am still getting the hang of it. I have a table which contains a field called Scenario. The field type is number and the field size is Long Integer. The default is set...

I am trying to store binary values (as decimal long integers) and then use bitwise comparisons to update the values. MS help suggest that the standard logical operators (And or etc) can do bitwise comparison as opposed to comparing boolean logical values for expressions; but I have found no way...