Search results

Hi! How do you call this type of form? Can anyone redirect me to a specific forum. Pls see attachment. Thanks Daryll

Thanks Mr. Arnel, I got it working

I want to count the result based from the select query, but this query doesn't work. A little help is appreciated. SELECT Count(*) AS Total FROM ( SELECT tblPoolReference.EntryDocID FROM tblPoolReference INNER JOIN ( SELECT Distinct Correspondence_ID, Reference_No FROM tblPoolCorrespondence...

How to interpret this code? If (lngPos1 > 0&) And (lngpos < Len(strAddress) - 2&) Then lngPos2 = InStr(lngPos1 + 1&, strAddress, strcDelimiter) End If

Hi! Could somebody tell me please what are the representation of these characters? 0&, 1& and 2& Thanks

This is the version I have (IIf(cbStatNotStarted = 0, 0, cbStatNotStarted) / IIf(cbStatTotal = 0, 1, cbStatTotal)) * 100

Thanks for dropping in.

Thanks! I got it!

Hi! Why this code still throws an overflow error IIf( (cbStatNotStarted=0 Or cbStatTotal=0), 0, (cbStatNotStarted / cbStatTotal) * 100 )

Thanks to all of your help. I got it working. This link is also a big help and merged with Arnel's post. https://bytes.com/topic/access/answers/555006-open-2-recordsets-once

Should it require second rsClone? Like, rsClone2 = rsClone1 if false rsClone1.movenext until it match. If match rsClone2.movenext, then again rsClone2 = rsClone1 loop till end of rsClone2? Sounds like it is the logic, i dont't know how to implement it.

This is the code, and it works. rsClone.FindFirst ("Discipline = '" & Forms![SmartDoc]![NavigationSubform].Form.[Pool Reference Entry].Form.[tbDiscipline] & "'") But i need this & Forms![SmartDoc]![NavigationSubform].Form.[Pool Reference Entry].Form.[tbDiscipline] to be replaced by a result of...

However, it set the first checkbox to True which corresponds to "Boiler" which is supposed to be on the fourth checkbox the "Comm". Can you tell me why is it so?

Mr. Arnel, I'm trying to learn your approach slowly but positively, absorbing the meaning of every line by googling. Now i'm a little bit positive, trial and error mode. So i've re-set my rs to: Set rs = CurrentDb.OpenRecordset("SELECT Discipline from tblPoolDiscipline") and manually set...

Additional Info tblRefenceEntry The Temp Table ( I need temp table so user can finalize prior sending it to master table) Generates the Master ID tblReference The master table Stores the ID generated from tblReferenceEntry Stores all information entered by end users through...

Hello Mr. Arnel, I set my rs to: Set rs = CurrentDb.OpenRecordset("SELECT Ref_ID from tblPoolPertinence WHERE Ref_ID = " & Forms![SmartDoc]![NavigationSubform].Form.[Pool Reference Entry].Form.[tbID]) I didn't get this part. It throws an error of "The Mircorsoft Access database engine does...

Relationship: 1(RefNo) to many(discipline) Main Form Fetch its records from a query (Select * from tblEntry 'the main table) Contain the discipline object Discipline object having the on_click event and if triggers, it open the Pop-up form Discipline field calls concatDiscipline module and...

Your suggestion is a lot way better, instead in the on_click event of a checkbox i inserted the DoCmd.RunCommand acCmdSaveRecord in the on_click event of the button. Same result with no overhead. Thanks

I have a simple continuous form which directly fetch records from its record source. A checkbox and description are only the fields which my form contains. Only the checkbox is amendable. I noticed when ticking the checkbox it doesn't apply the changes immediately to the table until moving the...

I thought this was a good practice to enclose a [] on field name so you may able to identify it easily between a variable and a field name. Anyhow, thanks @The_Doc_Man. Your lecture gives me an additional insight.