Search results

Just to add some more information: I'm beginning to think that this is not possible with ADO as whatever I try (e.g. 'Set Me.Report.Recordsource = rst.Source', etc, etc), I get an error message. Strangely enough, it works if you use DAO and then 'Me.Report.RecordSource = strSQL'. I think...

Access 2003 ADP, with unbound controls and stored procedures on SQL Server. I'm getting various errors trying to open a report an setting it's recordset property. The error occurs when I use 'Set Me.Report.Recordset = rst'. I've tried various different variations of this line (recordsource...

Yes, I realized that after I'd posted it. I'm intrigued by this. Do you know where I could find further details?

Thanks for the tips. Sounds a bit of a pain doing it that way, but needs must I guess... I'm using unbound forms partly as a learning experience and partly because I might implement this approach in certain projects at work in the future.

Doh!! Of course, the form's disconnected form it's data source..... I'll need to check if there's and ADO equivalent of the 'Dirty' property. Thanks for the reply.

Using Access 2003 ADP with unbound forms, linked to SQL server database. I've got the code below in the click event of a button and it raises the error 'runtime error 2455 "you entered an expression that has an invalid reference to the property Dirty'. I've used the Dirty property in this way...

Hello All, The title of the thread should be pretty self-explanatory. I have an Access 2003 ADP project with unbound forms. I need to bind the stored procedure to my form, using ADO, which I'm really not familiar with (much better with DAO). I already have several examples of bound forms in...

Thanks for that Dan. I have implemented the constraints both you and George suggested in your posts.

Because I'd rather give the user a nice friendly message before they get round to doing an update.

You could use the Ondirty event of the form and prompt the user for action if me.dirty =true then if msgbox("Save the changes?",vbyesno)=vbyes then DoCmd.Close acForm, me.name else me.undo me.close end if end if Or...

Thanks Dan. I'll implement as soon as I get the chance and see what happens.

Yes, I know the old 'if it can be derived, don't store it' rule. The data is going to a user who's going to be doing some analysis of the breakdown.

Thanks very much for the reply.

Would I? 'lets suppose intpain = 65 If intpain >= 64 Then rst.Edit rst!ap64 = 1 rst.Update intpain = intpain - 64 'so intpain = 65 - 64 so the next bit of code to fire is: If intpain >= 1 Then rst.Edit rst!ap1 = 1 rst.Update intpain = intpain - 1...

Thanks to both of you for your replies, which got me thinking. Sorry if I didn't explain myself very well. Anyway, I came up with a solution which I think works well. <Edit> I created 7 new variables in the relevant table called ap1, ap2, ab4, ap8...ap64.</edit> Suppose the first value in my...

On a paper form, people are presented with 7 options, 1, 2, 4, 8, 16, 32, 64 (it doesn't what these numbers correspond to). They can select any or all of these options. However, what is recorded in the database is a single number. If the person selected 1 and 4 and 16, the number is (1+4+16=)...

Hello All, I need to check data before an insert for obvious reasons! I've set up a stored procedure in my db which is the following: Create Procedure SPChkRefno @refno nvarchar(5) AS SELECT count(refno) AS RefCount FROM tblscreening WHERE refno = @refno I have then written the...

Thanks for all your efforts mate. I'm trying to upload a complete version but the file sizes are too large. Anything I can do about this?

OK. I've attached the form itself if you want to take a look. Thanks again.

I don't think so mate. They can't click on the button at the wrong time as the button is only enabled after they've done one or two other things. So when they click it, it can only be the 'right time', so to speak. I'm not sure it can be moving to a new record either, unless the form magically...