Search results for query: *

I have been able to add contacts from access to outlook, however when I use the save event it doesn't replace the previous contact. The code used is below. Does anyone know how to update or overwrite contacts rather than duplicate? WITH oContact .FullName = [] .CompanyName = []...

You can all stop worrying. I just worked out its the syntax in my statement LIKE '*' & Form!frmRealSearch![txtFindDivision] & '*' forgot the "S" on FORM! what a muppet.

Hey, I have a form based on a dynamic parameter query. The problem is I am still getting those anoying parameter popups when I open the form. The code im using in the query is like this, LIKE '*' & Form!frmRealSearch![txtFindDivision] & '*' If I click ok on the the parameter popup it works...

Cheers, Thanks everyone for your help. I have got the recordset working by returning one record and then using the movenext moveprevious. That will do pig, that will do.

Cool. That seems like one possiblity. But I really would prefer it display in seperate text fields as there is quite a few fields. Maybe there is another way of doing this. I have now got a recordset returns a number of records then moves to the first record and display it in one set of...

Just display them in a form. So if there are 6 records returned the form displays 6 rows of data. If theres only 2 records then it just show 2. Does this help???

Thanks for your help. But Im really trying to use an SQL DAO recordset not a query. Otherwise it wouldn't be a problem.

Well, I am a bit new to using recordsets in access. At the moment a have a form that produces a recordset using SQL. PROBLEM: if 4 records are returned. How do I display them on the form. I thought of making 4 groups of fields and then looping through the recordset and putting the values to...

Thanks for that thats helpful. I don't really want to edit the data though. I just want to display all the results on my form. At the moment it only shows one row. So the idea is to loop through the record set and put the values into fields on the screeen.(ie...

I am having problems evaluating a varible and field for input. Seems simple in other languages like Java etc. I want to loop through a record set and assign the values to different fields. (i.e. ID1,ID2,ID3,ID4 etc) Code below i=1 Do While Not rs.EOF Eval ("Me.ID" & i & " =...

When tying to import my access file into outlook it prompts for Login Name and Password but will not accept them. Says "Do not have permissions" It works fine if I secure my database with just a single database password. But we really need fully workgroup secured database. I know the...

Awesome. What a relief. It works perfecto. Cheers mate

Barry, What I meant is I would like the recordset to be of any SQL statement (i.e. An Inner Join of multiple tables) not just one table. The code I have used is Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Contacts&quot...

Thanks alot Bob. Thats a great start. How would I use SQL to create a recordset rather than just a single table. Cheers

I would just like to create a recordset that I can search and manipulate data via SQL for a local Access Database. I have tried creating a recordset on the form load event. I want the fields to then be loaded into the form text boxes. I have look at FAQ, FORUMS etc but can only find DNS ADO...

The Closing/re opening form worked. I just cant get it to open to the right tab. The refresh interval made no difference with the form open.

Cool, that works, yippy. But the original form has 4 tabs. Is there a property I can set to open to the right tab? If not thanks heaps for ur help anyway.

Thanks for your help but it doesn't seem to update using the docmd.openform from the popup. any other ideas. Can I refresh a form from another form. I tried FrmCompanyAdvertising.Requery FrmCompanyAdvertising.Refresh putting this code in the save button on the popup form but it says object...

Well Fule, I have a form that contains records for companies. I also have a command button on this form to add a new company. When pushed this pops up and the user can fill it in and save the record, close the form. I have got the refresh to work now on a button event on the original form...

I have had a similar problem with refreshing but i cant seem to make your solution work. I am adding a new record in a seperate popup form and then returning to the main form. I have done a onfocus Me.Refresh (doesn't work) Also tried a button (doesn't work) Can anyone help me solve this. thanks