Search results

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...

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...

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...

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...

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...

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...

Extreme Newby, This is my first attempt at building an access database. I have done some work in excel and now need to migrate my stuff to access. In excel I had a data base of vehicles and registration dates. The spreadsheet on open would check todays date against the date rego due field and if...