Search results

The solution is to use Native Client. Solution cross-posted here: http://www.utteraccess.com/forum/index.php?showtopic=2037903&st=20

Hi I have a connection issue. My Ms Access 2010 database is made of linked table to SQL Azure. I have tested the connection string with the following code and it works well: Dim qdf As DAO.QueryDef, rst As DAO.Recordset Dim strResults As String Set qdf = CurrentDb.CreateQueryDef("")...

Cross post with answer: http://www.utteraccess.com/forum/index.php?showtopic=2036611&st=0&gopid=2594651&#entry2594651

Just a quick question. If you have a Ms Access front end with a DSN-less connection to a Ms SQL server database (2008). What would the implications or would there be any implications for the Ms Access front end if we activate data encryption in the SQL server database?

I see. I will have a look. thank you.

Here is the entire SQL for the view. Access connects to that view directly: SELECT DISTINCT dbo.tblPersonal.NbEmployee, dbo.tblPersonal.LegalName, dbo.tblPersonal.FullName, dbo.tblPersonal.StartDate, tblPersonal_1.LocationID...

Hi, I use an SQL view as my Form source. The form opens correctly, however I get an error message when running the report as a subreport (no master / child link): "Conversion failed when when converting the nvarchar value "[FullAddress]" to data type int. (#245)" Here is the function behind...

Ok you might be right... I made some changes to that query and it runs faster. However, it still doesn't explain why when the code was called from the VB editor it ran faster.

I have drilled a bit further. The area that is hanging is when executing the update query "qryUpRenormalize". When I trigger the code from the VBA editor, it takes about 3 sec, when clicking the button in the Form it takes 45 sec.

Here you are... Private Sub cmdSave_Click() On Error GoTo ErrHandler Application.Echo False Call NormalizeIt LoadCrosstabForm blnDataChangedInSubForm = False Me.cmdSave.Enabled = blnDataChangedInSubForm ExitSub: Application.Echo True Exit Sub ErrHandler: Call...

Hi I have a sub that is in a standard module. It is triggered by a button placed in a form. If I click on the button, the procedure takes a very long time but if I go into the VBA editor, run the sub while the form is open, it does the trick in no time at all. So I am at loss. Please help! Thank you

I see what you mean but in this case it seems necessary. Here is how it looks: There is an item which is the source of the main form. Then there is a subform (continuous form) with a Master/Child link with a bunch of sub-items. Then there are two other subforms (continuous forms) with parameters...

Hi, I am trying to create a versioning function in Ms Access. That means that I have a bunch of related data that I would like to duplicate with a new version number, also the child records should be duplicated and linked to the newly duplicated items. I can't get my head around what the best...

Thank you The_Doc_Man

...Alright... the only way I found was to change the source object of my subform to "" before deleting. Not sure what it indicates though.

This is an old post but nothing I do seems to work. :banghead: I have a form with a number of subforms. One of these subforms has other subforms. The backend of my Ms Access application is SQL server 2008. When I use the command button on my form to delete the current record I get the write...

How would you do that since there is no record source?

Hi, Is that at all possible? I thought it would be a good idea if I have a form with a lot of data structured in tabs. Since the tab loads all the data at once while the navigation form browses to the desired form. I have tried but the issue is the Master-Child link. The form in the navigation...

Because, as explained it is a tab in another tab. So try to do that without using a subform. If you find a way please do let me know.

Ok... To get it to work, I changed the Master-Child link: Now, Link Child Field is the field ID and Link Master Field is the control txtID. No duplicate value issue anymore, however now it creates an extra empty record when using the form to add data. Should I get rid of it manually or is there...