Search results for query: *

thanks link9 i gave it a quick try but no go; i'll be working on though cj

i am trying to write a query expression to put the name and address fields on an invoice report. i am writing an expression so blank fields won't take up a line ( i just use iif and isnull ) but i can't figure out how to add a carriage return and linefeed; it doesn't seem to like vbcrlf or...

i guess it would be easier to know if you pasted the code from the SQL view cj

I am looking for some guidance in setting up an invoice system. I want it to be as maintenance free as possible. The products vary from courses (with different fee structures within each course) to simple physical products to conference registrations also with many variables to membership dues...

also note with access when you enter a date such as 1 13 00 instead of 13 01 00, because there is no 13th month, access automatically enters it as jan 13 so sometimes it will autocorrect an input error, leaving you with an incorrect date

You da man jerry!

jerry thanks for your reply labels in fact do have click and mouse up/down events i trigger however, because a label cannot take the focus it doesn't become the active control i'm saying there must be a way (other than identifying the active control) to determine which control has has generated...

hi i have many labels on a form, and would like to have a piece of code which determines which label was clicked so i can highlite the text in the label on mousedown and return it to normal on mouseup on each event i would like to run a function which passes the name to a procedure to change the...

rafe good call so far so good, and even better, if assume i did something i can fix that is causing these things(instead of random happenings) chances of fixing are sure better thanks cj

After making great strides today, i had an old foe visit. i have numerous fields on a main form and on a sub form that trigger a requery of the subform to reflect changes in a calculation works great except every now and then, the controls on the main form don't trigger the update .. so i have...

Well God .. oopps .. i mean Gord that was it, i had mixed up the 2 expamples (one using the with statement, the other not) and my hybrid code didn't work! i won't gush here in a public forum, but you have just opened up the rest of this project for me, as i will be automating a lot of record...

here i go again after changing the pecking order of the reference libraries to look like gord's (*** thanks gord ***): VB for Apps Ms 9.0 Object library Ms DAO 3.6 ... OLE Automation... Ms VB for apps Ext..5.3 my little bit of code like this: Dim DB As Database, RS As...

hey gord thanks for replying again this time though, i get an error saying cannot find object that looks for an object named "Select tblCourseReg.* FROM tblCourseReg" i like to look at things from different sides, but i'm really perplexed over this "type mismatch" error...

holy cow! i finally get to declare a database as a database (thanks) and follow examples to a "T" i think and i get a "type mismatch" error that i just don't see here is the code: Dim DB As Database, RS As Recordset, strTableName As _ String strTableName =...

thank you folks .. both, it magically appears as a valid object!

i am having difficulty dimensioning as database on access 2000; it refuses to accept database as an object type, yet i see it done in examples all the time. what is it that i don't get? thanks for any help cj

that looks like the ticket alright thanks gord

by way of a form, i obtain a string(strField) value equal to the field name (i.e. [MemNoBook]) in a lookup table ([tblCourseFees]) ... i need to find the value of this field based on the [recordID] in the table. the table is in the open database, but is not open itself. i don't understand the...