Search results

The following code works fine because I explicitly reference "[Forms]![Main Page]![Program]" strSQL = "SELECT * INTO " & strUserTableName & " FROM [Current] WHERE [Program] = '" & [Forms]![Main Page]![Program] & "'" The PROBLEM is that I actually want to define a make-table query based on my...

Hi, I'm exporting the recordSource of a form to Excel. The recordsource itself is a query but I'd like it to remain unchanged the whole time I have the form open (so that it mirrors the data that I export to excel). So ideally I would like to be able to create a table based on the...

Hi all, I am now in the practise of placing all of my public functions where possible in a separate module but if you wanted, could you declare public functions within a particular form (I realise that the form would probably have to be open when calling the function)? It doesn't seem to work...

Hi, The following works for me: strSQL = "SELECT * FROM [" & Me.RecordSource & "]" but when I try to select certain fields from the recordSource, it doesn't seem to work. This is one of my failed attempts: strSQL = "SELECT [" & Me.RecordSource.[ID Number] & "],[" &...

Hi, I have a form "EXPORT FORM" that displays individual records and some statistics regarding them. On the same form, I also have an unbound object which is linked to a Microsoft Excel Chart. I have my own 'next record' and 'previous record' buttons. When either of these are pressed, I open...

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

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

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

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

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

HELP: "Table 'TempMSysAccessObjects' already exists." Have been getting this message when closing my database recently and am a little worried about it. Anybody know what causes this and how I can fix it? Also, in the directory where my database is stored, other copies seem to keep appearing...

Hi, I can only find ways to change the background colour of whole controls or selections. What I would like however, is to highlight individual records displayed in the same listbox (to represent priority). Is this possible? Thanks, Joshua

When I create a button using the wizard, the VBA code always enters error handling data in there. What sorts of errors does this catch? Should I do this when I make my own modules and code for buttons? Can I manipulate this functionality to handle my own defined errors?

What sort of things cause a database to need to be "repaired" and how can I prevent this in the first place?

Hi, Just recently set up a database for multiple simultaneous users and I'm having trouble with a few bugs. I would like to be able to obtain user information from the "Microsoft Access Record-Locking Information" file so that I can ask those users to quit the program while I make design...

Database size issues (also queries vs filters) Hi, On one form of my database, I use around 50 different queries. These handle searches displayed in about 8 different text boxes on the same form depending on my search options. I was told that queries were better to use than filters because...

Hi, I am using a text box on my form and I was wondering if anybody knows how I can cause the 'Enter' key to start a new line in the textbox instead of moving to the next field? Also, I use list boxes for most of my fields so that the user can't make mistakes in their selections...

I have a public function declared in the module for one form public sub a() Do Stuff end sub The problem is that I don't know how to call that (and possibly declare it) correctly from another form's module. call a() doesn't seem to work... Can anybody tell me where I've gone wrong...

Hi, Just trying to use SendObject to send email notification of changes to certain users within our company. The generic email format at the company for internal is "I-LastName, FirstName". Unfortunately, Microsoft Access recognises a comma as a semicolon in the "TO" argument for SendObject...