Search results

hi i have a piece of code that carrys out some form validation, see below 'form Validation Function CheckForEmpty() As Boolean CheckForEmpty = True ClearControlFormatting Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.Tag = "FILL" Then...

Apologies it was due to the query being aggregated, which cause the field to be truncated

hi, ive written an if statement to check if a sub form is open before requering it, but im having an issue with c alling the object, below is my if statement, what is the correct method of calling the sub form inside a form please. If...

hi, thanks for your reply, i've just loked at that, found out it was an issue with aggregate data

hi im trying to append data from one table to another, but it seems the query is limiting the character to 255, is there a way around this? the table field is set to long text on both the table the data is coming from and the table where the data is going to.

ive found the issue

hi all i have a field on a form that is limiting the charactor count to 255, ive checked in the table and the field is set to long text and rich text the text box on the form is alos set to rich text, but its still limiting the charactor count to 255, is there anywhere else apart from the table...

ive done it, should of tried a little harder

hi all im trying to filter a query based on two fields, these two fields are date fields, [DateComp] and [DateCreated] what i would like to do is return all entries when [DateComp] is empty and todays date from [DateCreated] ive tried to add "IsNull" to the [DateComp] critieria, which...

thanks for the help, i decided to handle the check box on another form, which achieved the same result

thanks for the reply, forgot to mention, on the sub form under Total hours, under the control source of the field i have this "=[Minutes]\60 & Format([Minutes] Mod 60,"\:00")" which converts the total minutes in the hours and minutes, so if i remove the sum this no longer works.

thanks ill take a look

if i remove the grouping i get an error (which ever field is first i,e Manhours_ID) your query does not include the specified expression manhours_ID as part of the aggregate function

the field "minutes" is an aggregate on the form its viewed as "Total hours"

Hi all i have an issue im not sure how to resolve. i have a query thats grouped in in that query is an expression, that calculates total hours, baed upon a user and date which is the last box in picture 1 below. picture 2 displays the sub form that the query is bound to, in table TblManHours...

its ok ive sorted it now, thanks for the pointer

thanks for your reply, could you elaborate of give an exmple please, im not sure how it would work

i have two fields on a continous form, reason im using a continous form is so i can use a delete entry button. CbxEventTracker and CbxNonEventTracker when the CbxEventTracker has an entry, i want to grey out the CbxNonEventtracker field this is what i used Private Sub...

yes primary key from TblManhours.ManHours_ID and Foreign key from TblManHoursType.ManHours_IDFK

yes there is a master/child relationship