Search results

Hello I have a form (FormA) that contains a continuous subform (SubformB). When I open or refresh FormA, some VBA code updates the records in SubformB using the following line of code: Set Me.SubformB.Form.Recordset = rs Where rs is a recordset that is populated via a stored procedure in SQL...

Hello all I have an Access 2010 front end to a SQL Server 2008 R2 Express database that has been created and worked on using Windows 7. To distribute the front end to other users in my office I've used the 'Make ACCDE' feature and have then saved the front end on other machines that have the...

Hello I have a form in Access 2010 with a textbox that displays a date. The format is set to 'Medium Date', but the date displays as 'YYYY-MM-DD'. I suspect it is an issue related to the backend, which is in SQL Server. I have a SQL Server stored procedure that populates a recordset in...

Hello I want to switch from an all Access 2003 database to Access 2010 on the front end and SQL Server 2008 on the back end. Before I spend a lot of time on this I'm trying to see if I can get a few simple things to work. I'm trying to execute a stored procedure in SQL Server from Access...

I currently have an Access 2003 database split between a front and back end. When a user wants to edit a particular record, they click a button and the record is copied from the backend table to a temporary table on the front end, which they can edit. And on the backend, one of the fields on...

Hello I have a table that includes the following fields: - TaskCategory - DueDate There are 15 different types of TaskCategory (e.g. Accounts, Payroll, etc) and DueDate may be any date. I want to summarise this information into a grid with: - DueDateBands along the top (e.g. Overdue...

Hello I have a form that contains a tab control. On each tab is a subform whose recordsource is a query. When combo boxes on the main form are updated the query is updated and the subform updates. The problem that I have is that it takes a long time to refresh the subform and I'm sure there...

Hello Any advice on the best approach to take regarding the following issue would be appreciated. I have a table which stores information about the progress of various tasks. There is a record for each task, and a field for each time the progress is updated (Prog1, Prog2, ..., Prog50)...

Hello I'm hoping for some advice about whether I should be using a table or query to hold the underlying data for a form in my database. Any thoughts much appreciated. My database is split between a BE and FE. There is a form in the FE which has a table in the BE as its recordsource. When...

Hello all I'm building an access database that will eventually be used and edited by multiple users at the same time over a LAN. Is there a way that I can test how the database will respond to multiple users using just my own PC, i.e. opening the database twice, as different users and seeing...

Hello I have a tabular form called WorkOutstandingForm, which looks at a query called WorkOutstandingQuery. On the form are two combo boxes (including one called ClientNameCombo) used to filter out certain records from the query. When I select a client from ClientNameCombo, the other combo...