Search results

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("")...

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?

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...

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

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...

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...

Hi I created a form and a subform with the same record source. The reason for that is that I have a tab in a tab, and the only way to get that to work is to create a subform. So my Form has an ID field and mu Subform also has an ID field, which essentially is the same field. Now if I try to save...

Hi, I have got a database with linked tables to SQL Server. I would like to use below string to connect to my tables without DSN. I know the string works as if I make a test using the ADODB.Recordset, it connects and returns the result of my test query. But I use it to connect to tables, I get...

Hi, Is there a way to create a text default value for a control box that is bound to a number field? I have a combo box that is bound to an auto number ID but displays text. Bound column = 1, Number of column = 2, Column width = 0; 4cm I want to use sample text in all my controls (and I know...

How to replicate in VBA exactly what the "Synchronize" button in External Data tab of the ribbon does?

Hi, My application crashes when trying to change the value of a text box in a continuous form. Here is the code: Private Sub cboPoCurrency_AfterUpdate() On Error GoTo ErrHandler Dim rst As Recordset With Me.sbfProductDetails.Form Set rst = .Recordset rst.MoveFirst...

Hi Not double posting but just moving a thread where it should have been started. I have this update query that is triggered by an after update event on a main form. The record being updated are in a continuous subform. It works well except from the last added/modified record. My tables are...

Hi I have this update query that is triggered by an after update event on a main form. The record being updated are in a continuous subform. It works well except from the last added/modified record. If I save and close the form and then open it again it works for all records but if modify or add...

Hi, My data is on Sharepoint. I have a simple Crosstab query that works well unless I choose the option "Cache List Data". In that case I get a Type Mismatch error. Any idea what it could be? TRANSFORM Sum(PivotData.QuoteTotal) AS SumOfQuoteTotal SELECT PivotData.FullName FROM PivotData GROUP...

Hi, There are plenty of documentation on this on the web but nothing that seems to help. I have a LEFT function in a query that does not work on Access RunTime 2010 while it works perfectly fine on Access 2010. Basically, I have a memo field called Notes and in the query I create a new field...

Hi, Is there a way to review / edit the actual SharePoint workflows in SharePoint created by Access Services after a web database has been published?

Hi, I want to create a planning tool that has 36 tasks. Each task displays 10 weeks with a list of names (listbox with checkbox). I want the user to be able to click in these check boxes to select who is performing what task in what week (see the print screen). So, in order to keep a history, I...

How can you stop this prompt? I have checked everywhere on internet and cannot find an answer! I have a Navigation Form in Access 2010. First page has two subforms: Datasheet1 and Chart1. Whenever I click on another tab of the Navigation Form I get the mentioned prompt! (unless I do a control+s...

Ok, I have been programming in VBA for quite a while on Excel. I am pretty new to Access. So I decided to take an existing template in Access 2010 (a web template that I converted to a client one), brought the modifications here and there. Added a bit of VBA and, after some learning, modified...

Hi, I have 3 tables: Employees, Skills and EmployeeSkills. Each employee has a set of 40 skills that are either "not trained", "in training" or "acquired". I want to create a form with employee name and the 40 skills with either combo boxes or check boxes to select one of the three variables...