Search results

The problem with doing the graph in Access is that it will only allow me to put in 6 fields/columns when i have well over 20. Thats why i tried to export it into Excel. [This message has been edited by Anauz (edited 05-02-2001).]

thanks Rich, using double worked

hi I have some data in a multiuser db that i want to create a graph from. What i am doiing is exporting the data in excel with some code, and manually creating the graph in excel. What i want to do is write some code in access that will create the grah automatically. I thought about creatin a...

i for got to mention that, i set the format to fixed width, and decimal places to two. But it still rounds up ie 1.79 to 2.00

Hi I have a form which works out curreny exchanges between $US and £UK. I have a field which takes the exchange rate. The problem is when i type in a decimal such as 1.79 it rounds up to 2. It there a way i can stop it from rounding up? Thanx in advance

email's on it way people *PS it worth mentioning that the code can be found in the CD that accompaines the following book: "Access 97 Developers Handbook third edition" by SYBEX

Hi I am passing some data from Access to excel, so i can create a graph. I have a macro in excel where it creates the graph automatically. What i want to do is take the macro from excel and place it as code behind the button whic exports the data to Excel. Is it possible to perform functions in...

Thanx all for the help. Rich The reason i want to create a list is because i am using Access' workgroup file to provide the security. I want admin users to be able to see which users belong to which group. The only way you can to this is to print off a list. I wanted to write code where it...

Hello I am writing a list to a text field in my form. What i want it to do is write each member in the list to a new line. What it does at the moment is write them all on a single line. Any ideas? Thanx in advance.

I had a similar problem.....here's a suggestion. I opened my form up from a btton on a MenuForm. when i loaded the form to view details i filled the dropdown box with the first name in the table ( alpabetically ) when i wanted to add new details i opend the form with a different button stating i...

yes you can create a query with the criteria... [forms]![formname]![nameoffield] Then create a form that returns the records for this query. finally insert the new form as a subform in your desired form. you will need to requery the subform every time you enter a new value using...

you may need to requery the subforms, do this in the load event of the form.

it could be that the value U are trying to sum is a string. Try converting it to an INTEGER before you do the sum. ie DIM num AS INTEGER num = field.value SUM(num) [This message has been edited by Anauz (edited 03-16-2001).]

There are two way you can do this. 1. Have the same form and change stuff come 6.00 2. Have two forms, and load them depending on what time it is. The second is probably the easiest. When you load you application have a splash screen/form which basically displays the logo and welcome...

I am running some VBA code which looks at a secutiry group to determine which user belong to which group. At the moment the results are displayed in the debug window. What i want it to do is display this in a memobox od textbox. The groups are not in a table but in Access's workgroup file. Can...

yes you can do this. Have a form for search criteria. Have a second form which runs a query based on the search criteria ([forms]!["form_name"]!["combo_box_name"]) on the second form have a button to a report which is based on the data of the second form.

tried that as well Mike DoCmd.OpenForm stDocName, , , , acFormReadOnly locks all the fields. Then I tried to unlock some fields using Forms!formname!fieldsname.locked = false it seems to ignore that code and keep the al the fields locked

thats the problem.......i don't want to write code to lock 60 or so different fields individully. I was wondering if there was a better way of doing it.

Is there a way i can group fields together and lock them via the grouping option rather that locke them individullay. I have over 60 fields and need to lock/unlock depending on the action being performed ie add/edit I can open the form in red only mode using code - DoCmd.OpenForm stDocName, ...

Hi All I am creating a security form for my db. What i want to know is can you take the value out of a txtbox, and place it in the "where" statement of embedded sql? Before anyone asks why don't i use access's security wizard.....i have and it works fine. The problem is that the db is going to...