Search results

you can also add a description to each query, by right clicking on it in the database display window, select properties, then type in a description of the query. then right click on the db window and set it to Details. you should now see each query name and the description of it. hth, al

visit the MS download site, and get a copy of Qrysmp97. (sample queries) lots of good ideas and tips... hth, al

Is it acceptable?. most certainly! you can do some very powerful data manipulation with nested queries. al

see if this helps: http://www.access-programmers.co.uk/ubb/Forum7/HTML/001570.html al

jwindon's post should get you past the error. but SC's code might need the following modifications: ----------------- Set up a table called tblUserLog. This should have three fields. Username, LoginTime and LogOutTime. ----------------- think the table should be: UserID, LogInTime and...

you wrote: ----------- I have been designing a font viewer/manager. ----------- a couple of thoughts: 1. access is a really bad choice to try to do this with. can you really improve on the Windows font viewer/manager using access? 2. fonts are/were 'intellectual property' and in the early...

sounds like you either have a filter on the form itself, or the form is based on a query, not a table. check the Forms data tab to see if either is true. if not, how is the form opened?, if it is from a command button on another form, perhaps it is trying to select a specifc record using one of...

you can do either...no VBA required. you can link tables in another database, (probably the best solution) by selecting Get External Data>Link Tables and selecting the db tables you desire. or you can create a query with tables from another db, by starting a new query with the QBE grid. right...

unless your printer supports duplexing, you have to manually flip. al

you need to set CanShrink to Yes for the additional fields. check in Help for the CanShrink property. hth, al

for certain, you'll want to use a report... start by using the Report Wizard and try the various types of reports it generates... you can then either modify one that comes close or look at the design in order to create your own. hth, al

no sure what you are trying to do in the footer...but, to group on the 1st character, go to Sorting/Grouping aand set the Group Interval for acct# to 1. hth, al

the answer is it depends...the max number of nested queries is 50 and a max of 32 tables. but you may take performance hits before the maximum number is reached. you also may encounter 'too complex to evaluate' errors. i have done some pretty deep nesting with no problems and good...

stevev, sorry, was somehow thinking you had 2 tables...shacket's method is correct... try this: SELECT tblYourTable.Run, First(tblYourTable.BNumber) AS FirstOfBNumber, First(tblYourTable.SNumber) AS FirstOfSNumber FROM tblYourTable GROUP BY tblYourTable.Run; hth, al

if i understand the question...think you could split your query into 2 queries, the 1st with unique values for Run, then join the second query to it to get BNum and Snum. hth, al [This message has been edited by pcs (edited 11-08-2001).]

before i elaborate... does your 'table of minimum order quantities' look something like: Product ID Min. Quantity al

sarny, unless you have hard-coded refs. to the table in some VBA, you can likely go to the Form properties sheet, click the Data tab, and change the Record Source to the desired table. this assumes the field names are the same in both tables... hth, al

wierd indeed...probably another 'undocumented feature'. sure wish i could pass off my bugs as 'undocumented features' in any case, i can't move to another country (my neighbors' hopes notwithstanding). it just strikes me as odd that Jet goes to the trouble of establishing date validity...

RDH, thanks...think you are right. al

rich, i tried that, but no joy the default: The value you entered isn't valid for this field... fires before the validation rule. i know i can change the textbox to non-date and then use VBA after entry to check it, but i'm just positive i have done this using the validation rule/text. any...