Recent content by john471

Short of writing the code for you... here is a pointer to get you started... Use the AfterUpdate event of your check box (ChkGW). If the user has cleared the checkbox, then clear out the target text box, (you didn't explicitly say you want this behaviour, that is a presumption on my part)...

Thinking more about it this morning, also realised that you don't neeed SQL to update the "target" recordset - just use rstarget.edit rstarget.fields("RSRC_RATE_ID").value = lngRateID rstarget.fields("COST_PER_QTY").value = vCost rstarget.fields("COST_PER_QTY2").value = vCost2 rstarget.update...

This might work 1) A Union Query (tantamount to appending all the records into one (temporary) table) 2) A totals query based on the Union Query; grouping on the value, and only showing results whose count = 1 Just a thought. Regards John.

Regrettably, I am not an access god - but I shall take a stab at helping out... Think about what entities you have and what attributes those entities have. The enities become your tables, and the attributes are the fields within the tables. I'm not terribly knowledgeable in areas of law or...

In no particular order:- Database Observations --------------------- Your tables have repeating groups - this is generally considered to be bad practice. Rsrcrate - COST_PER_QTY, COST_PER_QTY2, COST_PER_QTY3, (etc) Read up on "Database Normalisation (Normalization)" for more information. In a...

This might get you closer, but I'm not certain about the 'date - math' aspect of it. Looking up "DateDiff" and/or "CDate" in help may prove fruitful for you. The OR construct/useage in Excel is not the same in Access... = IFF ( [IMPORTANCE] = "Complete", IFF([Category] = "Cost Avoidance vs...

Did the original developer supply the mdb of the front end, or only an mde ? If you don't have a copy of the mdb, then I don't think there is much hope. However, if you have an mdb I believe one of the (many) hack utilities would be able to do the trick. I had a case where the original...

Have you stepped through your code in debug ? I think you will find that your code, as written will... If the ID number entered matches the ID of the first record in the recordset, update the description of every record to the entry in text3. If the ID number entered doesn't happen to match...

Have you tried setting the "type" of the parameter? 1) Open your query in design view 2) From the Query menu, select "Parameters..." 3) In the Parameter column, type in the name of your parameter i.e. "ENTER START DATE" (without the quotes) 4) In the Data Type column, change this to...

Ogg13, So it is becoming clearer you are wanting to regularly import data that another program exports. What format does the other app expot to? The reason for my lengthy post above is that you are treading on dangerous ground. Pat Hartman is widely considered one of the foremost experts to...

From what I think I understand, MStef has demonstrated the converse of what you are asking for:- blanking out repetitions instead of filling them in. You could use the same technique to fill them in, using an update query and rewriting the code to supply the 1)the previous value when the value...

You are welcome, xltest. Thank you for taking the time to reply back.

P.S. I forgot to mention before.... you will want to update your control's value in the form's On Current event.

I believe you would need an unbound control (e.g. textbox with no control source). You would probably also set its Locked property to true (so users can't edit it). I expect searching access on-line help for "CurrentRecord Property" may set you on the desired path. :) HTH Regards John.

xltest, I realise you probably believe you are being clear, but your situation/explanation(s) still leave me a little confused. Here is what I think I understand: 1) You are working in Excel (and not MS Access) 2) You have 60K + rows of data on which you want to expediently perform a one-off...