Search results for query: *

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 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...

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...

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...

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 =...

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

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...