Search results for query: *

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

I need access to recognise an equasion entered into a form field. I have pricing structures, some of which are straight prices, others are calculations such as (0.00736-0.0040)* [ other field ]. I need to use these fields in quiries to make calculations. Users will enter these equasions...

I want to run a query that selects everything accept a value i place in the criteria. I know its basic, put it down to writers block. What is the SQL

I have a form with a subform and a macro button that displays a report with only the current forms data. However when the report opens i want to ask the user to enter a start date to limit the data again by the date field on the subform. Could someone tell me what the [event procedure] would be...

Trying to get historical data into my database. I have 2000 files with identical structure. The files are all in the same directory with the same .txt extension and alpha numeric file names (non sequential). I want to automate the importation of all these files into the one table - how do i do...