Search results

Sounds to me like you have a null value problem....unless I have misunderstood you. You need to amend your data in the query SQL to something like: WHERE (([ref for your table].[field name in table]=Forms!name of form!field in form Or Forms!name of form!field in form Is Null) And ([ref for...

Thanks for that. I still do not know how to use it, to get my calculation to run without having to click or amend the member task box. I am sure it is fairly simple.......I hope!

How do I use the OnCurrent event as its not on the event list. Could you tell me in simple terms as writing code is not my speciality as you have probably already guessed. Thanks

I was just doing this for speed today - I will rename eventually do I know what everything is. I need the calculation to run the instant the record is pulled up. At the moment the member task record needs to either be clicked or changed to trigger the calculation to the job time. At this...

Yes I take your point, I suppose it is not worth the hassle later on for a bit of effort now to change the forms (a query is not what I require for the specific jobs at this point). I do have a further qestion regarding this. I have set up a form to enter the initial data - no problems...

Oh, not what I wanted to hear....! Why will the table not simply update, the same as if a new field was chosen from a drop down (apologies if this sounds stupid). I take your point that it can be calculated in a report or form, however I have various update / search forms etc for the...

The idea has worked to a degree however there is one flaw. I have put the code listed below into the control source of the text box. =DateSerial(Day([Daterec1])+[jobtime]) Works fine except that I cannot now save the result in the table. Any ideas on how I can get around this? Thanks

I am not sure if you have misunderstood my initial question or whether I just dont understand your replies. My question was how to autofill the target date field by using: Member task - dropdown the member chooses Task time for the member task (pre set in the table - however user can change...

Hi, I have set up a form with combo boxes, which get their data from tables. I have also set up a received date box which uses a calender to fill. The box on the form I need to autofill is the target date. This will obviously be a date in the future. I can set this as a standard date by...

Hi, This works great thanks, however one quick further question. Is it possible to use this method for seven to eight dropdowns (i.e. to filter the records like query parameters)? Thanks K

When I was talking about entering 'new' data, I meant the user had cleared the selection and was selecting new data from the combo boxes. The = null method works fine thanks and with no errors. Thank you very much for your time and help. K

Hi, I have created a form with drop downs to set the parameters for a specific query. I have also created a command button to run the query when the desired parameters have been chosen. The query then pops up when the run button is pressed. Is it possible to add a button (attached to the...

Hi, all of the fields are combo boxes, which get the data from tables. I cant seem to get what you have suggested to work and I think it is because of this. On the other hand it might be me misinterpreting what you are suggesting. I am not the worlds foremost expert when it comes to Access...

I have set up a a form to select the parameters for a query. I have tried to create a button for the user to clear all of the parameters to save them having to do it one by one manually or having to close the form and reopen. I have used the following Event Procedure: Private Sub...

Thanks Brian, this was spot on.

Hi, Please see the SQL from my query so far... SELECT [Task Screen Data].[Task Reference], [Task Screen Data].Client, [Task Screen Data].[Administrator Dealing], [Task Screen Data].[Date Received], [Task Screen Data].[Task Type], [Task Screen Data].[Member Task], [Task Screen...