Search results for query: *

I asked a similiar question. The answer I received was to have the Exchange manager change my permissions in the Exchange Security Manager. My exchange guy gave me a funny look, and said "I'll have to talk to the big boss about that" and of course, it won't be done. So I am anxious...

Thanks, that did it.

How do you hide the database window?

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

That is a possibility. My understanding is that it is hard to run multiple users on a database, but that using DAPs and an intranet it will work. Any help would be great!

This is a very powerful (free) tool. If you like the way your form is laid out, it will copy it over to a Data Access Page. You then have to rewrite your code for buttons, actions, etc, into VBScript. But still, it will save a lot of time

Not exactly what I am trying to do. I want to make this very user friendly. The users who are working with the forms will have no concept of Access, in fact a right click might be stretching it. I need buttons, and buttons that would not normally appear in access, as I will be disabling most...

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

No, I still get the same problem. I then moved the Open Command to the end, and added the StrFilter to the command like this. I now get a type mismatch message. I thought it might be the lookupfield versus a text with ProjectDev, but I commended it out, and I still get a type mismatch...

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

Wow, that looks powerfull. I will check it out this evening. Thanks.

How about if I wanted to restrict the records viewable in the Data Access Page to a certain field, ie CompanyName.

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 still working on this process, but if anyone else is interested the Contacts sample database from MS Access, has scipt within it to download the contacts from Outlook. I haven't tried it yet, but it shows you how to link the field so you can populate the existing table directly from Outlook.

I apologize for the use of a name you don't have (to my knowledge). At one time I was responding to two posts in rapid succession, and both you and the responder to my other posts, handle started with S, and the other poster signed it Sharon, my brain did not do the switch. My apologies, and...

Hey, I figured it out, just a little syntax problem. Here is the correct scripting Forms!Contacts.AllowEdits = False Forms!Contacts.AllowAdditions = False Forms!Contacts.AllowDeletions = False The same would work for Data Entry by doing: Forms!Contacts.DataEntry = True I...

I am getting errors using the code. Here is what I have: The Main Form is MainPage and the form I want to call (and specify the controls for) is Contacts. The control button is MainViewContacts. Private Sub MainViewContacts_Click() On Error GoTo Err_MainViewContacts_Click Dim stDocName...

Do I set this up in the onclick procedure, or from where do I call this?

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