Search results

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 ?

Is it possible for AutoNumber ID not to skip deleted IDs ? for instance if I deleted item with id # 5, I want the next record to have Id # 5

sure -- Private Sub Command213_Click() 'my stuff Call SendNotesMail("", "", "bugsy@bugsy.com", "", vbYes) End Sub Public Sub SendNotesMail(Subject As String, Attachment As String, Recipient As String, BodyText As String, SaveIt As Boolean) 'Set up the objects required for...

I did, but then a record with date of 02/11/2008 and Importance of 4 comes back such record doesn't even exist. The record i need to select has a date of 02/11/2008 and importance of 5. Also, once i get record with importance 5 - i need IT'S Status whih is 'tttt', not MIN (Status) or Max9Status)

Hey all I have data in the table. (various IDs - in example below just 1) Each ID has date and status. I need to pull each ID only ones for MAX date If there are 2 like that (with different statuses) i need the one with lowest importance. Any advise ? Status LogID Date ID Date Importance...

yep. all other accedatabases are fine.