Search results

Hi Bob The problem appears to be due to having two subforms with the same recordset. If I have a different recordset for each subform, then it works as intended. So I now have Set Me.SubformB.Form.Recordset = rs1 Set Me.SubformC.Form.Recordset = rs2 And just make sure that rs1 and rs2...

Hi Bob I’m using a union query to generate a recordset for my subform, but I don’t need or want it to be updateable. The recordset just populates the form with a snapshot and there is no constant link between my Access front end and SQL Server backend. All I need is to be able to click on a...

Hi Bob The recordset that the subform uses is the union of two SQL Server tables, each of which includes an identify field. Would that be a problem? It’s been setup like that for a while and has worked okay up until recently. Something that I perhaps should have mentioned originally, is that...

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

Thank you Galaxiom and RainLover. I have a laptop with Windows 7 and a spare PC with Windows XP. I'm pretty sure my Access 2010 license allows me to install a copy on each machine, so I'll go ahead and install a copy on the spare PC. But sounds like I'm going to have a problem if I switch to...

For online tutorials, I find Lynda.com to be very useful. There is a course called "Up and Running with VBA in Access", which might suit you, though I've not watched this particular course myself. I used 'Access VBA Programming for Dummies' when I started to learn VBA for Access 2003. I assume...

Thanks Pat I've got 64-bit Windows 7, but I'm using 32-bit Access 2010. The actual version listed in the help section is 14.0.6129.5000 (32-bit). Any other suggestions? Thanks Speedball

Hello AccessMSSQL Yes, it's Windows 7 Professional 64 bit Thanks Speedball

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 Charlottew14 You may have now figured these out already, but just to answer your specific questions: "on the Login code, where does it say that if the UserAccess is this, then open this form, if it is that, open that form?" The frmUserLogin form is used purely to identify who the user...

Here's how I do it in my database. 1. Have a frmUserLogin form that opens when the database is first opened. Achieve this with File/Options/Current Database/Display Form: 2. Make sure that the form properties of frmUserLogin as set to 'Modal' to prevent the user from bypassing it when they...

What version of Access are you using? Access 2003 has additional security settings that you can make use off for allowing access to different forms. Access 2010 doesn't have this but you should still be able to achieve the same end result using a different approach. I think that 2007 is 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...

Thanks for the detailed response. I'll need to do some more reading up on this and will then return to your response once I have a better understanding of the fundamentals. Thanks Speedball

Thanks Michael I've a had a look at the code from the threads that you referenced and will try to incorporate into my code. One question. Your code includes references to the following: .ActiveConnection = ObjBEDBConnection.getADODBConnectionObj() .CommandText =...

Okay, thanks for your help and the point about SQLNCLI10 not being included on Windows XP systems. Thanks Speedball

Thanks Galaxiom I did some more searching on the internet before your reply and found that I can include Trusted_Connection = Yes in place of the User ID and Password. So I now have the following, which works: cnn.ConnectionString = "Provider=SQLOLEDB;Data...

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

SQL_Hell: Thanks for the advice and for sending through the link. I'll look into this further. I've also reached the part on Stored Procedures in my SQL Server tutorial (from Lynda.com), so your suggestion on that is starting to make a bit more sense. Thanks. Shado: Thanks for posting...

Thanks SQL_Hell I don't know how to get the values from a table into the controls of an unbound form Suppose I have the following: - a table on the backend called StockList where I want to edit a field called UnitPrice on one of the records - an unbound form on the frontend called...