Search results

Thanks. The link to the file is broken. Will appreciate if someone could help.

I have following forms: frmSHE - parent frmSHEMain- first sub form frmSHEMainSF - second sub form frmPerson - a sub form of frmSHEMainSF I am trying to use a value within the frmSHEMainSF to ensure that users after selecting an incident type always fill a field (name) on the frmPerson using...

OK thanks. Will try again. Though I am not very hopeful as I did exactly the same before by importing objects and amending refs to exactly the same as in the original DB. Will try anyway and report. Regards

I was experiencing sluggishness in my DB, so decided to create a fresh copy by importing all objects into a new db. As expected, I had to add some references. However when I tried to turn on this FE which normally shows a splash scren and then the switch board, I could not quite go beyond the...

Thanks. Looks like the code I reproduced was not correct. Please could you the following and see if you can amend it. Public Sub combine_descriptions() Dim rst As Recordset Dim strLocNo As Integer Dim strLocation As String Dim strProject As String DoCmd.RunSQL "Delete *from...

There is no particular line causing the error. It is the same error I was getting after running the code. What i am saying that even after taking the changes you made I still have the same error right at the end of routine. Public Sub combine_descriptions() 'turn off warning dialog...

Many thanks. After posting my question, I continued to work on changing the code to suit my situation. To test your code, I carefully amended it to reflect the changes I had. I have reproduced the current code below for your ref. This still works but I still have a runtime error 3021 'no...

I am trying to use the following code to report two values into one line.It works fine except for the fact that when it writes the last record, it errors out with 'No current record' error. Could someone help me amend the code to prevent this error from happening. Public Sub...

Thanks. I just checked it but the issue seems to have fixed by itself. I no longer have the filters on. But there is something very interesting that has happended. The excel file now has an additional sheet in it with a pivot table on it (using status field) and that pivot table has a chart...

Thanks. Yes I can make changes to Excel file as you described but I am mystified why should this be happening. As this is happening to all users of the database, it has nothing to do with the Excel set up. I have re produced the full code in case this may give you some clues. Sub...

I used to produce an excel file without a hitch. But lately, when I run the same code, the code works fine and produces the excel file but funny enough when I open the spreadheet, it already has a filter on a field. I can still live with that but after I turn off the filter, the spreasheet does...

I really appreciate yoir appreciate your help.

Thanks Bob. Should I put all text boxes (representing each page) this in any particular section? Looks like detail section has a limitation too.

Just wondering if there is a way to add 4-5 pages before the start of actual report. I tried putting it in page header but it does not expand more than 55 cm. Report header does not work either and if I add to detail section, the text gets repeated.

Thanks John. No I have not tried writing a complex function, hence this request for help. I am a very basic VB user. If you could kindly help out, I will be grateful. Cheers

I use the following formula in my query to work FY where last week day in June is end of the FY. Works well. Is there a possibility that I can have function which does the same thing so that it readily available everywhere in my DB. Fin Year...

I have created a chart which looks at number of projects completed between July last year to June this year. It works well except for the fact that months appear in alphabatical order and not quite as Jun 10, Jul 10 and so. I am using the following syntax to get months. Month...

No it does not work, I tried it,. But for the nefit of thiose reading this ghread, the simple soklution is to put following statement in the detail section and that will kind of make it easier to view reports with hundreds of photos but may not necessarily remove the import message. ...

In my report I have a en embedded photo field which basically looks up a photo in the local drive and drops it into the report. Whole thing works good. The only issue is when I fire off the report, I can see message 'importing xxx.jpg from file path. Is there a way I could suppress this...

I came across a good KB article on this and tried to use the directions to create a TOC. Somehow, the result is half baked as the table created does not quite list all depts. I was wondering if someone had any experience with this. I am using the following process. I hope I am not missing any...