Recent content by xaviermobius

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...

thank you so much, my progress bar works beautifully now!

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...

Private Sub CommandButton1_Click() Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItemFromTemplate("<absolute file path to template here>") myItem.Subject = "mailsubjectline" myItem.Attachments.Add ("<absolute attachment path here>") myItem.Display End Sub You...

What version of outlook are you using - from version 2002 Microsoft added in security settings which require the user to allow an application outside of Outlook to send emails using the outlook service. This is requested via a alert box shown when the email object attempts to send. See the code...

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...

Thanks for your reply, i have taken it on board. At the moment i have the following code, which stores the input date as variable batchdate. But for some reason it is not working when i try it. i get #Name? come up in the field. Private Sub Command4_Click() Dim batchdate As String batchdate =...

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...