Search results

i m using following code but is didnt work... Private Sub Report_Load() Dim rs As Object Dim strSQL As String ' Connect to the database ConnectDB ' Create a recordset object Set rs = CreateObject("ADODB.Recordset") ' Set the SQL query strSQL =...

can i have a report in access based on sql server view that is being open/retrieved bis connection string

can you help with error resolution? because the code was running fine when I had my table in MS Access. recently I shifted them to SQL server over LAN and the same code that was running fine started giving errors. Thanks

yes it take inv date as date and invno as text based on date

inv No is generated using inv date/month

Hi I m using the following VBA to add/update/delete records in the table on my SQL server but getting errors on Records. update....Record update run time error3146 ODBC Call Failed Private Sub Command43_Click() Dim Records As DAO.Recordset Dim Records1 As DAO.Recordset Dim...

Well, your above reply is theoretically correct ... I have been developing applications on Access since 1997. it's a long journey from bound to unbound forms. You are right in saying that I bypass RAD. But this is done to deal with less educated users and slow networks in enterprises. the...

thanks for the input Pat your advice is well taken regarding bound form ...i don't have good experience with them as i keep my tables on the local server in separate access files and the front end distributed to all staff. unbound forms are working fine and fast for me so far. if you have any...

Hello All

thank u for quick reply...i ll try update query...thks

please help me locate issue in following code..... Dim Records As DAO.Recordset Dim Records1 As DAO.Recordset Set Records1 = CurrentDb.OpenRecordset("Select ID, Paid From RentInvoice where ID = " & Me.Text6, dbOpenDynaset, dbAppendOnly) Debug.Print ID, paid With Records1 Records1.Edit...