Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: wazz
Forum: Access World News 05-17-2011, 02:49 PM
Replies: 85
Views: 56,899
Posted By wazz
Re: David Crake very sad news

same here. shocked. rip dave. a good egg. :)
Forum: Forms 04-10-2010, 12:18 AM
Replies: 1
Views: 458
Posted By wazz
Re: 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).
Forum: Modules & VBA 04-10-2010, 12:11 AM
Replies: 1
Views: 659
Posted By wazz
Re: 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...
Forum: Modules & VBA 02-02-2010, 07:32 AM
Replies: 5
Views: 988
Posted By wazz
Re: String Variant Problem

http://support.microsoft.com/kb/209534

says for access 2000 but applies to all.
Forum: Modules & VBA 02-01-2010, 10:55 AM
Replies: 5
Views: 988
Posted By wazz
Re: 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...
Forum: Modules & VBA 01-31-2010, 11:13 PM
Replies: 5
Views: 988
Posted By wazz
Re: String Variant Problem

try
rs.FindFirst "[StnNo]= ' " & Me![Combo4] & " ' "

but i'm not exactly sure if you need a number or a string. :)
Forum: Forms 01-29-2010, 11:49 PM
Replies: 9
Views: 1,039
Posted By wazz
Re: 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...
Forum: Forms 01-29-2010, 11:12 PM
Replies: 9
Views: 1,039
Posted By wazz
Re: 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...
Forum: General 01-29-2010, 11:01 PM
Replies: 26
Xml
Views: 2,873
Posted By wazz
Re: 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....
Forum: Forms 01-29-2010, 06:01 AM
Replies: 7
Views: 1,135
Posted By wazz
Re: 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...
Forum: Forms 01-29-2010, 06:01 AM
Replies: 7
Views: 1,135
Posted By wazz
Re: 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...
Forum: Forms 01-29-2010, 02:28 AM
Replies: 7
Views: 1,135
Posted By wazz
Re: 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).
Forum: Forms 01-29-2010, 12:39 AM
Replies: 7
Views: 1,135
Posted By wazz
Re: 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...
Forum: Modules & VBA 01-29-2010, 12:27 AM
Replies: 3
Views: 874
Posted By wazz
Re: 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 =...
Forum: General 01-29-2010, 12:16 AM
Replies: 26
Xml
Views: 2,873
Posted By wazz
Re: 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...
Forum: Forms 01-28-2010, 11:57 PM
Replies: 7
Views: 881
Posted By wazz
Re: 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...
Forum: Modules & VBA 01-28-2010, 11:49 PM
Replies: 3
Views: 874
Posted By wazz
Re: 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...
Forum: Forms 01-28-2010, 08:47 AM
Replies: 9
Views: 2,136
Posted By wazz
Re: Copying values from one form to another, when the second form is in data entry mo

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.)
Forum: Forms 01-28-2010, 08:12 AM
Replies: 1
Views: 1,238
Posted By wazz
Re: 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
Forum: Forms 01-28-2010, 08:01 AM
Replies: 9
Views: 2,136
Posted By wazz
Re: Copying values from one form to another, when the second form is in data entry mo

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...
Forum: Forms 01-28-2010, 06:16 AM
Replies: 9
Views: 2,136
Posted By wazz
Re: Copying values from one form to another, when the second form is in data entry mo

it's a short-form way of checking for null and a null (empty) string in one shot. you can't use cstr because if it is null you get a runtime error trying to convert a null.

so you could say:
If...
Forum: Queries 01-27-2010, 01:14 PM
Replies: 1
Views: 810
Posted By wazz
Re: drill down views?

just put all the tables into a query, add the columns you want, create a report based on the query and organize the fields in the order you want. use headers and 'sorting and grouping' to keep things...
Forum: Forms 01-27-2010, 01:07 PM
Replies: 9
Views: 2,136
Posted By wazz
Re: Copying values from one form to another, when the second form is in data entry mo

you can send the id when you open the 'add' form:
docmd.openform "frmAdd",,,,,,Me.ID

then in the 'add' form's Open event you could say:
'set the id when the form opens
If Me.OpenArgs <> ""...
Forum: Modules & VBA 01-26-2010, 10:22 PM
Replies: 5
Views: 4,310
Posted By wazz
Re: Run time error 7951

you also have to use the correct terminology. what you're saying now is completely different than your first post.
Forum: Forms 01-23-2010, 09:35 PM
Replies: 10
Views: 3,308
Posted By wazz
Re: Assign a subform instance to the parent form

i seem to recall someone trying to do this a long time ago. do a search for someone trying to nest subdatasheets. i don't think it was possible programmatically. (as i recall he seemed to know what...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World