Search results

My mistake Sorry for the waste of a post :rolleyes: I forgot to put the exe iin the shortcut target : i.e "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp "C:\My Databases - Access\Secured\Mydatabase_FE.mdw" "C:\My Databases - Access\Secured\Mydatabase_FE.mdb" That works...

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

Too few parameters error pdx man. Thanx for the post. Seem to be getting a TOO FEW PARAMETERS error tho'. Cant see why??

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

Thanks for the advice. Helpfull as always. I've done what you suggested ie Format ( mm/dd/yy) and it works just fine and I'll try to stick to one date format! Once againg thanks!!

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

Thanks, it worked. I thought there would be a simple solution ( to use a cliche - you cant see the wood for the trees sometimes!) Once again thanks for your prompt reply.

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