Search results

OK! thanks Re allenbrowne.com nice to see that it is back up.

I a I applied your change which produced this error.

No I just need to be able to display all values of [Activity ID] in table [Activity Type] even though there are Null values in the table of [ActivityRange]. Would your suggestion achieve this?

Hi, (moved this from where I incorrectly posted.) I have what seems to be an eternal problem with crosstab queries and null values. Here is my simple crosstab query. The data is one month of activity giving total hours and distance in any given month. Here is my query...

Oh! thanks for that, we were both responding at the same time 'snap'.

I had a eureka moment. created a new query just for the range table. The output of the table is correct. BUT I need it to be the output of a crosstab query, so stand by for further updates,

G'day all, I have stitched together code "borrowed" from the net. My little database has been running well for me with thanks to assistance from people on this forum and a lot of searching. I produce reports in pdf which has the data that is required, but it is required in an excel spreadsheet...

Pat, thank you for your reply. I re-read my description how I fixed my problem, it was maybe not very well written but I actually notify the user that this would create a duplicate record then clear the record before changing focus back to the first field.

Micron, Thank you for your reply. As all fields in my test are tested for the correct values and can not be empty which they were not, and the field that was giving the error is numeric and is never zero or null why was it necessary to make the change? Doing so fixed the error! Is this...

Thanks for your response, I don't understand what these changes do to the logic of the code particularly why -1 in place of 0 for & Nz(Activity, -1) ?

I implemented this change in the "Before Update" event which fixed that error but the other error I was getting (which I didn't mention) ("You can't go to the specified record.") was still being produced Moving the code actually fixed both errors and also the warning message, about duplicate...

oops I typed without checking I will see if that change makes a difference (for my further education ). But thank you for the edit and correction you gave me earlier.

Gentlemen thank you for your assistance and direction on this problem. I implemented the changes cheekybuddha gave me. The further problem that that created and another error I was getting have disappeared by moving the code to "On Got Focus" event of the "Hours" field. The duplicate record...

I used your code and it worked ok except when I close the form (even after a correct entry) I get the following error msg. Should I put quotes around the Activity field?

The data that produced the error is shown in the snip of the form which is a duplicate of entryID 591. ("BeforeUpdate event). I need to get a warning that the user is about to enter a duplicate record.

Hmm when I closed the form to design view I get the duplicates error message I re-enabled the "Before Update" procedure also used a different duplicate record entry "dummy" is the text in the "Note" field Here is the error message. Is the code correct to obtain the result I am trying to...

Umm! the "nul" in the error message comes from the field "Note" MY bad I should have used a different string to test. I changed the Primary key as you suggested also I disabled the "BeforeUpdate" event I now get the following error "You can't go to the specified record." I expected the standard...

Hi, I am having problems with a data entry form. I am trying to prevent duplicate entries in a table the criteria has to be unique over 4 fields. Namely "BookNumber", "Date of Activity", "Activity", "Notes" these are the only fields I can combine to form a unique record index. I have an index of...

Mick that fixed the problem thank you!

Yes that's where I put it.