Search results

  1. M

    FilterOn not working

    Hi, I've got this code on a combo box Private Sub cmbSysName_Change() Dim strFilter As String If IsNull(Me!cmbSysName) Then Else strFilter = "'" & Me!cmbSysName & "'" Form.Filter = strFilter Form.FilterOn = True End If End Sub It's running but...
  2. M

    Unbound Combo box

    Hi, I have 2 combo boxes -1 in the header & 1 in the detail. Both have lists attached to them & are limited to the lists. In the header, if I start typing in it, it predicts the selection from the list. In the detail it doesn't -in fact it doesn't even show what I typed although it does...
  3. M

    Tick box value

    Hi, I've got a table with a key & a 'Live' tick box. I just added a new item to it via a form -enter the key & the default for the tick box is 'Yes' according to the table setup. It's then supposed to pop up in a combo box on a form but wasn't so I created a query to have a look & cannot...
  4. M

    Prevent users from seeing design view of a form (re-enable)

    Ummmmm, having disabled everything on startup, how do you go back & re-enable it!!!!!!? Thanks......
  5. M

    External Table not in expected Format

    Does nobody have any suggestions for this then? :( Thanks
  6. M

    External Table not in expected Format

    Hi, I'm setting up some vba to import a series of tables. They're saved as excel 97-2003 files but are a bit weird. When I open them in excel, they say it's in a 'different format than that specified by the file extension' & so when access runs the vba, I get the 'external table not in...
  7. M

    Error in importing .txt files

    Haha, yep, it was a long integer, changed to double & all is fine :D Thankyou!!!!!!!!!!! I'll try & remember that long limit too (or at least that there is one!! :rolleyes:)
  8. M

    Error in importing .txt files

    Here's one of the inputs: Node,Total KB,Current KB apprsltsbdc1025,3531951674,0 -here Total bkserv7,957424516,564475044 bkserv8,984112250,494073715 cd4mlive,3690862764,0 -here Total colprdmis,3032896594,0 -here Total colprdops,4864941638,0 -here Total devhris0,12884992,0...
  9. M

    Error in importing .txt files

    I've done the len & they're all the length the number of characters purport them to be. I'm trying to keep manual intervention down to a minimum, hence importing them as .txt (there's about 20 different txt files each month plus another 10 already in excel, all from different sources &...
  10. M

    Error in importing .txt files

    Hi, I've set up my vba to import some .txt files on the click of a button. That's all fine, except, while importing I get the message: Microsoft Access was not able to import all the data etc etc The contents of fields in x records was deleted etc When I look at these tables in excel, I...
  11. M

    RecordCount error

    I'm running the below code: Dim db As Database Dim rst As Recordset Dim Counter As Integer Set db = CurrentDb Set rst = db.OpenRecordset("SELECT [Field] FROM tbl_Imports WHERE [Use] Is Not Null", dbOpenDynaset) Counter = rst.RecordCount MsgBox Counter & the MsgBox is coming...
  12. M

    On error option -resume or end

    Hi, I'm running a vba loop to import a list of tables. Assuming the end user has had a blonde moment & forgotten to untick one of the tables in the appropriate form & so the loop comes to a table which isn't there & so an error. In some circumstances, it may need to be there, & so stopping...
  13. M

    Custom date format for custom combo box value list

    Woohoo, got there!! Private Sub Form_Load() Dim x As Integer Dim DtmString As String Dim d As Date For x = 1 To 2 d = CDate("01/" & VBA.Month(Date) & "/" & VBA.Year(Date)) DtmString = DtmString & ";" & Format(DateAdd("m", -x, d), "mmm yyyy") Next DtmString =...
  14. M

    Custom date format for custom combo box value list

    In this particular section I'm dealing with linear regression for forecasting. There's inputs from a number of sources, mapped in the database & then this form will spew them out into excel & run a macro there to do the linear regression bit then bring the output of that back in (I...
  15. M

    Custom date format for custom combo box value list

    Aha, awesome, it does thankyou!! Might have to go & update some of my rickety code with the new toy!! Just a little problem though -1st it won't let me use it as a field name & 2nd, when I put it into a table, it comes out as a very small decimal number. I'm used to dates using the 5 digit (eg...
  16. M

    Custom date format for custom combo box value list

    Hiya, I'll give that a go thanks. Just as a slight curve ball though, does it take into account previous years, eg in January coming up with Nov & Dec of the previous year? Thanks merry_fay
  17. M

    Custom date format for custom combo box value list

    From a visibility perspective, as it's currently March, I want them to have the dropdown option for: Feb 2011 Jan 2011 From a behind the scenes perspective, I need the selected option to be the 1st of the chosen month/year combo, 00:00:00 time. This will be used as an exported column header...
  18. M

    Custom date format for custom combo box value list

    Hi, I've written some vba to set a combo box value list as last month or the month before. Now I'm trying to format it & am having issues. I've set the combo box itself to be mmm yyyy & once a selection is made, it displays like that, but the dropdown is still showing eg 01/02/2011. What do...
  19. M

    Which month fields to update

    Structure: Table A has no dates whatso-ever. It is a continually moving input table (all changes/inputs made via a form!) Table B is the 'output' data -this is where in eg Jan 2011, a fixed, will never change Jan 2011 using Table A is written. Other inputs from other sources (including the...
  20. M

    Which month fields to update

    I know & that's how it works.... That's not what my question was though, I'm trying to build the working's into the form so the user can enter the data into the form & then what needs to happen, happens without them having touch the tables directly at all. Regardless of whether I have a column...
Back
Top Bottom