Search results for query: *

You could export the Outlook Contacts from Outlook (as a text file or such). Then Import the text file into a new table in Access. Then use an append query to take the imported text and copy them to an existing table. This query allows you to map field names if they are different...

If you are trying to Lock the records and then have the ability to unlock them manually with a toggle button, try creating a button and setting its OnClick property to this routine: Private Sub btnLock_Click() SetTextBoxProperties Me End Sub Sub SetTextBoxProperties(frm As Form) Dim...

The problem with that code is that it is made to work only with one form. If you have another form opening like you do to check only, try this code out (I used your field names and form names.) Before you do, you will have to have a primary key in the table (ContactID). Also, I use a macro to...

The command button is a button you create with no wizard actions chosen (hit cancel). Instead you create an event procedure on the "on click" action. Copy and paste the code at the top here and change the field names to match yours. You will have to change the button name to match...

I have a form that is used to lookup a street name in a list of addresses. I have a combo box that just has street names in it and the form results is a list of actual addresses with street number and name. I want the form to show me all of the addresses with the street name that I choose in...

I can't believe it was so easy. Thank you much. Joshua joshuab@musician.org joshuaweb.htmlplanet.com

I am trying to show the appointments for the current week using the datepart() function. Right now it works great, but my client wants the "current week" to be Monday through Sunday. I have a new field in a query calculating the Datepart of the [ApptDate] field...

How do I change the first day of the week to Monday for all calculations in Access? Thanks, Joshman joshuab@musician.org joshuaweb.htmlplanet.com

If you have a field in your table with an OLE Object data type, you can insert Word files as an object in the field. The form based on that table will then see that field as an image and show the file. NOTE: you will have to change the control Size Mode property from Clip to Stretch to see...

Hello xena_morph,<br><br>I am not a programmer so I cannot help you with the particular problem with that code. However, I have accomplished what you are trying to do many times using the Solution.mdb file that comes with Access (97 and back).&nbsp;&nbsp;It has sample code that works great every...

Hello jgarnick<br><br>My first thought, if I understand your dilemma, is to have the query look for &quot;p/*&quot; or &quot;*/p&quot;.&nbsp;&nbsp;But that is only based on your sample data.&nbsp;&nbsp;But this would limit it to just look for &quot;p&quot; by itself on either side of the...

Is there a way to override my content password that I forgot?&nbsp;&nbsp;It won't let me view any site that is not rated (i.e. most of them).<br><br>I have tried reinstalling and that does not work.

How do I check for possible duplicate entries in two different fields (FirstName and LastName)?&nbsp;&nbsp;I don't want to prevent it totally, just check for it and ask if they want to add the entry or go with the existing one.&nbsp;&nbsp;(There are thousands of names, so duplication is...