Search results

Well, Scotts suggestion effectively translates the find method to user_id = 'XYZ' and it works Again, the syntax I am using is rs.find "user_id = '" & theuser & "'" where the theuser is XYZ Are you saying then that rs.find "user_id = """ & the user & """" shld also work?

Correct me if I am wrong here: With DAO you would need a string which translates to something like user_id = "XYZ" (1) whereas in ADO you would need user_id = 'XYZ' (2) I was trying (1) and it wasnt working.

Thanks for your inputs Mile and Scott: Scott's suggestion has worked fine so I will stick with it for now. Regards Ashik

I would lik to know how to use find for ADO. I am using the following and it does not seem to be working. rec.find "user_id = """ & theuser &"""" I have seen from some previous posts that it shld be rec.find "user_id = "'" & theuser & "'"" (using ' instead of ") but ' is interpreted to be a...

I have a general quetion about ntwork traffic with reference to ACCESS. If I have a BE/FE split setup with linked Access tables and if an FE opens a recordset ( as in DAO.Recordset or ADODB.Recordset), what is the process that ACCESS follows: Does it first send the whole table over the network...

Thanks for the help! Some things get really deceptive with ACCESS!! :rolleyes:

I keep on getting an error message with the code below. What I am basically trying to do is to save a newly entered record on a form. This works well with DAO but now I am trying to convert all my code to ADO for future migration to SQL. The error # is errror 2501 which says something to the...

Is there any way of delting all data in a table through VBA instead of going to each record in the record set and deleting records individually. Would save me a lot of time if I could do this. Will apreciate your help for the above. Thanks.

I am trying to open a report with a "WHERE" condition. The data soirce for the report is a query. The report does open but it is blank although there should be information on it. I am using the following statement. DoCmd.OpenReport "rpt_for_rep_orders", acViewPreview, , "order_date = " &...

I would like to know if there is a way to search for a record in a recordset which finds a record on multiple criteria. Foe example I have the following code. rec.FindFirst "[acct_num] = """ & acct_num_str & """" I also want it to search on "[IPO_name] = """ & IPO_name_str & """" so that the...

I get error 3251 (Operation is not supported by this type of Object) when on the following part of the code. rec.FindFirst "[acct_num] = """ & acct_str & """" The full version of the code is as follows: Private Sub acct_num_AfterUpdate() Dim rec As DAO.Recordset Dim db As Database Set db =...

I am having problems editing info from a specific field on a form. The basic outlay of the structure is as follows: There are two tables linked by a field called IPO_name. (say Table1 is the primary table and Table2 is the linked table). Referential integrity has been set along with cascaded...

I am trying to use a combo box to display records. I have two questions regarding this: 1. If a certain bound field is linked to the combo box, if a certain item is selected from the combo box (which is a keyed item), can it display the relevant record without using any VB code? 2. If I...

Thank you for your reply. Appreciate the input.

Thank you very much.

I would like to know what I am doing wrong here. I have a form with fields from related tables. One of the fields is named IPO_name. In the table which has the IPO_name field, its properties are set to say that a zero length field shld not be allowed for this field. Now when the button is...

Hello folks! I have been breaking my head on this problem and after three days of agony (and a broken head!) I have decided to ask the forum. I have two tables related by a field called "IPO". The database is meant to track the inventory of the "IPO". When a part of an "IPO" inventory is...

Thanks Pat! That worked very well! :)

I tried the iif statement you gave me bu it still does not work: =IIf([Remark2_Date] = #1/1/2001#, Null, Format([Remark2_Date], "dd/mm/yyyy")). When I put in the date as 01/01/2001 and then go back to check the field, it should be null. But it continues to show 1/1/2001. This is being placed...

I always get bogged down with the date functions in Access. I have a table with a field called Remark2_Date (a Date/Time field) which is bound to a field on the form. Now when there is a change to this field the entry should be updated to null if the date is 1/1/2001. For the change event for...