Search results

I tried the suggestion in the bottom link and it fixed the problem! I am not sure exactly why and I am sure that I didn't have the wrong focus. I checked through the Allen Browne list and didn't see any of those suggestions as an issue. Thanks for all the help and suggestions, great to have this...

If MsgBox("Do you wish to delete this record?", vbYesNo, "Delete Confirmation") = vbYes Then If MsgBox("Are you SURE you want to delete this record?" & vbCrLf & _ "This will permanently delete the record.", vbYesNo, "2nd Delete Confirmation") = vbYes Then DoCmd.RunCommand...

Yes, I have the same relationship with cascade update etc enabled

Ah. I can post the SQL of the query. SELECT tblContracts.ID, tblContracts.ContractName, tblContracts.Description, tblContracts.ContractType, tblContracts.Status, tblContracts.ReviewDate, tblContracts.LastReviewDate, tblContracts.ReviewedBy, tblContracts.ReviewOutcome, tblContracts.StatusDate...

I am not sure that I can do that, partially because I never have and partially because it contains company information and partially because it is split into backend and frontend. Should I be deleting information and just posting a thinned down version?

I cannot delete a record from a form or a query. I thought it might be at the query level so I opened the query and attempted from there. It appears to delete fine (asks for confirmation and the record disappears) but if I requery then the record reappears. I can add new records with the query...

Thank you. Always hopeful for a better option but at least I have it working!

I want to understand if I am missing anything. My form is filtered in VBA with setting FilterOn and defining the filter (there are three variables that have to be filtered on - not all of them are present at the time of filtering). I have a list box on the form but to get it to reflect the same...

I set a FilterOn on a form but in some instances this gives me no records (the filter works fine - it is just that in some instances there are no records to return). In this instance the result is that the form moves to a new record. I then check this with RecordCount (RecordCount = 0) and set...

Yes, I tried that and it gave exactly the same issue. Hence the conclusion of a Access and not database problem. Re-install it is!

In a blank database this worked fine. Never used the immediate window before.

Yes, I did. It gives exactly the same error. I am beginning to think I have a corrupted database. I have tried Compact and Repair as well. No difference. Date Add seems to be problematic because I tried it as s default in a table this morning (split database so this was in the BE) and got the...

The grid looks like this

EndDate is the date field I am calculating from

SELECT tblContracts.ContractName, tblContracts.EndDate, tblContracts.EndDateCheck, tblContracts.BusinessUnit, tblContracts.BusinessOwner FROM tblContracts WHERE (((tblContracts.EndDate)=DateAdd("m", 3, Date())) AND ((tblContracts.EndDateCheck)="End Date") AND...

Access won't allow me to get to a SQL view. I can't get the cursor out of that expression. It just tells me invalid syntax

Same result. It highlights the Date() part as in the screenshot above. I have replaced this with hard dates and a variety of other date information and I get the same result every time.

Yes, I know that but my issue is not the dates returned - its that I can't get the filter to work. It tell me Invalid syntax - operand without an operator. I am doing something really dim, I am sure. I just can't see what it is