Search results

Hi.. You want something like this..: ;) select * from ( select [PolNum], [Status], [Plan_Name], [SSN], [Name] as trz from dbo_SiouxFalls_POLICYLIST where [Role] ="10" union select...

add this way.. ;) select p, x, y, z, date, x-(select last(x) from table_name where date<trz.date and p=trz.p) as Xdifference, y-(select last(y) from table_name where date<trz.date and p=trz.p) as Ydifference, z-(select last(z) from table_name...

I updated the code again.. ;)

sorry.. :( re-edited my message above..

Hi.. can use this query..: select p, x, y, z, date, x-(select last(x) from table_name where date<trz.date) as Xdifference, y-(select last(y) from table_name where date<trz.date) as Ydifference, z-(select last(z) from table_name where...

Hi.. Try to export in this way..: Dim trz As Integer Dim strCSV As String For trz = 1 To 511 Close #trz Next trz trz = FreeFile Open "c:\Export.csv" For Output Access Write As #trz With CurrentDb.OpenRecordset("ExportTable", 4) Dim x As Integer...

Hi.. Try this..: =iif([Attachement_ID] is null,null,DLookUp("[Attachment]","[tblAttachments]","[ID]= " & [Attachement_ID]))

Please try this way..: SELECT tblWorker.[FirstName] & " " & [LastName] AS WorkerName, tblWorker.HomePhone, tblWorker.MobilePhone, tblWorker.Town, tblWorker.County, tblWorker.WorkerNotes, tblWorker.Available, tblWorker.RegDate, tblWorker.CSCS...

Hi.. Add a textbox (textboxname) and a button on your form (form_1).. Put this code in the button..: docmd.openform "form_2", , , _ "cstr([firstname]&[lastname]&[phonenum]&[address]) like '*' & '" & me!textboxname & "' & '*' " .

Hi.. vbaInet's implementation of the proposal ..: Private Sub Command10_Click() If Nz(DCount("*", "Q_PSE_Pupil_Search"), 0) = 0 Then MsgBox "Your warning message here" Else DoCmd.OpenForm "F_PSE_Pupil_Profile" End If End Sub this is a different solution..: use the...

Hi.. Try this way..: Dim Findrecord As DAO.Recordset Set Findrecord = Me.RecordsetClone Findrecord.FindFirst "cdbl([Date]) = " & cdbl(Me![EnterDate]) If Findrecord.NoMatch Then MsgBox "Name Date Not Found" Else Me.Bookmark = Findrecord.Bookmark End If

Hi.. As an alternative; you can change the structure of the criteria in this way.: SELECT tblWorker.[FirstName] & " " & [LastName] AS WorkerName, tblWorker.HomePhone, tblWorker.MobilePhone, tblWorker.Town, tblWorker.County, tblWorker.WorkerNotes...

Hello.. This could work..: SELECT tblMemberRepayments.RepaymentID, Max(trz.CommID) AS MaxOfCommID, trz.CommDate, trz.CommTime, trz.OperatorID FROM tblMemberRepayments INNER JOIN ( SELECT CommID, CommDate, CommTime...

Hi Denis.. :) UAP Bal: DSum("UAP";"UAP Bal qry";"cdbl([Month/Year])<=" & CDbl([Month/Year]) & " and CaseID=" & [CaseID]) You can add this to the relevant area.. Greetings..

hi.. Try..: form / properties / timer interval ..: 100 on timer evet procedure..: form.caption= screen.activecontrol.name

let I briefly describe..: Report / Properties / Event Tab / On Open (Click [...] button) / select Event Procedure / paste code..: Forms!your_form_name.Visible = 0 Do the same for other events..

Hi.. Private Sub Report_Close() Forms!form_name.Visible = -1 End Sub Private Sub Report_Open(Cancel As Integer) Forms!form_name.Visible = 0 End Sub Use these commands, the report is opened and closed events..

Merhaba Fehmi.. seems to have a connection problem..: try this way..: INSERT INTO FATURA1 SELECT * FROM fatura1 in '\\Kaca1\barkod\barkod.mdb' mdb extension is assumed..

hi.. that part of use in this way..: UAP Bal: DSum("UAP";"UAP Bal qry";"cdbl([Month/Year])<=" & cdbl([Month/Year])) .

Hi.. except for the first two options to list all records, can write the field name of the criteria..: IIf([Forms]![Payroll Report Form]![Frame28]=1,"PA",IIf([Forms]![Payroll Report Form]![Frame28]=2,"WV",[STATE])) I hope, I understood the problem correctly. :o