I think a solution might be to set the ID Number to a global variable, then have the query reference the ID Number global variable via a function...
Something like this:
Create a global variable in a module:
public glngIDNumber as long
Then create a function:
'Assuming your ID Number is a...
Try this...this is a function that will build a where clause based on selections of a list box. You can use this where clause as part of a SQL statement, or you can use it as a filter when opening reports/forms.
Just plug it in to a module, and call it passing in the paramaters. If you have any...
I have a report that is pretty helpful when dealing with xtab queries. It's a "generic" report, simply call a procedure, pass in a title for the report, and the xtab query name as parameters, and it opens it in a report. This might fix your problems--I haven't used it in a couple of...
When you are creating the queries, are you using the unmatched record wizard? I guess where I'm going with this, is that maybe the 45 records that are getting returned are the ones that don't match.
But if you just create a NEW query (without wizard) and you create the join and it only returns...
Do the 6 radio buttons all represent 1 field in the database? If so, create an option group, put the radio buttons in there, then set the control source for the option group to your field.
Then, depending on your database/workflow, you can either make the field mandatory, or check for a value...
First I would change a couple things about your list box, set column 1 to the primary key and bind column 1. Then column 2 would be a concatanation of the last and first name, then just show column 2. (give a yell if you need more specific here)
After that, I think the following function would...
Also, if you just start to create a record, the auto number will increment. By just clicking on the 'New Record' button on the record navigation, it will increment your autonumber.
The AutoNumber was not designed to "count" records, but rather to ensure uniqueness...I hope this clears...
Thanks, I got it working with your second idea (browsing for file yielded same error)! I'm still puzzled though,
Here is my code (init proc on form):
do qlkpschclass.qpr
THISFORM.lstClassList.ROWSOURCE='curClassLst'
This gives me the same error
but this works:
do...
I think this might work for, I think perhaps it is a little more complicated than you wanted though...what you need to do is create a table with the following fields
ControlNumberCurrentNumber - Text
ControlNumberMonth - Text 'Just in case you want to use MM
ControlNumberYear - Text
Create and...
Hopefully this one is easy...
I created a ListBox and would like to set the RowSource to a query. I set the RowSourceType property to Query .QPR, and the RowSource property has the full path to the .qpr file. When I try to run the form, I get the following error:
File '<file name>' does not...
What happens if you take the () off msgbox? Try using:
MsgBox "You have to enter a company_ID first to select the sectors"
or,
if isnull(me!txtCompany_ID) then
should work also.
If you post/send me your email, I can send you a procedure and a report that handles crosstab queries. Just call the procedure and pass into it the cross-tab query name, and a title for the report--easy as that.
Jeff
gus_hammond@zdnetonebox.com
If I understand everything correctly, I think this code might work for you. It's a little crude and it does not take everything into account, so you might have to scrub data before it's run. Basically it assumes a new table named tblListType with 2 fields, IndividualID and ListType. As always...
If I understand everything correctly...can you create a query and use the following expression:
ExportField01: Format([lngNumberHere],"00000")
If the value of lngNumberHere is 25, then ExportField01 would have "00025" as a value.
Then export the query instead of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.