Search results

Thanks DB_Guy! This was a good article to read - what I was struggling with was the settings for a form that would allow me to either append or update entries (that was my first thought as how to solve the problem from the OP which would have made the desire to delete old data moot). I just was...

Thank you Doc_Man! I'm so close and please excuse my SQL/Access ignorance... I am not receiving an error "Specify the table containing the records you want to delete." (image below) I thought it did - it looks like it does to me...

Thank you for the clarification and the help so far! The SELECT did not return anything...

Hi DBguy, Do you have a suggestion on how to make my entry form update or add to the table? That was actually my first idea but was not able to accomplish it after many frustrating hours of trial and error (lots of errors). Thanks!

Thank you Minty! I Tried the code that you suggested and received the error message pictured below. "You have written a subquery that can return more than one field without using the EXISTS reserved word int he main query's FROM clause. Revise the SELECT statement of the subquery to request...

Hello Access Braintrust, I have a table [Project Costs] which will be regularly updated with the most current information from our accounting files. I have included a Report Date with each entry so that I can tell what is the most up-to-date info. I have been able to create a query that will...

Works great! Nice and simple - Thank you!

Thank you MickJav! This did the trick!!

Hello Again, This group has been super helpful in the past here's hoping for another! I have a form that is used to enter new data - often times there is one piece of data (ProjectID) that is entered into the form 3-6 times in a row before having to enter a different ProjectID. Is there a way...

Hello again Access Wizards, I created some conditional formatting so that my users would be able to see at a glance when some of their project metrics were out of balance or almost depleated. I used the Conditional Formatting tool from the ribbon (seen below) to set it up but it does not work...

Thank you thank you! This worked and no longer receiving the enter parameter msg. The macro is in the On Click event. Thank you again.

It has returned again - any thoughts about what I've done wrong on this one?

Done but still getting the msgbox asking for the Parameter Value when I try to filter based on the ComboBox & Macro. Thanks MajP, any other ideas for me?

It was saved in the filter for the Form. I deleted it (in one of my previous attempts to repair) and it has re-appeared. I'm also not sure if this should be here or not. Any direction is helpful. Thanks!

Hello All, I am trying to filter a split form using a combobox and a macro to apply the filter. When I first wrote the macro and applied and tested it - the filter worked great returning exactly what I asked each time. I saved the db and made a cup of tea and when I came back to my desk I got a...

Pat, thank you for this suggestion. Would I put this in VBA code for each box or somewhere else? Thanks!

Hello Access Masters, I've been using access for almost a month now with some success with the basics but still have much I do not know and have been learning by scouring google and this forum. I have not been able to find an answer to this challenge yet and I'm hoping you all can help. I am...

Thank you all for your suggestions - I have no explanation but without any changes, the error has disappeared...

Thanks MajP. It is already two queries

Thanks for the welcome! I've been reading a lot of posts on AWF that have come up in Google searches and have found it to be very helpful. I've only now had a reason to join so I can post a question (https://www.access-programmers.co.uk/forums/threads/union-query-returning-error.309431/).