Search results

Anyone know how to resolve the problem as described in the attachment ?

You may refer to the above attached file for more info.

I have the below coding to loop and to read all the value inside a combo box. However, from the immediate windows, i have detected some abnormal looping from the coding. Can anyone suggest and correct the below coding ?

VAL function do NOT work out as expected Query above show the 3 fields:- a) ModuleNo – data extracted from original table b) ModuleNo1 – data generated from the ModuleNo field with function val(ModuleNo) c) Revision – data extracted from original table As you can notice, if...

How to write macro to refresh link excel ?

As described in the attachment below, how to code the initial value in combo box?

How to convert from the source to the output format as shown in below attachment ?

Thanks everyone here for the help. I manage to get this problem resolved after i notice something goes wrong to the PDF file.

Thanks for the above clue. I got a better explanation through this link

Earlier I hv mentioned above code, any idea how to open a PDF file in a MAXIMIZE mode by using same way ?

I try this, it doesn't work. I think it should come together with another method call AppActivate. Correct me if I'm wrong.

Given a string c:\ABC\CDE\TEST.pdf . Any suggestion to use mid, instr and etc to extract the string above to obtain the file name as TEST.pdf

I got the error "Path/File Access Error" when using below command FileCopy strPDFFilePath, rsTemp2("PDFFilePath") Any resolution or equivalent code ?

A form consists of one text box and one list box. Whenever user key in a character into the text box, the list box will be scrolled down automatically to search the most relevant text base on the total text which has been input by the user. Anyone know how to write VBA to auto-scroll down...

I got the answer. TQ

Anyone familiar to writeVBA to call a PPS file?

Below is my code DoCmd.OpenReport "Report_PT", acViewPreview, , "LotNo1='" & strLotNo & "'" How to maximize the report display screen ?

Any chance to download this ?

I have referred to this link, however, still cannot figure out the right approach to code. As illustrated in the attachment below, can anyone assist me on how to assign a subform value to a control in the main form ?

Please read my above reply. TQ