Search results

This was the final outcome. And as text for anyone. Performance: Sum(IIf([Written Business]![Solution-Date_of_Sale] Between [From] And [To] And Nz([Written Business]![Solution Area]=[Solution-Area-Target],"*") And Nz([Written Business]![Product Category]=[Product-Category-Target],"*") And...

Okay people i have managed to figure it out on my own it was just as simple as setting the criteria for the NZ([Expression],"*"). I hope this helps someone else in the future.

Hi All, I have a bit of a headache in trying to figure out what i need to do with this query to get the outcome that i want so i hope you lot can help me out. I have a query for where i am using the expression builder to set my iif criteria, The expression builder will be referencing another...

Thank you for the reply, i figured i would need to do something like that Thank you for this i believe this is something that i am looking for. I will study this now and try and get it working in my scenario. Many Thanks

Hello All, I am at a loss on this one and i just need someone to point me in the right direction and i apologise if there is a thread for this somewhere I'm just not sure of the right function i should be looking for to do what i want. I have a Navigation Form which has several tabs which have...

Hit nail on head with that one thanks

Yes that's all I am after

The idea for the function is not for the main use of the system. I have a form that displays an attachment image which would be things like offers an promotions to keep the members informed of whats going on. I am using traditional wizard commands to navigate through the different promotions...

Am just thinking on an idea to help streamline a part of our system so it's more user friendly. Do you have any idea on what the vba would have to be like in order to do this?

Is it possible when using the go to next record wizard to program it up when it reaches the end record I.e a null record that it resets itself and starts over again so it's on a loop?

Great that works but i ran into a snag which am now not sure what's best way to handle it. I may need to have a think on the best way to deal with this new problem. Long story short, when the duplicate function kicks in an creates a new record there is a set field which looks at what has been...

I have tried your suggestion Bastanu but it only creates 1 duplicate record regardless of the quantity i input. Any other suggestions?

Hello i wonder if someone can help me as i cant seem to find an answer any where to what i need. I have a form where a user can input data into it. I have a duplicate record function for where the user can duplicate the record as many time as they want, however when they are wanting to...

Yes the table has a Primary Key field, I am just struggling to see how an Append Query will work in this situation that i am trying to do. Is there some code i can use to run the APPEND Query from VBA? Sorry but when it comes to VBA & APPEND Queries am learning as i go along.

Okay very interesting here when i set the focus i get a new problem. I get the following; Run-time error '2226': The Clipboard isn't responding, so Access Database can't paste the Clipboard's contents. Any ideas?

I have not really dabbled in append queries but the reason for the copy and paste function is i need to duplicate the record and then change some fields after the duplication. This needs to be as easy as a 1 click function for ease of use as the people who will be using the system will not be...

I like your thinking and think you may be correct with why this is happening. In that case if i set the focus of the form in question when running this code in theory it might work? Do you know how i would set the focus to try this?

Hi All I hope you can help me with a problem that i have struggled with for the past few weeks. I have searched the web and all i can find is people talking about corruption and nothing that helps my situation. I have an access database running in office 365 that has been split into two ends...

Hi the issue i have is the data goes back for years and its always been check boxes, i need to try and get this to work without changing the table as it will effect a load of reports

Hi People, i hope you can help me out. I got an issue where i want to write some logic in vba where a user is unable to save the form that they are on until a set criteria is met. On my form i have a bunch of tick boxes which a user can select. When completing the form the user needs to click...