Search results

Hi All, Using A97 Ive splt a database FE/BE. I've setup a new workgroup file and created new group and users for that group with various permissions. I've placed the MDW (Mydatabase_FE.mdw) file in the same place as my FE/BE databases. I've then run wrkgadm.exe and joined the default...

Hi all, long time no post. Good to see you all still fighting the good fight! On to business... I use A97 Got a query which finds duplicate records in a table ( duplicates defined as having same Postcode and Surname as another record) for a given Filename ( each record is assigned a filename...

I've got a problem where my SQL string is finding dates in US format ie mm/dd/yy. All my forms, tables etc are dd/mm/yy ( my regional setting is dd/mm/yy). Reading the help file it says that all 'Date literals' in the criteria argument must be in US format. How do you acheive this when every...

First things first - using MSAccess97 - my records are related by RecordID ( in tblMain) to RecordIDAdditional (in tblAdditional) Records are added to tblAdditional by using unbound frmAdditional(code is used to pass through data). Records in tblMain are viewed by using bound frmMain I want...

Hi All, I have used a combo box wizard to find a record in a table (tblMemberDetails). I have 2 fields txtMemberId and txtMemberName (I select a member ID ( 001 to ...) to find a member name on a form frmSelectMember However, when the form loads the 1st record in the table is displayed in the...

Hi all, I have a main form (based on tblMain) with 2 subforms( based on tblAdd1 & tblAdd2)on it (linked by common field record_id). My problem is I want tab through the main form as if it were one form. I only need 1 record from tblAdd1 & tblAdd2 to be visible in the main form (ie only show...