Search results

Hi All, I am getting a Write Conflict message after updating a field using docmd.runcommand accmdSaveRecord which because of Enforced Referential integrity is updating an equivalent field in another table. I am not sure why this is happening as I am the only user..however... The 3 choices I...

Hi All, I have some excel VBA code that I am converting to run in Access (as I have done successfully before) as below. This one however runs until it gets to the last line and stops....It selects and copies but will not past where I want it. Can any one tell me what I need to change on that...

Hi All, I am trying to get a Command Button to become enabled only when a form reaches its last record...I have played around with the following however do not know what to use in place of (lastrecord). Private Sub Form_Current() If (lastrecord) Then Forms![frmActionUpdate]![NEXT].Enabled =...

I have done this in the past by doing the following... Save the Code that you want to run as a public sub in Modules. Then create a Public function in modules that calls this Sub...I then created Macro that simply uses RunCode command and named the public function...This Macro can then be used...

I found a simple solution: Dim i As Variant, Coll As New Collection For Each i In MyListBox.ItemsSelected Coll.Add i Next ...Code to Open Form in design mode and change Form properties etc... then reopen.... Then put this code at the end For Each i In Coll...

Hi All, I have a form with a List Box, Multi Select. After a Selection has been made, which could be one or all of a list of a couple of hundred. I want to be able to maintain this selection when the form is closed and re-opened straight away. The form needs to close down to change a setting...

This is fantastic...I had got it working however i still had some issues....I think doing it this way will resolve them for me. Thanks for your help. IC

Thanks for that....I gave this a go however the command RetVal = Shell("C:\program files\microsoft office\office\templates\mytemplate doesn't seem to work for a .DOT file only for Winword .Exe. IC

Hi All. Below is a command which will open up word from some Code that I have in a form. I would like a saved word macro to run when opening. Is there anything I can add to this command to run the Macro straight away? RetVal = Shell("C:\program files\microsoft office\office\winword.exe", 1)...

Thanks guys...I will give this a go... I Curry...

Hi There, Here is some code that I have written to change the caption on a series of Labels in the Header of a report which needs to be done each month with new data load. The only way I have been able to get it to work is to list each label Dollar12 to Dollar1 individually as you can see...

On No Data Error If you're opening the report from code behind a form, you need to handle the error that's generated as a result of the following code. Private Sub Report_NoData(Cancel As Integer) MsgBox "No Data" Cancel = True End Sub Add the following Error handler; Private Sub...

Hi There, When a report with at least two levels of grouping, is analyzed with MSExcel, the various levels are spread across the worksheet with their own column headers. In the Access Report all text Boxes are lined up neatly however once in Excel they are spread out to the right. Is there...