I set up a query to do a basic sort. It uses "or" statements for 3 fields: LastName, Company, ProjDev. I then use a button to instigate the query and search, and set my recordsource=ContactsQuery2 (the query). Works great when there is data in the Query. When the query cannot find...
I am really having a devil of a time finding a FAQ or post that will set a filter on the current record to restrict it to a set of records that match a criteria. I want the user to be able to type in text to basically search or limit the records to that text, ie LastName, Company, or SalesID...
I wrote up some code to pass a filter onto a form that I am opening. Basically I want the user to be able to specify in one or all of three text boxes (LastName, Company, and ProjDev) requirements or a letter to start with from a form (MainPage), and restrict the form they are opening...
I am trying to create an intranet accessible database. I have created the database in Access using forms, but now need to publish them to the web (everyone in the office has Office 2k, but not Access). Other than learning VBScript and creating Data Access Pages from scap, can I use what I have...
I am trying to create an opening form (replacing the switchboard). I want to open a contact form and set it to view only. I will create another button to open the same contact form to allow editing, and another button to set the same form to data entry. The main form is called Main View and the...
I am trying to setup a basic CRM tool to consolidate contact data throughout the company. One problem I have is have Outlook Contacts automatically updated when a contact is changed. The main reason I need to link to Outlook Contacts is so the sales team can sync their Palms. Is there a...
I am trying to setup an new database (I am a novice user) with access, and want to set it up so the customers can import their contacts directly into the access table for contacts. The import Wizard is not very helpful and did not allow me to select which fields in Outlook matched to which...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.