Recent content by Donny

I have calculated (non data)fields from a subform showing accumulated charges from a related table. I cant seem to get my (data) fields to automatically calculate totals or commissions and tax [after update] of these calculated charge total fields. [subtotal]= me.calculated_field_1 +...

Craig Cheers mate perfect Donny

I have some code that sets an [event procedure] for a command button to find a word file and open it. The code is as follows- Private Sub Command1053_Click() Dim wordobj As Word.Application On Error GoTo ErrHandler Set wordobj = GetObject(, "Word.Application")...

I might have missed the point here but have you checked that the file is set to shared tools > options > advanced > shared Donny

I have a series of merged documents directly from a query in access where all the formats and data types are correct. Everything works beautifully accept the formatted spaces between numbers and names ie: xxx xxxx xxxx becomes xxxxxxxxxxx Is there a way to stop this???

That Helped me out too Thanx Donny

I have a series of calculated fields on a form that automatically work out VAT and Commission. It works beautifully accept it does not record the generated result in my table. Hence i cannot run queries on the calculated data.... Help Please Donny

My database keeps telling me its locked by user: Admin and then it tells me its out of memory. The database is 120 MB is size. How do i stop this from occuring.

Mat, In your table create another field [Hit]. Enter "Hit" into the first entry. (this will serve as replicatable data) On your form - apply the followiing code to your command button "on Click" Private Sub Command5_Click() On Error GoTo Err_Command5_Click...

Thanx guys, worked perfectly, the spaces wern't a problem Donny

Mat, I would create a new table with [autonumber], [date], [time] fields to record not only how many hits but the time and date you recorded them for later reporting. All you have to do is set your Tally field control source to [autonumber]. Hope that helps Donny

I have a data field that contains alpha numeric serial numbers hyphenated like "alphanumeric - numeric". The alphanumeric side is inconsistent in characters, the numeric side is allways 7 characters. I can extract the 7 characters no worries using "right([data],7)". I need...

PaulF Your a deadset legend,thankyou, works perfectly. Donny

Than you, I dropped the code in but there appears to be a compile error. This is what i have so far, perhaps you could tell me what to modify?? Option Compare Database Dim wordobj As Word.Application On Error GoTo ErrHandler Set wordobj = GetObject(, "Word.Application")...

I need a command button that both opens word and opens the merge file i have already created. I want to avoid using macros if possible. Could someone send me the code for this.... Please