Search results

Whaou! This is indeed a lot of text boxes!!! :D And for me the form is not too long to load if you consider all the operations that are done...! For the rest I fully agree with gemma-the-husky. The approach I would suggest is: Create one table containing all the information needed with one...

I think that the problem comes from the fact that you declare several times recordsets without closing them. In addition and some of them are not used (maybe because I see only a part of the code). What I would suggest is to: Declare the recordsets at the top of your module (so all recordsets...

Difficult to answer without the complete code but: Maybe you should replace the code by Private Sub cmdMoveNext_Click() If Not rsChangeRequest.EOF Then rsChangeRequest.MoveLast Else rsChangeRequest.MoveNext End If End Sub => The rsChangeRequest.MoveNext will only be executed when not at...

Hello, I have created a tutorial to make a nice drag and drop between two Access forms. This tutorial is available here: http://www.gylsolutions.fr/en/blog/88-blog-uk/access-tips/116-drag-and-drop-between-two-access-forms Follow this link and download the example database to see it. By...

Can't you simply use a function like this one to check if the folder exists? Public Function fnFolderExists(strFullPath As String) As Boolean On Error GoTo EndOfSub If Not Dir(strFullPath, vbDirectory) = vbNullString Then fnFolderExists= True EndOfSub: On Error GoTo 0 End Function...

Hi, I don't catch exactly what you want to do..! But I think there is an easier way to do it :P I agree with spikepl, can you give us some more info? You have 1296 text boxes for each record (horizontally) or 1296 records (vertically)? A basic principle is that your population needs to be...

Hello again! I am not sure about the cause but why don't you just open the recordset after the insert query instead of using a requery? 'SS ------- Updates table with projects to be assigned sSQL = "INSERT INTO [Temporary assignments] ( [Project number] )" sSQL = sSQL & " SELECT...

You will find many tutorials on printers selection on the web. I have not 10 messages yet so I cannot give you links... but search "allenbrowne AppPrintMgt" or "access reports rpt0009" on google and you will find!!!

Please edit your message and use the CODE tags! Else it is impossible to read the code ;)

Hello, If the form display is too slow, it is probably because your source query (qryWocheDetailBereich) is too big or complex. => Is it using some data stored on the network? If yes, the best is probably to first copy the data locally and then base the query on the local data => Is your...

Hello, Can this piece of code can help you? (I found it on the web) Function Set_Account(ByVal AccountName As String, M As Outlook.MailItem) As String Dim OLI As Outlook.Inspector Dim strAccountBtnName As String Dim intLoc As Integer Const ID_ACCOUNTS = 31224 Dim CBs As Office.CommandBars...

Hi! It seems that your program doesn't recognize the recorset How is it defined? As global? ----- Lionel Garnier http://www.gylsolutions.fr - IT consulting, VBA, Access trainings, Excel trainings, PowerPoint trainings

Hi, Can you give us the code you are using?

Hello everybody! I am an Access developer and I am coming to this forum to share a bit of knowledge... after getting some help from other developers for years :) ----- Lionel Garnier http://www.gylsolutions.fr - IT consulting, VBA, Access trainings, Excel trainings, PowerPoint trainings