Search results

  1. wazz

    David Crake – very sad news

    same here. shocked. rip dave. a good egg. :)
  2. wazz

    Looking for Information on form commands

    look up 'Form Object' in VBA Editor Help (not Access help). (from Access, hit Alt+F11) in the Form Object entry, look at the Methods (etc).
  3. wazz

    Help With If Statement

    without getting into the whys and wherefores of what you're doing, you can use MOD (modulus) as a start: 23 mod(10) = 3 20 mod(10) = 0 means: 23 / 10 leaves a remainder of 3 (23 is not divisible by 10) 20 / 10 leaves a remainder of 0 (20 is divisible by 10) If 23 mod(10) = 0 Then ... Else End If
  4. wazz

    String Variant Problem

    http://support.microsoft.com/kb/209534 says for access 2000 but applies to all.
  5. wazz

    String Variant Problem

    i suggest some redesigning. add a primary key to each table and make the data type 'AutoNumber', it will make your life a lot easier. you've made a basic relationship, but redo that using the autonumber field. make sure each table contains information about only ONE thing (unless you are joining...
  6. wazz

    String Variant Problem

    try rs.FindFirst "[StnNo]= ' " & Me![Combo4] & " ' " but i'm not exactly sure if you need a number or a string. :)
  7. wazz

    Can I only list one code per list box or combo box

    when you are designing you will need to see the properties of the thing you are working on. right-click 'the thing' and select properties (or view -> properties). have a look at all the properties (for familiarity). you will find multi-select in there.
  8. wazz

    Can I only list one code per list box or combo box

    hi. we need more info. but, a listbox can be either single-select or multi-select. on a multi-select list you would have to be able to loop through the selected items on the list (in code) to get what was selected in order to use them.
  9. wazz

    Xml

    right. the way i remember it is (i should check this, been a little while): this, at the top of xml files: <?xml version="1.0" encoding="utf-8" ?> is a 'standard' that an xml file must use. it's a bit like a web page that has: <!DOCTYPE htmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN"...
  10. wazz

    How to iterate through all forms in a closing event of a form?

    i haven't tried the routine as it is. i'm wondering, which line does it break on? was just looking more closely, i don't think this line is right: For i = 0 To Control.Controls.Count - 1 i think it should be For i = 0 To Form.Controls.Count - 1 actually, i think it should be For Each Form In...
  11. wazz

    How to iterate through all forms in a closing event of a form?

    i haven't tried the routine as it is. i'm wondering, which line does it break on? was just looking more closely, i don't think this line is right: For i = 0 To Control.Controls.Count - 1 i think it should be For i = 0 To Form.Controls.Count - 1 actually, i think it should be For Each Form In...
  12. wazz

    How to iterate through all forms in a closing event of a form?

    pretty sure it should work either way and that the main problem was just that you were missing Forms(frm.Name).
  13. wazz

    How to iterate through all forms in a closing event of a form?

    something like: Const conDesignView = 0 Dim frm As Form Dim ctl As Control Dim prp As Property ' Enumerate Forms collection. For Each frm In Forms If Forms(frm.Name).CurrentView <> conDesignView Then For Each ctl in Forms(frm.Name)...
  14. wazz

    Querydef Paramater Query

    oh, you want to use a qdef. more like this then: Set db = CurrentDb Set qdef = db.QueryDefs("qryName") 'Evaluate and set the query's parameters. For Each prm In qdef.Parameters prm.Value = Eval(prm.Name) Next prm Set rs = qdef.OpenRecordset
  15. wazz

    Xml

    i wonder about xml sometimes too. it does always seem to be a brute force approach and it's a bit annoying. i don't think there's any way around it. don't know about import xml. can you read 'node types'? in c# you have to do something like this: while (reader.Read()) { switch...
  16. wazz

    Form for entering criteria

    you can work it to use comboboxes. the first column of the combobox would contain the ID but it would not be visible (width = 0). user can select something useful (viewing column 2) but the query would use column 1. and you would not need to use Like, because it's type is Long Integer...
  17. wazz

    Querydef Paramater Query

    i think it should be more like: dim strSQL as string strsql = "SELECT ULD_TAG.* FROM ULD_TAG WHERE ULD_TAG.TMP_ASSET Like '*' & [Forms]![frm_asset_filt]![cbo_asset] AND ULD_TAG.TMP_SYS Like '*' & [Forms]![frm_asset_filt]![cbo_sys];" Set db = CurrentDb Set rs = db.OpenRecordset(strSql...
  18. wazz

    Copying values from one form to another, when the second form is in data entry mode

    thanks for posting back. if you come across a term you don't know, look it up in the help files. (i usually use the VBA editor's help, as opposed to Access help, but both are... helpful.)
  19. wazz

    Requery problem sub select form problem I think

    not sure what this means. there might be some info on this thread that could help: http://www.access-programmers.co.uk/forums/showthread.php?t=187193
  20. wazz

    Copying values from one form to another, when the second form is in data entry mode

    you can send the id when you open the 'add' form: docmd.openform "frmAdd",,,,,,Me.ID. the last item after all the commas (Me.ID) should be replaced by the CustomerID you want to send to the 'add' form. so, the last item after all the commas (called 'OpenArgs') gets 'sent' to the form you...
Top Bottom