Search results

Hi I have managed to create a simple bit of code that allows a picture to be edited, kind of, basically i have a main form and a subform. The subform has an image of a body. Each time the user clicks the picture on the subform copy is made of the subform and a bitmap of a red dot is added to...

Hi Never really thought about this so i tried it on one of my forms and the arrow keys seemed to work fine. Sorry can't be any more help Chris

Hi found this worked like a charm took <1min follow the hyperlink in Pats reply Chris http://www.access-programmers.co.uk/forums/showthread.php?]here

Hi Stick it in a module and call it as a function in your sub ErrorPrint err.description Public Function ErrorPrint(Msg As String) Dim nfile As Integer nfile = FreeFile Open "C:\Errorlog.txt" For Append Shared As #nfile Print #nfile, Now() & " - " & Msg Close #nfile End Function Chris

Hi Left Click on the part of the tab showing its name, it should highlight with a box, go to the menu bar and select the subform object , bring the cursor over the tab page. It should go black, left mouse down in the balck area and drag the subform object onto the page. This should activate the...

Hi Tab pages have their good points and their not so good point. Their good points are they are great space savers. The not so good point is they hide information. This is problematic for people like me with bad memories who can't remember what they selected on the first/previous page and it...

To that i can only speculate. Chris

That's ok glad to help. PS its CJ, i don't want anyone getting the wrong ideas !!! Chris

Hello Go to the open event of the form. In form properties uner event choose code builder make sure you have the dao 3.51 (access97) or dao3.6(access 2000) object libraries (on the menu bar in the code window select tools then references) paste this code into the form open when the form...

Hi If you really want to do this create a small txt box set its tab val to 0 and hide it on your form. When the form opens the cursor will go to this box. When i mean hide it i don't think you can set the focus to an invisible object so stick it under another box. Chris

Hi Yes this is something i do to trap errors in general. Here is an example sub place this on a button. When you click the cancel option on the input box it passes a null to the variable which generates an error. This is passed to the function which generates the msgbox. As you will see the...

cheers sean

Hello Slightly of the beaten track i know,but, can anyone tell me if Palm tops can view webpages as normal? Thanks Chris

Hello Thanks Autoeng lots to read here.....! Chris

Hello Apologies for this, i've searched the posts but can't understand this particular situation. I've just taken up a new job and there is a database that has been secured using a workgroup/security system. I have the password for the administrator. If i try to open Access on one PC it...

Hello I'm leaving my job this afternoon for pastures new and i really need to know this before i go. Is it possible to create an object of a database in the current database and then get it to run any of the following; 1) a macro 2) code in a module 3) a query I have 2 databases, the first...

In answer to my own question: Private Sub CMD_PROJECTION_RPT_Click() Dim WAITCOUNT As Integer Dim DB As DAO.Database Dim RST As DAO.Recordset Dim PROCESSEDDATE As Date Set DB = CurrentDb() Set RST = DB.OpenRecordset("LWVDATATABLE") PROCESSEDDATE = RST![ProcessDates] WAITCOUNT = 0 Do Until...

Hello I have a report with a dynamic recordsource that is created from selections made on a form. For efficiencies sake I want to open mulitple instances of the same report using a loop. Each report has a different set of parameters for the recordsource query. The reports need to be...

fixed it. The path was incorrect i had left of .xls ! doh! thanks chris

Yes unfortunatley i am information but i spend most of my time writtings db's and apps for the others this one's got me stumped. i tried the help but i couldn't get any of that to work either as i tried creating and attachments object but it bombed out there as well. Oh well back to the drawing...