Recent content by wazz
-
David Crake – very sad news
same here. shocked. rip dave. a good egg. :)- wazz
- Post #39
- Forum: Access World News
-
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). -
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- wazz
- Post #2
- Forum: Modules & VBA
-
String Variant Problem
http://support.microsoft.com/kb/209534 says for access 2000 but applies to all.- wazz
- Post #6
- Forum: Modules & VBA
-
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...- wazz
- Post #4
- Forum: Modules & VBA
-
String Variant Problem
try rs.FindFirst "[StnNo]= ' " & Me![Combo4] & " ' " but i'm not exactly sure if you need a number or a string. :)- wazz
- Post #2
- Forum: Modules & VBA
-
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. -
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. -
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"... -
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... -
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... -
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). -
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)... -
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- wazz
- Post #4
- Forum: Modules & VBA
-
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...