Recent content by micko1

Galaxiom Thanks very much for your reply. Learning a lot about correct way to do things. Still very green when it comes to Access. I have created 2 update queries that run silently as soon as the data base is entered to update the yes/no field. This appears to work fine, is this the best...

Having issues with getting auto update of Yes/No field dependant on todays date. When users open the form the code runs through and checks all entries and updates the records if either of the dates in two separate fields is less than today. The issue I have is when some users are already using...

Pat Thanks heaps for your input and suggestion. I know our IT guys use virtual machine for some users when they VPN in to the server. I will send your sugestion to them and see what they have to say. I created the database in access 2010 as I was sick of having to open multiple excel...

James Thanks for the assistance. Yes the data base is rather large with many tables and relationships. I will talk to our IT people to see if they can apply your fix. Thanks again for taking the time to help. Mick

Not sure where to go with this one. We have offices in other states that need to be able to open our data base. Due to the line speed it is extremely slow linking to our backend. Is it possible to have duplicate backends that can be merged, lets say over night or at the push of a button. Hope...

John Big Booty Thanks very much for the assist. I managed to incorporate your sugestion and it work great. Thanks again Mick

Need help with query. I have a user form that allows users to select multiple controls. One of the controls is called [State]. In some cases there would be a need to select more than one [state]. I have placed another combo box on the form that allows the user to select the second state but not...

Paul Thankyou very much for your assistance. YES that works fine. Not sure if I will ever get all of this. I have only been looking at access for a short time and it is a bit mind boggling. Thanks again for your assistance much appreciated. Mick

Not sure what hapened, thought I posted this last night but can't see it anywhere. So here we go again. I have a sub form who's record source is a query. The query gets all contractors who's renewal date for insurance falls between Date()+7 and Date()+30. There is also a column that is a YES/NO...

Thank you very much for your help. Something so simple when you know how. Thanks again.

Hoping someone can help. I have a query with the following expression. Problem is if the amount ends up Zero Dollars it still shows it as an entry. How can I exclude Zero Dollar entries. Any help would be greatly appreciated.

Not sure how to explain as I don't realy understand, but I will try. I have a subform ( in data sheet view ) that has a control "Team name" this is a combo box where the user selects a Team name. I have a macro that opens a popup form after update. This form allows the user to add team members...

John Thanks heaps for your help. I will give it a go and see if I can fathom it out. Thanks again for your assistance. Mick

Still extreme newbie. I want to be able to assign a macro to a button that allows the user to point to an excel file. Open the excel file and import (append) the data into an existing table. I have made sure that the excel file has the same column headings as the access table. I am able to...

I was going to say a bit confused but thats wrong, I would say a lot confused. I am not sure where to start with programming etc to achieve this. Can you lead me in the right direction. What I need is code etc to look at each record, check the "date rego DUE" column and if it falls within the...