Search results

Hi there, I've noticed that, using European date formatting (dd/mm/yyyy), without extra formatting Dec. 1st becomes Jan 12th when passing the value to SQL - so try enclosing the dates withing a Format(<Field>, "mm/dd/yyyy") and it should work. Not beautiful, but functional. Of course, this...

Hi there BrokenBiker, If you chart it in Excel, you can create a Pivot Chart based on the entire columns (A:B rather than A2:B13 like in the above example). Since it gives you the option to filter out the blanks you'll get the correct amount of columns. The only inconvenience would be that the...

Hi Matt! That error (438) ocurrs for objects that don't have a .ControlSource, for example a button. I did have that problem when first writing that piece of code, but with the On Error Resume Next it was solved. Of course, in the preceeding IF-statement you could easily add And Not...

Re: Updating data in "Find Record" combo box when current record on a form is changed Ah ok. Try moving the CmdFindRecipe = Me.txtName to Form_Current. That should do the trick.

Re: Updating data in "Find Record" combo box when current record on a form is changed Hi Mel, Does the combobox actually have 2 columns, the PK and the name? In that case you can't pass the name to the combobox, but the AutoNumber value instead: Private Sub Form_Current()...

Hi there, Access help says: So if you change it to Forms!frmBookList!fsubSubjectsBook.Controls("ID" & i).Value = "" it should work

Hi there Brian, Yes you can send faxes directly through VBA to RighFax, just have a look at this thread (I'll do the same for our department, never thought about it before, but it'll definately save time - thanks for the good idea Brian...

Ok, so the MS KB has got a description of the error at http://msdn.microsoft.com/en-us/library/bb223144.aspx According to this, it's a DAO-realated error. Is there any open form that's got code set to run OnClose, referencing a linked source?

From where is the code launched? If it's from another sub's or function's error handler, you'll have to pass the two parameters: Call Form_Error(Err.Number, 0) For the second error, did you remove the On Error Resume Next? Thing is I got the same msg, but it won't (shouldn't) affect controls...

Hi again, yup that message box is created by the If MsgBox("Do you want to undo any changes?", vbYesNo, "Confirm") = vbYes Then Me.Undo End If If you don't want that message to show, just comment those lines out - but the users won't be given the option to undo the data entry in case of...

Hi Laurel, Try changing the first part to If IsNull(Me.Title) Then MsgBox "You must enter an Engagement Title.", vbCritical, "Data entry error..." Me.Title.BorderColor = vbRed Me.Title.SetFocus Cancel = True End If However, if the control's formatting is sunken, the change...

Hi there, For our reporting we use pre-formatted Excel files like templates and export whatever values we want to that document. If that's what you need you can have a look at the attached example. The root folder has got a subfolder called _Template containing the graphics and a sheet...

Hi Jacob, We've had a similar problem here with a couple of dbs, where doing the earlier mentioned sollutions didn't work. What solved the issue for us was creating a new db, importing table definitions only, then launching an append query (I don't know exactly why this worked, but perhaps a...

Hi again Matt! Sorry for getting back to you a bit later that I said, but what with Christmas and all... Now that I’m tired of all the food, let’s have a look at this: You seem to suffer the same problems we did – we had to replace a box since it was failing so much (and therefore causing...

Hi there Matt, I'll be happy to help out, I'm out of town this week though, will post the code as soon as I return. I the meantime, I'll give you a few pointers: - The temporary tamble should be an exact copy of the BE one. That way you can just loop through the temp table copying all the...

Hi again, It's in the mdb i sent you. File->Get External Data and choose the txtfile you want to import, and the Import / Export Wizard starts. On the bottom left hand you'll see a button named "Advanced". Click it, then choose "Specs" and choose the only specification that's in there (namned...

Hi there Tom, I imported the text file, but since I don't know what output you'd expect I couldn't say if the result was good or not. I've attached a db with half of the records plus the import spec you'd need, hope it helps. Regards, Gustav

Solved: Supressing error msg "3043 - Disk or network error" Hrm, From the MS Access help on OnError event: Private Sub object_Error(DataErr As Integer, Response As Integer) ... Response The setting determines whether or not an error message is displayed. The Response argument can be...

Hi there NigelShaw, and thanks for your reply. I tried it first in the Form_Error (which triggers the external restore subroutine), but as the error occurs before coming to Form_Error, Err.Number shows 0. Perhaps I need to figure out exactly where it's triggered (so far I only know it's not in...

(Solved) Supressing error msg "3043 - Disk or network error" (This issue has been resolved) Hi there, We're using a couple of networked Access DBs for client data capturing, and the error 3043 - Disk or network error has been costing us lots of man hours. After giving up on resolving the...