Search results

Hi, I create an Excel file using "DoCmd.OutputTo". I use that file to create a graph in Excel and display it in a form using an unbound Microsoft Excel Chart object. I have 2 questions in regard to this: 1. I can't seem to open the file properly outside of Access. The menu/toolbars for...

I'm dragging values which represent the keyID of records in one of my tables.

Is it possible to drag items displayed in one control to be displayed in another? I assume I'd use MouseDown and MouseUp events but I don't know if it's possible to determine whether the cursor is located above a particular control when these events occur. Is this a ridiculous notion for...

I've decided just to open a new form with a filter to display just the current record on the old form and export the data from there. I'd still like to know if I can place an object on my old form that exports the data as explained to excel, allows me to perform my macros in excel to create a...

Ok simple answer. Somebody in another forum pointed it out: "Go to Tools->Options, then the View tab and unselect 'Windows in Tasbar'" Thanks for your help Ghudson. Sorry I didn't explain myself properly! :) Joshua

Hi Ghudson, I've actually hidden all tool and menu bars. The icon for the "User Look-up" form is showing up on the Windows taskbar along with a separate icon for my "Main" form. It is only occurring with this new form that I have added and is not an issue with any of my other forms for some...

Is there a way to just export one record without using a query?

Hi, I have a "Main Page" form which opens up due to my "Autoexec" macro. Then every time I open another form from here, the form opens but doesn't have an extra icon on the windows startup toolbar associated with it (hope that makes sense!). THis is great. It is exactly what I want. The...

Hi all, I tried inserting a chart into a form in my Access database to display some data but just can't seem to make it do what I want to. Basically, I have 8 fields (representing the total time an object spends in a particular location). All I want to do is show this data on a bar chart (one...

Actually, figured it out. Am now using 'expression' in conditional formatting now that I know how to reference subforms: [Forms]![Form Name]![Subform Name]![Control Name]

Thanks, I also realised I was using 'datasheet' view instead of 'continuous form' which removed the annoying left margin taking up space in the control. I still can't make the highlighting do what I want though. I have a form referencing a table with the following fields: 'Job Number'...

Hi, I am hoping to use continous subforms instead of some listboxes to display a few sets of data on a form. Some things that I was wondering however are: 1) Is it possible to remove the title of the displayed field(s) (and if so, how)? 2) Is it possible to remove the record selection buttons...

Ok sorry that was a stupid question - just needed to change my startup options again. Is there a way to import all of my options (including startup) when I import my objects?

Hi, Somebody recently suggested that rather than using 'compact and repair', that every once in a while I should import my objects into a new Access file. I'm not sure if that relates to my new problem but it has been occurring since I did so. I have set up an 'autoexec' macro which opens and...

One suggestion I have seen was to make the listbox background colour transparent and have other listboxes (the size of a single entry) highlighted depending on conditions with the main listbox as the top object (or that's what it seemed like they were suggesting). That seems fine except that...

Again, nothing really telling me how to make a continuous form as opposed to a "normal" form. These messages are the closest to helping me do what I want but it only seems to suggest that it is possible rather than telling me how...

Sweet. That's fixed it. Thanks guys!

Sorry, the help function in Access tells me about conditional formatting but only for controls or selections rather than individual records. "Continuous forms" or "continuous" doesn't seem to yield anything useful in Access Help either. What IS a continuous form as opposed to the normal form...

Thanks for that. I do have quite a few database objects though. Is there anyway to automate this (other than "compact and repair"!)? I don't mind so much the copying and pasting but the fact that I have to type the name of the table/query/form, in the new database means I risk mis-typing...

Plus what might actually be causing the compaction to fail?