Search results

Glad you managed to get it to work, just to clarify for future reference though for anyone else reading this. You need put this in a module Public Function IsLoaded(strFormName As String) As Boolean sFormOpen = (SysCmd(acSysCmdGetObjectState, acForm, strFormName) = acObjStateOpen) End...

Try Putting this in a module first then try it. Public Function IsLoaded(strFormName As String) As Boolean sFormOpen = (SysCmd(acSysCmdGetObjectState, acForm, strFormName) = acObjStateOpen) End Function

When I set my form to open using a criteria, (acaddnew for example) I find that whenever I tab out of the first field in the subform it throws focus back to the first field of the first record, regardless of how many records are in subform. The subform is set to Continous and the first field is...

I can only share my own experience on this, be warned I am no expert. I looked a different ways of doing this and finally settled on providing access through asp via a webserver which I set up in the office, to date it has worked very very well and I am very pleased with it. There are benefits...

Fantastic - Thanks very much.

I have seen an example of this on this forum... I am sure it was not a dream...I have searched for 2 hours now, both on here and www but can not find what I want, maybe I am having a bad search day. :confused: A simple listbox with a textbox on it, that moves to the closest matching record in...

Thanks for the response Dave. The problem is not with initiating a print command, I can do this from the form the control resides in. I want to actually print just the contents of the tree control it's self but the control does not have a print property associated with it. I have it in the...

I have just put something together for my wife, a fairly simple db to show and record her family tree. It works very well (so far) for what we need. The actual family tree is viewed using the ms tree control. I know the this component does not support a print property however does anyone know a...

Problem sorted

I am using rst.FindFirst rst.NoMatch rst.FindLast in a procedure and they throwing back "Data/Method not found" is this because I don't have the correct reference? This is the full code Tree Control TIA

I changed it for you but it is just a tiny bit to big to upload. Change the the field ProffessionID in tblStudents from a text box to a combo box then change the row source to SELECT [tblProfession].[ProfessionID], [tblProfession].[Profession] FROM tblProfession; and the Column Count to 2...

Having "Allow Default Shortcut Menus" unchecked in startup will cause this. Just a thought

The company I work for are thinking of applying to become a public bonded (customs) warehouse. Have any of you had any experience in building an inventory system that will confirm to the requirments of UK Customs for the managment of items within a bonded warehouse with Access? I think I am...

Re: User Lock So you said previously Even though Colin had replied with And I now reply with the only word that springs to mind Tool

This is real annoying came in with service pack 2, I am 99% sure there is no way of turning this feature off from with stand alone Outlook, though I belief you can if you are using Exchange Server. Here are 2 very different possible (if not ideal) workarounds...

There is a function here that will do it, it works upto $999,999,999.99 if that is big enough for you :eek:

Probably need to create and use a function as well that will convert the amount into a text string as well for that part of the cheque - 100,000 to one hundred thousand. If you manage to get it working, I would like one - Please make it payable to K Withers and put plenty of zero's in it :D

Dim fLen As Integer, filepath As String filepath = "c:\SomeFile.txt" On Error Resume Next fLen = Len(Dir$(filepath)) If Err Or fLen = 0 Then MsgBox ("The File Does Not Exist") Else MsgBox ("The File Does Exist") End If Is this what you are after?

Leebob I might be wrong but is this where you are getting confused F5 runs your application in VisualBasic/Studio enviroment - it does not in access visual basic though.

The scope of your question is pretty large. I assume that as you are asking you have already created your database, there for there is a great tutorial here that should help with your connection problems and accomplish what you want to do. http://www.w3schools.com/ado/ado_examples.asp As for...