Search results

Guys, I've been trying for ages to get this message to appear but have had no joy. Please help Code: Private Sub MTORec_IsoRev_DblClick(Cancel As Integer) If Me.frm_MTOCtrl_DocRevCtrl.Form!QualType = "" Then MsgBox ("You must select a document below in order to revise it!")...

YES YES YES!!!!! It's always something simple haha!! Thanks alot Marlan!!!

Hi guys, (Using MS Office 2007) I have a delimited text file (see attached) (delimiter is semi-colon) and want to create a linked table in a db. This was working without fault until yesterday afternoon. When I link the table now, it duplicates the data horizontally so instead of having 12...

Woops, it's attached now.

Woops, sorry!! It's attached now.

Hi guys, I have 12no. tables containing days for all the months of the year. I know this is against normalization rules but I couldn't get around this format. I needed a timesheet that mirrored the screenshot attached. Now I want to create one report that will pull data from a specified...

Ahh! I understand now. Thanks missinglinq!!!

Thanks Neil!!! That worked. Any idea's why the SUM function just didn't work? Thanks again for the help. :D MayoRR5

Hi all, I'm having a problem with a "calculating text box". In the [Item_Total] box I have the control source "=[SumOfQuantity]*[Unit_Rate]" and [Unit_Rate] is a value that is calculated in the Query controlling the Report. All works fine to this point. Then I have a group header and...

You are a legend John BB. That has been annoying me for about 2 and a half weekd now :o Thanks for the help!!!!! MayoRR5

Hi all, I have a text box on a form which I want to be controlled by what is selected in a combo box on the same form without the use of queries and subforms. For example:- Table 1 tblSchedule contains a unique ID(SchID) and a value(SchValue) for that ID. The combo box will show what...