Search results for query: *

I was looking for access 97 and windows 98 and found many office 97 on yahoo auctions, even one enterprise edition (with developer tools) ranging from $20 to $150. There seems to be a lot available. alley

I have 3 tables-- jobs, empjobs, taskjobs. Referential integrity is forced, so I must delete from the 'many' tables before I delete from the 'one' side (jobs). My question is, how do I pass the parameter (jobs dated before X date) to all three, so I don't have to rely on the user to put the...

I have been trying to split an MDB and I get 'subscript out of range' and 'invalid procedure call or argument'. True to form, there is no clue as to where these errors are, or if they are ACCESS errors, not mine. I have searched the code, but can't find either error. This is a live...

I have 3 files.. Job Headers, Job tasks, and Job workers, one to many on the last two from the header file, not cascaded.<br><br>The first query is a simple select, finding job numbers with dates less than a 'Purge Up To' parameter, then 3 delete queries matching the job numbers to delete the...

I have 3 files.. Job Headers, Job tasks, and Job workers, one to many on the last two from the header file, not cascaded.<br><br>The first query is a simple select, finding job numbers with dates less than a 'Purge Up To' parameter, then 3 delete queries matching the job numbers to delete the...

I have a select Query that selects job numbers based on a 'Purge up to' date, and a delete query that uses the first query jobno's to select and delete from 2 detail files - job tasks and job employees.&nbsp;&nbsp;I do not delete the job headerfile, the source of query #1 jobno's.<br><br>It...

Which is ridiculous, of course.<br><br>Adding a list of numbers in a recordset clone comes up with wrong answers for all three sums. The currency numbers are low, and the integer one is high. <br><br>Source and object data types match.&nbsp;&nbsp;There is no number in any of the lists that...

With a main form and subforms, the user will change one or several numbers in either or both subforms, clicking a button to re-calculate totals and statistics, redoing the process until satisfied.<br><br>What is the code for cycling thru the records in subforms, inserting data and gathering totals?

What is the procedure to total columns in&nbsp;&nbsp;subform records?&nbsp;&nbsp;The records are filtered by the main form, so only the records I need are in the subforms.&nbsp;&nbsp;A column in the 2nd subform&nbsp;&nbsp;must be updated with the total derived from the 1st subform and then...

How do you provide software only updates (not tables) to a user who has their own data?<br><br>alley

After reviewing query types, I can't see how to remove records from tables and save them in history files.&nbsp;&nbsp;Can this be done in one step or must it be two?<br><br>Also, when I split the DB, I want to send the forms, reports, queries, etc to the user without wiping out their...

Never the twain shall meet, unless you what??<br><br>1. Declare them public in the main report?<br>2. Email them?<br>3. Yell real loud.<br><br>Yelling doesn't work, as you all know.&nbsp;&nbsp;It seems to me there should be a simple way to communicate between a sub-report and the main report...

Help is not helpful.&nbsp;&nbsp;I get a request for Jobno after the start/end date parameters on every report I have tried, even though jobno is not a group or subtotal or header.&nbsp;&nbsp;Just a piece of data in the report.&nbsp;&nbsp;Strange it is always jobno.&nbsp;&nbsp;Somewhere I have...

It's got me stumped. Pages 1,3,5, etc are OK.<br>Pages 2,4,6 are totally blank.&nbsp;&nbsp;Used a wizard<br>(ornery things).&nbsp;&nbsp;Looked for force new page.<br>Nothing.&nbsp;&nbsp;What did (or didn't) I do?<br>alley

Using a form to display related recordset, and filling in 2 fields from a 3rd table.<br> DougP will recognize code he supplied to someone else for this task. Form shows a job header, and the subform shows customer job detail by unique jobno. Each customer has his bill/pay rates for each task...

How do I get data entry verified from linked browse tables? I am no opposed to <br> writing code, but even with DB relations set up and referential integrity set up, it doesn't seem to work, so I am beginning to think I need to use SEEK or SCAN. <br> However having done only in-line...