Search results for query: *

Is there a way (or addin) where we can take our existing Access DB linked through ODBC to SQL by using OLE DB with limited programming and query changes? And, the users need to see the linked tables - like they do with the ODBC connection.

Can you connect and MDB file to SQL using OLE DB? If so, any code examples?

Access 2000 Front end, SQL 2000 Back end, linked tables Situation: User1 opens a record, another User2 opens same record. User1 may or may not have made changes before User 2 opens it. User2 makes a change, saves record. User1 makes a change and we obviously have a problem. Error: The...

code for after update of Question 2 If Question2 = True Then Question3.SetFocus Else Question5.SetFocus End if

Check the properties on the fields in your table an ensure allow zero length on appropriate fields is set to yes.

I need to import flat double-byte characters files(Japanese) into Access and export them back out as DBCS. 1) is this possible? 2) if so, will I need any translation packages? Thanks much

Hello - I am looking for direction/resources to help me develop a database which translate english into Arabic script and Cyrillic script. I need an end result of showing a form with an English phrase and also Arabic and Cyrillic in the appropriate script. Any ideas? Thank you

Help please -- must be simple. Upsized an Access 97 database to SQL 7 - all seems OK (so far) except when we add or update a record in a FORM, it locks the record - and I cannot get it unlocked. When I add a record directly through enterprise manager, it also locks. When I update the record...

1) There is quite of bit of code behind the forms - (at least continuous forms are causing the problem) But no ADO or DAO 2) I am getting the error - ..."you and another user are attempting to edit the data at the same time" - #3197 - stating the table is optimistically locked 3) I...

Help please -- must be simple. Upsized an Access 97 database to SQL 7 - all seems OK (so far) except when we add or update a record in a FORM, it locks the record - and I cannot get it unlocked. When I add a record directly through enterprise manager, it also locks. When I update the record...

After update of a record in the subform, set the sum field in them main form to be contents of the summed text box.

Thank you! That's what I suspected.

"SELECT * FROM adview WHERE 1=1 AND memid=11219 ORDER BY ADID, positiontitle" Can someone tell me what the WHERE 1=1 is doing? Of course no field named 1. Thanks

Just pushing this to the top because I am desperate! Thanks

Are you binding the subreport by this unbound control or a bound control? The child field of the subreport control must be same value of the master field (thus bound).

Access 2000, split database. A new one to me -- multi user setting, and the error somtimes occurs: -- DB placed in state by user xxx which prevents it from being opened or locked-- It occurs when the passive shutdown control is invoked -- intended to force users from not entering when admin...

Did you try the code on the Before Update event of the form?

On the after update event of the combo box requery

I would create a custom function like: Function GroupPrice(FeedPrice As Currency) As String Select Case Price Case 0 To 49.99 GroupPrice = "0 to 49.99" Case 50 To 99.99 GroupPrice = "50 to 99.99" Case 100 To 149.99 GroupPrice = "100...

Use the above statement as the control source of a text box in your report