Search results for query: *

Hi kenhamady, i have a similar problem. I'm have a subreport that uses the same stored-procedure as the primary report and it prompts twice. The primary report prints the details of all the individual rows of data returned, but the sub - report does a summary of totals by grouping...

Hi, I am using Access 97....is there any other way that you know of???????? Thanks

Hi there helper, I have created a login form using a query that is built during run time. When the query is run and if it does not find a record in the database, all my objects (i.e edit boxes, labels, buttons) disappear from the form. When the query does find a record in the...

I've heard of a patch that will enable a access database to run with out access '97. I.e it will create a exe type file of the database that you created and run that way. Does anyone know anything about this?? Thanks Radman

Is there anyway to save a access2000 file as a access97 file. Thanks Radman

Well then, <br><br>To create a control source in run i haven't done it, but if you look in the help files you will find it there.<br><br>if you are running Access '97 <br><br>Go the index -&gt;&nbsp;&nbsp;&nbsp;&nbsp;controls, creating then select...

Hi, <br>&nbsp;&nbsp;&nbsp;I don't know if you can add a control during run time, but if you create a control during design time and set it to ctl.Visible = False, then set it back to Visible = True during run time it will work the same way. Take note of the Name of the control<br><br><br>i.e...

hi there helper,<br><br>I have a combobox with a query as the data source. I need to be able to select the third option in the query by code and then make it appear in the text section of the combobox. So it looks like you used a mouse to select the option form the combo.<br><br>Cheers<br>Radman

Hi there helper,<br><br>Can you use an update query on a form.<br>I get an error. Someting about an action query.<br><br>How do you use an update query properly on a form.<br><br>Cheers<br>Radman

Hi there,<br><br>I have a query.<br><br>i have a count that is grouped my month, now i want to order the query so that the results appear by month, unfortunatly since i only have the month is words in the query, it sorts the month alphabetically so instead of the results appearing like...

Hi,<br>&nbsp;&nbsp;&nbsp;I am producing a graph which uses a date. On the graph i have the x-axis as the months of the year (a.k.a date). The months are extracted from the date field using <br><br>Month: Month(C.[Date Received])<br><br>The months are extracted as a number, but is there any way...

Thanks for the advice.....just to note for your self that i put the <br>DoCmd.Maximize<br>in the On Open , event proceduce an there was an error,<br>So i put it in the <br>On Activate <br>event procedure and it worked fantastic<br><br>anyway Thanks<br><br>Radman

When i preview a report, i want it to appear maximised (the window the report is within), currently the report window appears very small and it is very annoying.<br><br>Is there an option or a way in code that i can force the report window to appear maximised as much as possible????

I am trying to delete records from a table using a delete query. The user deletes the records one by one depending on the id the type in, unfortunatly once on record is delete i have to close the form and re-open it before i can delete another record.<br><br>How can i fix this to be able to use...

In code, how would i open an existing word document using&nbsp;&nbsp;a on_click event procedure for a button in access.<br><br>Thanks

After i create a report i want to export it to MS Word but it comes up with an error, <br><br>Saying that: <br>1. It can't output the data to the file i have selected an to<br>&nbsp;<br>a. Check if the file is open (which it is not)<br>b. i am using a templete (i am not)<br>c. the file isn't...

I want to add a new record to a table, but i have the user, useing a query to find the record that the want to add to.This is because i have details from other tables appearing on the screen too and the table which they are to be added to is in a sub form.&nbsp;&nbsp;&nbsp;m - 1 <br><br>i have...

I have create a query in the qbe and i have used it in a graph. I want to show the result values of each columnin in the table but i don't want any decimal values to be show in the values only whole numbers.<br><br>How can i limit this so that olyu whole numbers appear.

I have written a query to represent data on a graph. The X axis of the represent all months of the year which come from th query. The way that the months are shown is by number i,e 1,2 3 etc <br> What i want is for the months to be shown as Jan , Feb , Mar etc.<br> I am only using a select...

Can i stored the results of a select queries into a dynamic array so that later on i can use the array in another select query<br> <br> What i am trying to do is write something that is simiular to a stored proceduce.