Search results

Hi! Why DoCmd.OutputTo acOutputReport is locking the table even though the report was closed? Is there a way to release the table and initiate a drop table query? Note: I need to keep the file that was exported.

Hi! Please share your thought or a link to a discussion with code samples as to how to achieve this simulation. User intervention to abort Scripting.FileSystemObject CopyFile() with a button.

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

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...

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

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

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...

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 have a continuous form with field "Attachment" which will count all attachment relevant to the ID of the form. I was able to count the attachment with this =Nz(DCount("EntryDocID","tblPoolAttachmentDetail","EntryDocID = " & [tbID].[Value]),0) but at the end of the row where you will see the...

What is the appropriate path to reference a sub-subform in a navigation form from outside form. This path work if you are in the navigation form, but not on outside form. Forms![Nav Form Attachment]![NavigationSubform].Form.[Pool eFile Attachment].visible=True