Search results

I would imagine it should go in the code behind the command button, before it saves the record & moves to the next. But you haven't given loads of info, that's based on you saying:

Assuming it's all the 0s which need to be replaced just swap the "Is Null" criteria in your planned update query to 0.

Then there you have it. There are no nulls, only 0s. As such you cannot do anything to the null values, they don't exist.

And how many which do not allow duplicates?

If it was changed from a text field to a number field that could explain why your nulls have been replaced by 0s. Are they still null in the table / select query or are they always 0s now?

If forms!CallDatabase!SubformObjectName.Form!ControlName = null then 'code if field is null Else 'code if field not null End If Note that it's the name of the subform control, not the form which it contains.

It should be referring to the amount of fields in the table which have the index property set to yes (no duplicates) or yes (duplicates ok), or something similar.

FYI another possible solution would be to add 2 fields to the query: [From] AS StartDate, [To] AS EndDate (in the query browser this would be "StartDate: [From]" & "EndDate: [To]"). Those fields can then be used in control sources either as a field or concatonated into a string.

Something like this in the date referred textbox's after update event should do it (replace my control names with yours): If txtDateReferred > txtDateSeen Then msgbox "Date referred cannot be entered as a date greater than the date seen" End If :edit: I forgot to include setting the...

Put the whole thing in a Round function: Achievement rate: Round((CInt([Passes])/CInt([Ach_total]))*100,2) The final 2 is the number of decimal places.

I thought OutputTo automatically gave a file browser prompt if you didn't provide the location in the command? I'm fairly sure it does if you call it via a macro rather than via VBA, but I've always used a specified location when calling it via VBA. However it looks like you want to split...

I know this was a while ago, but in case anyone else is looking for a way to do this the above worked perfectly.

Based on what you have said, when a loaned item is returned all that has to be done is the record in the booking table being either edited (e.g. a yes/no field which states whether the loan is current) or deleted (but this way there is no historic record of items loaned). I'd guess an...

ok. In order to advise you on the returning process we need to know about the loaning process (e.g. is it a yes/no field in the main table which says if an item is "in" or "out", or is the record moved to another table while "out", etc. Basically we need to know how the data is before the...

As an A2 level student I assume you have some knowledge. You should approach it the same as any other database. But I meant specifically, are you looking for help with the table structure? Perhaps you are asking for advice on the best way to mark a record as out on loan as opposed to...

I don't think it will be the Data Entry property if it's always showing records, it's just the new ones which aren't returned. I still think the subform doesn't know it's supposed to be retuirning those new records. ITGuy - If you open the query / SQL which is set to the recordsource are...

What exactly do you need help with?

No problem. A little bit a trial & error and we got there. Glad it's sorted. :)

Ok, interesting. If it hasn't removed the whitespace at the end then logically it's not at the end. Lets try manually dropping the last character: stName = Left(me.RECORDEE,Len(me.RECORDEE)-1) Keep in mind that once you have something that works, try it using other windows signons. This...

Try using the Trim() function on strName. Ideally I'd like that to fix it but more realistically I'm hoping to see if it removes the trailing space or if there is some other non-printed character which follows it (meaning the space is not really trailing and therefore won't be removed by Trim)...