Search results

Problem solved ! The VBA code to trigger auto date & timestamp was: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo BeforeUpdate_Err ' Set bound controls to system date and time. DateModified = Date TimeModified = Time() BeforeUpdate_End: Exit Sub...

Since the last post, I have completed the core of the database except for one remaining look-up table. The monthly data exports are workig as required (making use of the datestamp fields). Append queries are working thus speeding up data population. However, I still have the errror message. This...

No offence taken, reponse is appreciated. The relationship between Table names in the attached files and the orriginal post are; Doc_Master (was referred to as DNT) Doc_Master_Rev (was DRT) Doc2Tag (wasD2T) Tag_Master (was TNT) The reason for starting field names with a ref to the table is...

Thank you for the response, I too always prefer to solve a problem rather than smear over it, I am just having to balance the triple conflict of having to produce a result at the same time as developing the database and simutaneously learning Access (having been used to Borlands Paradox)!! > I...

I have a (fairly) simple database with; Main table (call this DNT) a subtable (DRT) with full referential integrity to DRT a 3rd level table (D2T) with full ref integrity to DRT but is a multi - multi as its only other field (apart from date and time stamps) is linked to the primary key...

Gentlemen Thank you; the update has (finally) worked although it took me perhaps 2 hours. for others I make the following observations; The poor use by Microsoft of the English language added unnecessary difficulty - the row "Update to" should be "Update from" Having been exhorted to check the...

I am suffering novices frustration that I can't get something simple to work ! Using Access 2010 database that has been downgraded to 2007 (I imagine from an Excel import) I have created a table (lets call it Main Table (MT)) from Excel, moved the autoinc. field so as to use the first data...

Many thanks, it did indeed help. Some points for less experienced Access database builders; Microsoft did not like me typing in "SELECT" so the Row Source only worked after using the query builder. I still only saw 1 field until I noticed that only one column width was defined !! I defined the 5...

Using Access 2010; starting point for this post was 2011 post "Multiple Column Lookup Display- table & form" . I have a lookup table with 4 data fields whose values I need to associate with a Master record in my "Main Table". (The main table was initially created by importing an Excel...

I have worked for many years in documentation & data management and have specified many databases, small and large, but am not a programmer. All my personal databases still run in Borland's Paradox (that uses a C++ based ObjectPal language). I have used Access on and off for the past 13 years...