Search results

im struggling to see this option in access 97! any other ideas to solve this. where do these random digits actually come from? because the number entered is only to 3 decimal places, so why is it transformed into one which has about 1o decimal places?!?

im using access 97? is that option available.. if so, i cant see it in the field size?

sorry to be a pain guys but ive just tried all that without any luck.. hopefully the attachements might help visualise the problem. I changes the table properties to Double and set decimals to 3. this showed all output in the datasheet to 3 decimal places which is...

Max, The field properties are currently set to Single and Auto. I have set the decimal places up in the Query properties for the field. (Fixed and 3) Im just about to try the double property in the table.

im having the same problem with all my data! although my number fields just seem to add random digits onto the end of 3 decimal placed numbers.. any ideas guys?

does this method work in access 97? because i get an error: 'Undefined function 'round' in expression' any ideaS?

Hi all, I have a data entry form where users enter figures to 3 decimal places. eg A = 1.435 B = 2.650 This gets saved as a record to a table. I then create reports based on the table. However, Ive noticed that when i run the query the system seems to add random digits on to the end of...

hi all, i am trying to build a graph from a query based on data per Week. i.e. 52 columns of data. The graph works... BUT the data table on the graph randomly misses out columns because they wont fit! is there any way to correct this? thanks in advance

I have a crosstab query which has the week number as the row heading (Week 1 to 53) The problem is that if i try to sort by Week then this is how it appears... 1 10 11 12 ... 19 2 20 21 ... and so on.. anyone knw how to fix this??

I have a combo box on a form which picks out its values from a query. im limited the selection so that the value can only be picked from the list... is there any way of editing the error message that is given when an item isnt in the list?

ive tried requerying I have a subform dependent on a combobox value on the main form. It works when i first load the form but not after

Is it possible to reload an already open form through an event. (not Timer). I need to requery a form and its subform when a combo selection is made.. Thanks in advance

anyone have any idea of how to fix this random problem?! tried importing into a new database without any luck

I'll give to give that a bash tomorrow morning. Thanks alot mate. will post up what happens..

just tried compacting and then repairing.. no luck! any other ideas? where can i view the Dr watson error log?

I get an annoying Dr Watson whever i close a particular form in my database. It only happens for one form but everytime it is closed, either thorugh coding (docmd.close) or through the X button. Does anyone have any idea on how to solve this??? Ive compiles the module and get no errors and...

I have a query which does a count of records for each particular customer for each country. (14 countries) I need a second query to ONLY take the top count for each country and show the corresponding customer. at the moment, although i can do the count and sort decending,i cant seem to make...

does anyone know how to remove the right click option when a form is running? (without making the database an mde) thanks in advance

I have a gif animation that i want to use in forms.. but when i import it remains static! anyone have any ideas?

is it possible to add an input mask to a question asked in a query? thanks in advance