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 +...

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 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???

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.

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...

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...