Search results

Item 1: Missing module. When does the error occur? When the database is opened; upon execution of certain commands or opening of other forms? Something must be looking for this missing module. If you can find the reference then delete it or change it. Item 2: Read permissions. Depending...

Is it possible that having the code in both the AfterUpdate and Click events is causing the problem? The reason for putting this code into the AfterUpdate event is that you want to go to the record matching the item just selected. If the Click event fires before the AfterUpdate (which would...

Is the problem that the macro is run every time? Does it run correctly the first time, and then fail from then on? Or do you mean that it doesn't run right even the first time through? Matt

Followup Thanks for the help! It definitely put me on the right track, after a few changes... Here's what worked: Given: 1) a button named 'btn_Read_Query'; 2) a MSForms.ListBox named 'list_query', which contains a list of queries from the database; Private Sub btn_Read_Query_Click()...

Here is some suggested code straight out of a help file: Dim dbs As Database, rst As RecordSet In trying to solve another problem, I have attempted to define variables as a database several times now, and the option is not available. Am I missing something? When I type "Dim as" and...

I have tried unsuccessfully to find a way to programmatically read the sql statement of permanent queries. Is this possible? I have even tried setting a variable as an object, then looping through the objects in the querydefs collection to search for a certain query: this I can do, but the...

Can you indicate your table structure and the query you are using to build the mailing list? It sounds like you may need to provide a different field name to the label report to produce the City name instead of the linking field number. Matt

When you are in design mode you can "Insert/Object" and check the "Create from file" box. If you check the "Link" checkbox and browse to find the required document, you have now made a link to the Word file which is updated every time you load the report. Matt

OK, I feel stupid. I can figure out replication and visual basic, but charting some data is driving me crazy! 1) I create a report based on a query; 2) Insert a chart, using the wizard to choose fields, etc.; 3) In print preview I see sample data. Now the help says that this is normal, close...

I tend to think in terms of queries; the Expression is simply the Access version of "Select AS" in sql, and allows you to present not only the table's fields for the report, but any combination, calculation, or even information not associated with _any_ field. Easy to do: in query design view...

There is a considerable amount of help in Access Help files on this. Look up "About working with blank fields in queries" in Access help for examples of the "Nz" function. It should do what you want. Matt

Well, I was way off base with that answer! It should be so simple. Anyway, this may work better (use with "current" event or whichever is most appropriate): Dim varX As Variant varX = DLookup("[MaxOfWgt]", "[qryGetMax]") Me.txtMax = varX Let me know if this is wide of the mark...

With your form in design view and the unbound text box selected, bring up the properties box. On the "data" tab, control source should be "=[qryGetMax]![MaxOfWgt]". You shouldn't need the code. See if that works, Matt

Have you seen the knowledgebase article 105511? http://support.microsoft.com/default.aspx?scid=kb;en-us;105511 It may contain what you want. Matt

In Access help lookup "combine control values" and select "Combining values of fields, controls, or properties." There is an adequate definition with examples. The idea here is to create one expression which contains a combination of fields 2,3, &4. If you group your report on this...

When you say "me.subform.requery" do you mean literally? Do you put in "subform" or the name of your subform object, like "mysubform"? Here is some code that does exactly what you're looking for in my form: Private Sub cmd_Requery_Click() 'Here I rewrite the sql at runtime...

Here are some ideas. A: Capturing the filename. Let's start with your idea of using a variable. Instead of using the default dialog box, define a variable and fill it by means of a dialog box. You can make it look and act just like the default if you choose. Now simply insert the variable...

From Access help on "About working with blank fields in queries": "When a field contains no values, it contains a Null value or, for Text, Memo, or Hyperlink fields, a Null value or a zero-length string. If Null values exist in a field, they can affect the query's results. Following are some...

=([City] & " " & [State_Acronym] & ", " & Format([Zip],"!@@@@@-@@@@")) Great stuff! So now if you combine that with the "Iif" statement to get rid of the "-" when you have a short zip, you've got what you were trying for. Matt P.S. Now to handle those pesky Canadian six digit mixed...

Oops. That was a rather obvious oversight. Perhaps you could use an "iif" statement to put in a blank if the length of the zip is greater than five. So now you have: =([City] & " " & [State_Acronym] & ", " & Left([Zip], 5) & "-" & IIf(Len([Zip])>5,Right([Zip],4),"")) Matt