Search results

I created an MDE file for my application it's a split db when I hit the exit command button on the MDB version it quits the application correctly but when I do the same thing on the MDE version, it leaves the database window open on the taskbar.

Hi, My application relies on whether Outlook is open and more importantly, with the correct Exchange profile selected. To ensure this I have the following code which, on the work PCs (Windows XP and Office 2003) works correctly. If Outlook_is_Running = True Then Set myOlApp =...

Hi, I use the following to enable users to create an address report and display it for printing. Sub LabelWizard() 'On Error GoTo ErrorHandler Dim dbs As Database Dim Rpc As Container Dim rpt As Document Set dbs = CurrentDb Set Rpc = dbs.Containers!Reports...

Beginning VBA (reference book) question (SOLVED) Hello, I am currently working on the reference book "Beginning Access VBA 2007" by Denise Gosnell and am stuck at attempting to get the code from Chapter 13 to work. The code is as follows: Function ProcessRecordset(strSQLStatement As String)...

Hi, I am trying to utilise this module to count words in a text box. The example shows how many words but only After update of the text box. How can I get it to show the word count as words are typed into the text box? All help appreciated. Thanks

Can anyone see a problem with the following code? Function MoveFolder(sFolderSource As String, sFolderDestination As String, _ bOverWriteFiles As Boolean) As Boolean On Error GoTo Error_Handler Dim fs As Object MoveFolder = False Set fs =...

I have the following code that I use on exit from my application. It successfully deletes childless parent records, but is there a better way to do this. My code looks a bit clanky and would like to streamline if possible. strSQL = "SELECT tblPersonal.intPersId " & vbCrLf & _...

I'm confused. This code works from a button on a form Private Sub Command0_Click() Dim intBoatNumber As Integer intBoatNumber = Nz(DLookup("intGlobalOptionsId", "tblBoat", "accStatus = 'On'")) DoCmd.OpenForm "Global", acNormal, , "Forms![Global].[intGlobalId]=" &...

Hi, I have searched for unrecognized format in these forums and can't really find the definitive answer to my problem. I have a database on my work system which runs fine. Whenever the system makes an update to Access 2003, however small the update is, when I attempt to open the database it...

As the title may suggest, I am not looking for friendly advice about going to the cinema, rather a geeky problem with my VBA code. (Maybe I do need the former lol) Anyway, I have a textbox which holds a date/time using the following format: Format$(Forms![FRMSIGNAL]![txtDTG], "ddhhnnZ MMM yy")...

Hi, The title doesn't really make up the question as there is a fair bit more to it but, here goes. I have a listbox on a form which is populated by a query on a table with 6 columns. One of the columns intTextLength is an integer containing the number 1 or 2. I wish for the user to only...

Hi, I am using this: http://www.everythingaccess.com/tutorials.asp?ID=List-files-recursively to show files in a listbox. Just as one of the replies asks, I too would like to know how to allow users to open the selected file. Thanks

What's the best way to implement my database? It has to work on a large corporate network which uses a remote infrastructure for updating software. It will be used by a maximum of 2 people at the same time but will be available to about 30 people.

Hi, I have a function in my database which creates .txt files ready for emailing. It saves the files locally in the form "ddhhmm_MMM_yy.txt" so each one is different. The files only need to be sent to one addressee which is the same every time. How do I automatically attach this to an...

I have a public function which I d/l from the net which removes punctuation from a string. The string is derived from a text box on a form. I know how the function works and how to send the string to the function. My question is: once the function is complete how is the string passed back to...

Is there a way of changing records to align themselves in alphabetical order and change the DMax counter numbers assigned to those records to match? i.e. (I use the DMax counter on the forms "before insert" event) can I change the following (read in two columns "count & name"): count -...

I'm having problems with validating data on a form. I created a command button that sets focus on the next page of a tab control. The validation code is within a module and is called for in the Form's before update event. The problem is that the correct error message appears from an "On...

Hi (again!) I am getting there with my new database, however one thing eludes me. I have a tabbed control <TabCtl0> with 4 pages which are related to the first page. Two of the pages only contain a subform (nothing else). I have a "Next" button which navigates through all the pages using the...

Hi, I'm trying to make a form available to users so they can input data without any other data being available to them. So I created a data access page, which works but when opened it shows the first record and the other records are navigable by anyone. How can I make it open at a new record...

Hi, After reading all about Autonumber and what you should not do with them, I am building my DB from scratch. The problem that I immediately hit upon is as follows: I created a table with a text field and want it to increment from 1 (so when the very first record is started the number 1 is...