Search results

Fantastic work around. Really appreciate your help. Regards

I am using the following code to open a linked photo with each record. It works well. The only issue is that when I get to the last record, and there is no associated photo, I get runtine error 2200: Microsoft Access can't open file 'H:\Future Store\Photos\'. Is there a way I can prevent this...

Thanks Bob. A very nicely written tutorial. As I understand now, I have main form (A), the field I am testing against is in the sub form (B)and I am merely trying to make the sub sub form container (C) to be disabled based on the status of field on form B. If my code resides on form B, then do...

Thanks Bob. I have mended it but looks like the reference to form is treated as field because I am now getting an error that '.. can't find field 'frmNonCom' referrered to in your expression. Just to be clear ConRefNo field is what we are testing against and that is sitting in the sub form...

I tried following in the on current event of frmProjectsConstSMSF but I still get the compile error : invalid use of property and it selects me.controls. Me.Controls ("frmNonComp"), Form.Controls("frmNonComp").Visible = Not (IsNull(Me.ConRefNo))

I am getting compile error on the second line. It is method or data member not found error, variable not found. I suppose I could hide the form but that would leave the tab blank, so I thought disabling it will be a better option.

I have a main form (frmProjectsConstSM) with a sub form (frmProjectsConstSMSF). This sub form has another sub form (frmNonComp). I have a field on the frmProjectsConstSMSF. I would like to disable data entry in frmNonComp unless the field is not null. I usee the follwoing on the on current...

Thanks Bob. Tried it but no luck. I still cannot see through the link manager, they these are visible in the BE.

I am trying to link a couple of tables in FE from Be. It is a routine affair most of the time but this time round, when I added two new tables to the BE and tried to link in FE, I disn't see the newly added tables in the link table manager. I searched the net for solution and usually in...

Good point. Thanks.

OK thanks. Wish there was a program which could identify related tables and help extract ot append records.

I have an access database with a large number of tables with relationship to a parent table. I recently noticed that one record went missing and apparently deleted from the parent table and as a result of this the supplementary data got deleted from every single related table. It has not...

Many thanks for your help.

May I ask you a slight improvement. I might like to retain the copy of spreadsheet for record. So is it possible to somehow add date/time stamping as part of file name and to ensure that files does not get deleted. I am using a statement similar to the following based on your kind help. Sub...

Much appreciate your help.

I have to be able to provide a user the option to export info from a number of queries to a single spreasheet (each query result on a different worksheet). What is the best approach to achieve this?

Not too sure if it is the right result as I could see multiple rows with concatanation. But apreciate your help.

Doesn't that provide counts only?

I have a query which is based on 1toM relationship where one project may have a list of design features ehich currently look like as under. ProjectID DesignBrief 8527 Paint store 8527 Wall graphics 8527 Bulk head 8527 HBA equipment I would like the Design Brief rows to appears as column...

Thanks for your help.