Recent content by manusri

Hi all, I am stuck with one issue on my access migrated to sql backend. It was suggested that apart from migrating the access tables to the Sql backend I should create a ODBC connection from the access front end to the SQL server (2010). I recently updated the license of the server...

Yes the field Corder is in the table but as a calculated field. After migrating the database to a SQL server the Calculated field gets converted to a Text field. Because my list box is sorted by the value of Corder, I need it to work. This is what i tried. Option Compare Database Private Sub...

hi all, I have completed migration of my Access DB to SQL server with Access as my Front End :( (Department decision). Now i am having an issue with a Calculated field in a key table. I know Calculated fields do not work in SQL and have been trying to find a way to work around this. The...

Hi all, I have a complex Access database with a lot of Subforms and related tables. It is used by atleast 10 people with minimum of 3 users in there at the same time. The database is growing and causing problems. the IT team at my company suggested i migrate the data to SQL backend. Now...

Thanks it worked. No more hiccups so far.:D

So i removed the "options " in the OpenRecordset statment and the error was removed. But, i still seems to save all records as new records instead of updating them... Private Sub Save_Click() Dim db As Database Set db = CurrentDb Dim rs As DAO.Recordset Dim rsC As...

Sorry i did not understand you the first time... Now i see the error- "Invalid Argument" on the line Set rsC = db.OpenRecordset(SQLStrC, dbOpenDyanset) from SQLStrC = "SELECT Count(*) FROM TMFStaffQual" & _ " WHERE TMFStaffQual.SiteId = " & Me.Parent!txtNewSiteId.Value & " AND...

One more thing, if i insert the On Error Resume Next statement now, it again goes back to doing the same old thing... saving every entry and it does not check if the entry is new or update of a previous value. so i believe my "Invalid Argument" is referring to the statements below...

So i did what you asked me to and saved my program. but, now if i hit the save button, there is an error "Invalid Argument" that pops up but, i don't know which argument it is referring to now. can you help me. See code below. Private Sub Save_Click() On Error GoTo cmd_Save_Click_Err...

Hi, so i have this database that has unbound forms and unbound subforms (not my choice but, have to go with it). So i have a subform that has a listbox that pulls out a list of vendors from table1 which is store in subform1. Now this subform: subform 2 records the vendor's license info...

Hi all, I learnt a lot from this thread and decided to implement the change. But, I seem to get a syntax error for it. See below.DoCmd.OpenReport "ReportName", acViewReport, , [Query].[QueryVariable] = '" & [Forms]![Front Page]![VarName] & "'" Help Me Please!!!

The weird part of the issue above is, the update is saved on the table and the fields below the subform but, not on the list box:(

New Issue.... So when i update a record on the subform, and hit the save command button (command 5), it updates my list box at the same time, all my fields(excluding the listbox) on the subform go blank. Finally the message box "the record was updated" shows up then, when i click anywhere on...

This is what i did. I realized the rowsource has already been set. It is a 'Value List' iterated a million times in the code. So i changed the Row source type to 'Value List ' and watched the magic happen. the number of column were 4 with widths 0";1";2";2".Yes 2 columns are bound. It works...

LstAuthors is a List box that is unbound. I changed the rowsource to SELECT Contacts.ContactID, Contacts.Name, Contacts.Role, Contacts.ORole FROM Contacts ORDER BY Contacts.Name; But now i get a new error Run Time error '3061': Too few parameters.Expected 1. and this goes back to the same...