Search results

Hi Thanks for the reply. The Access 2007 button-wizard creates a button with an embedded macro:-. OnError Next, GoToRecord ,,New, [MacroError]<>0 MsgBox =[MacroError].[Description], Yes, None, If I try to use the button, I get the "Can't go to the specified record" comment... all the...

Hi I tried setting the focus to a control but Access still does not scroll to the new record entry row on the form...i.e. the one with (New) in the status column? Code as below Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec me.First_Name_TextBox.Setfocus All this does is move to the...

Hi I want my users to use a custom 'New Record' button. Consequently, I have allowadditions set to false on the form. Note that my form is opened in it's own workspace so that SQL transactions can be used My custom button calls Frm_WrkDAO.BeginTrans DoCmd.GoToRecord , , acNewRec...

Hi GtH I don't have those in this case but I do use them so thanks for the tip... rgds

Thanks... Good Idea! I set the timer to 250 .. seems a bit long I know but it has cut awful lot of the flashing out... I was getting sea sick! :-) Thnx again!

Hi Access2002/2007 WinXPPro SP3 I've a form with a tab control and 4 or 5 tabs. Each tab has a subform on it which is populated as its tab is clicked. This causes quite a lot of screen flicker as scroll bars and the like set themselves up. Just wondered if anyone could advise the best...

You, Sir, are a genius! Thanks ... i'd tried all sorts ... just plugged a USB numeric keypad in and hey presto! I thought Chr$(192) ... would do it? Not to worry it's there now..... rgds

Hi Access 2002/2007 WinXPPro SP3 OK, OK, I give up... how do I get the extended ASCII character 192 as the caption in a label control.... or even displayed in a textbox please... I'm sure I could have cracked the Enigma code with pencil and paper for all the time I've spent on this... :) Thanks

By way of example here is a problem I've just had. In the main-form I delete a record (this is within an SQL transaction)... the Current Event of the mainform fires. In that event I call the following..... If Not Me.Form.Recordset Is Nothing Then If Not Me.Form.Recordset.EOF Then...

Ok .. no probs... thanks for trying anyway.... :)

Ah... sadly I can't use master/child links... The method of opening the form and subforms (as per Msoft's own instructions) precludes them.... hence my use of Call mySubform.Form.Form_Open(0)in the main-form Current Event. I think what happens when Master/Child links are used is that the...

Ah interesting.... I may have been working under a misapprehension... not so surprising given I'm completely self-taught... less a desktop Db system more a PHd :) So, since I can't use Master/Child links, as I scroll thru' my main records, how do you recommend modifying the subforms so that...

Yes, I guess you must be 10 hrs or so ahead of us? It's over the pub for me though! ... untypically... the weather here is fabbo! At the moment it's an .mdb which is NOT split into FrontEnd/BackEnd.. but I will split it sooner or later.. so local tables. Thanks for tryng to help...

Hi Sorry OZ... sometimes such concepts are not easily explained using the written word... Let me expand a little on this. As I understand it, opening a form with an SQL statement in the form's recordsource property will fire up that form using a default DAO recordset and run with it in the...

Hi -thanks for the reply OZ! Yes, there is a fair bit of code for what must be a very common situation. This has been a pain in my side since I discovered Access! There are one or two factors to consider. 1. The RS's are attached to the Forms/Subforms at Form_Open using aseparate...

Hi Access2002/2007 .mdb WinXpPro SP3 I know this is a popular question because I've read quite a lot on it but each time I think I've cracked it yet another failure comes along. I run the following tests in the Current Event of a Main Form (in this case after a filter has been applied) to...

Hi I think I have resolved this thanks... for anyone else out there struggling with this here's what worked for me... Private wrkAddresses As DAO.Workspace Private dbsAddresses As DAO.Database Private rstAddresses As DAO.Recordset Private Sub Form_Open(Cancel As Integer) Dim Extg_DbName...

Hi Apr! Thanks for the reply. Much appreciated. I had a quick look at the suggested solution but I think it's effectively what I am doing already (although I handle the construction of the SQL string in the subform-open event). My problem only seems to occur when the subform is in...

Hi Really sorry to need your help again so soon.... I am utterly befuddled by the syntax and order of actions here!.... I am trying to open a bound form in its own workspace so I can later use Transactions. Every example I've seen has a peice of the puzzle but I just can't quite put it all...

Hi All Access2002/Access2007 WinXPPro SP3 Here's an interesting one. I have an unlinked Main and Subform; Master/Child Links can't be used because they are wrapped in SQL transactions. To replicate those links, the mainForm Current event reloads the subform with a new SQL recordsource (SELECT...