Search results

Good morning all, Installed AC2007 on friday... then run one of my existing AC2003 db's on it. Spent the next 48 hours trying to work out why all my command menus in AC2007 were missing. The property sheet and field list were both not displaying. The buttons to bring them up could be...

I have a custom icon which i am using for my application and its forms - i have ticked this property on within the startup panel. The code below refreshes the icon on startup and it called by the autoexec macro. Public Function autoexecloader() Dim s As String Dim dbs As Object Set...

I have a simple DB with 3 tables and wish to count the number of tables using VBA code. Code as follows: Private Sub Command0_Click() Dim dbs As DAO.Database Dim tdf As DAO.TableDef Set dbs = CurrentDb Dim tablecount As Integer tablecount = dbs.TableDefs.Count MsgBox tablecount End Sub The...

I am using the following code to refresh the linked tables with the backend, the code works fine except that after the table links get refreshed (following a change in where the program is stored) a restart of the application is necessary. Sub TabloLinkleriniKontrolEt() Dim daTaban As...

Hi all, I have an unbound text box called idfind and the value entered is an id which is to be loaded on pressing enter. The problem is - when the user presses the enter key after typing the id the focus shifts to another control and the keypress action doesnt get run. My question is how do i...

I am trying to code a function which will highlight the text box while its being edited. The function highlight() is placed in the OnGotFocus property of the field so it is called when the field is in focus. I am new to VBA and dont know how to select the currently selected field i.e. the...

I am trying to code a function which will highlight the text box while its being edited. The function highlight() is placed in the OnGotFocus property of the field so it is called when the field is in focus. I am new to VBA and dont know how to select the currently selected field i.e. the...

Hi, im new to the forums - this is my first post. On a form i have a text box which holds the date that a file batch was taken to be processed. Each file holds the date of when the batch it originated from was taken. At the moment for ease of use the 'Default Value' of the text box is set to...