Search results

:cool: Hello all, Here is the problem: I need to check that a field (on a subform on a tab) has been completed. Because most of the records have already been keyed in, this particular field is already empty. Now the users must go back and check their data. Making the field "required" in the...

Hello, I have placed a control in the form footer of my form. The control does a sum of three fields. What I have noticed is that if any of the fields does not contain any data (even a zero) the Sum calcuation will not trigger. However entering even a zero will trigger the sum. eg:1 fld1...

Got it! Hello again, Thanks for your reply. Actually, once I applied your code I realised that my initial rules where wrong :( However I was able to work out what to do byt using your code. Thanks for that! May I ask a simple question about the syntax? fld3.Locked = Not(Nz(fld1, "") = "")...

Hello all, On my form, I would like to limit some of the user input. For example, there are three fields: fld1 fld2 fld3 What I would like is: fld1 can be entered freely fld2 can only be entered if there is no data in either fld1 or fld3 fld3 cant be entered if there is data in fld1...

Where? Thanks for the replies. Rich - I am not sure how to do that? If possible, could you explain that to me Thank you! dj_T

Hello, I would like to open a form from a command button. However, I would like the form to be ready to input a new record. For example, not to start at record number 1, but open in a state that is ready to recieve a new record. Any help appreciated! dj_T

Hello, I would like to run a Macro on a subform that triggers an apply filter based on a selection made from a combo box. On the after update event of the combo, the apply filter macro is run. The problem I am having is that I can't get it run on a subform. This is what I am using...

Hello all, I have a question concerning filtering. My objective - I have have seen done in other databases, but I cannot work out how to do it myself. This is what I would like to do: From a list box showing all the records in a database, the user chooses a record, for example record number 1...

Hello all, I have a startup form. On that form I have a control called "Display". What I would like to do is have 3 successive message appear in that control, at an interval of 2 seconds. Something like: "Message 1" wait 2 seconds "Message 2" Wait 2 seconds "Message 3" Wait 2 seconds Close...

101! wow! thats cool :) thanks again!

Hello all, I have a field that contains number data. I need to remove the preceeding spaces from this field in my query. How can I do this? for example: fldHouseNumber: " 1" should be fldHouseNumber: "1" I have searched through forum and found some complicated solutions. However I am...

Hello all, I have a question based on what I learnt in: http://www.access-programmers.co.uk/forums/showthread.php?t=56823 My main form contains a control that gets its date from the calendar. This date is then passed to the form's underlying query. In order to requery the form (and display...

Ah! Thats a good idea - in all my panic I hadn't thought of that. I thought was looking for a more complicated solution. Thanks. dj_T

Cheers! Thanks, Thats exactly what I was trying to work out. dj_T

Hello all, I would like to create a field that displays data from 1 or other fields, that contain data that has been keyed in by the user. For example. The two field are called: fldAmount1 fldAmount2 The criteria would be something like this: fldCurrentChoice: if fldAmount1 contains data and...

Can't use form at present Hello, Actually - at this point, I am not allowed to alter any forms at all on this database. I can only use queries/reports to get what I want. Eventually I will use a form to provide the date input, but for now - I am only allowed to use the queries/reports to get...

Hello all, I have a table that records comments. Comments are entered by date and are linked to a master table. For example. Master record 1 ID1 Comment 1 01/01/2000 ID2 Comment 2 02/01/2000 ID3 Comment 3 03/01/2000 Master record 2 ID5 Comment 1 12/01/2000 ID6 Comment 2 15/01/2000 ID9...

Dear all, I have a query that returns data based on a date. The user is asked for a date, then every equal to or below that date is returned. For example: fldDate: <=#01/01/2004# What I would like to do is to generate a field that will tell me what "less than or equal to date" has been...

date Thanks again. I will also look at your example later. Cheers! dj_T

DAte Thanks for the reply. Actually - I have tried the following: Date: Format([Month]," yyyy mm") which allows me to order the data. Is the correct way to use the Format() function? Thanks! dj_T