Recent content by bugsy

a little more details -- both table s have composite primary keys tblUnivePort - Univ and Port tblUnivFunc - Univ, Proc, Func I can't seem to make "CASCADE DELETE RELATED RECORDS" with this...

DELETE FROM tblUnivPort, tblUnivFunc WHERE tblUnivPort.Univ= tblUnivFunc.Univ AND tblUnivFunc.Proc="PORTCHAR";

great !!!! thanks

Not sure if i am wording it right. In a query i have calculated field that is using Date(). Instead of Date() I want to use a value in a table that only has 1 record. How can i reference that table ?

its probably easy I have a report that's based on a query. Changed a query to add an additional srting. Query now looks they way i want to. However report still looks the same like before ! any advise ?

i usually use TransferSpreadsheet does anyone know where i put the tab, if excel has several tabs ? DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes

Hi I have an insert statement on a form sSql = "Insert Into ChangeHistory VALUES ('" & Group_Contact.Value & "', '" & ID.Value & "','" & ctrl.Name & "','" & ctrl.OldValue & "','" & Value & "', '" & User & "','" & Now & "')" CurrentDb.Execute sSql What should for it to accept value...

now i get run time error 424 object Required

changed. Get exactly same error.... :rolleyes:

Hi all I have several databases that use the same code wor exporting query's results to excel template (at the end of the message) For some reason when i try to recycle it once again I get error message Run-time error '-2147467259 (80004005) Method 'CopyFromRecordset' of object 'Range'...

hey Brian I asked desktop to check Access version of that user; they reinstalled something called "Service Pack3", and it mysteriously worked. The error messafe simly said - (gave the text of the function) is not recognised.

Hi All I've created a database where a query who'se result is loaded on a form uses following function -- DateDiff('d',Date(),[Target Date])-(DateDiff('ww',Date(),[Target Date])*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between Date() and [Target Date]) I've notice that 2...

missinglinq Thanks ! it works graet ! (i substituted "msgbox" for insert statement)

what's an 'Audit Trail" ? anyway i can use activecontrol ?

I see forms have even After Update IS there a way for me to see which field was updated and what was is the new and the old value ?