Recent content by Allan.Day

Thanks for Reply Mr Rx Yes, Sql Express running on a PC It is possible to connect to sql express running on a windows 7 pc from another computer with xp installed? what should i do to make a 3 computer connected by lan and can share sql server data with access accdb front end thanks in advance JD

Hy Galaxiom, Authentication with sql server login, that work fine on local computer, the problem are how to connect to sql server on another comp that not windows server, just connected with lan thanks

Dear All, Please Advice : At XYZ Company there are three computers admin installed windows 7 and windows xp, so no windows server 1. Comp X with IP 192.168.1.12 installed sql server and installed Microsoft Access 2. Computer Y with IP 192.168.1.13 not installed sql server and not installed...

solved by () thanks everyone

actually the need is between openingdate and closingdate Doesnt Work : WHERE doc_date Between IN (SELECT OpeningDate from dbo.PeriodTbl) and IN (SELECT ClosingDate from dbo.PeriodTbl)

Dear All I have two table 1. dbo.period (OpeningDate, ClosingDate) 2. dbo.data (blah blah, doc_date) I want to create a view as follows Select doc_date from dbo.data where doc_date> 'select OpeningDate from dbo.period' both doc_date and opening date have the same format but the error...

Thanks David the field is being used to trigger the key press event is "reference" when "S" key pressed, this triggered form 2 to pop up, and show list of reference that user can choose, why I don't use combo box, with this way, user doesn't need use mouse, and when list double click, it...

Hi Nigel can you upload the sample database? thank you allan

Dear All I have 2 form, form1 and form 2 (picture attached) In Form 1 (main form) there are "reference" field with key pressed event then call form 2 (list of reference that user can choose) In form 2 the problem is, when "enter" key pressed (keypress event), selection will move to next...

Dear All, Need Help, this is a progress bar, what i need is, while execute loop (progress bar) but also execute next command = "LedgerExe: thanks in advance On Error GoTo Proc_Err Dim inti As Integer Dim dblPct As Double Me.txtPctComplete.Visible = True Me.boxWhole.Visible...

thanks Mihail Actually that is my first choice, but we need a fixed height detail that did'nt affect how many data there, this report is like a invoice or tax form, that usually printed template paper,

Good Day Mihail already change format to access 2003, need your advice thank you in advance _allan_

Dear All already change format to access 2003, the situation : report detail with subreport overheight the goal are : On Print Preview fixed heigh detail, when subdetail reach maximum heigh ini detail the rest of the data will print on the next page thank you allan

i'd add Paul code suggestion as below : Forms!EditJournalFrm!DocDate.Locked = True Forms!EditJournalFrm!KdVoucher.Locked = True Forms!EditJournalFrm!To.Locked = True Forms!EditJournalFrm!From.Locked = True Forms!EditJournalFrm!HeaderNote.Locked = True Forms!EditJournalFrm!InternalReff.Locked =...

Thanks Paul iam new comer, so can you explain me what the difference and how to use the argument in openform thanks fo your great response