Search results

I have been unable to either link to or import Excel files anymore. The ones I already have linked to work fine. I just can't add any. When I select the file using the wizard, nothing happens. I don't have a problem linking to or importing an Access table. Anyone have any ideas? Thanks, Neal

Group/Top Values I solved my problem by removing the PhoneID field. Although it is a text field, it is populated only by numbers, which were throwing off the Top N process. I will take a look at the sample reports database mentioned on the Microsoft page. I expect I will use it down the...

No, that won't do it That returns the top 10 for all of the billing dates. I need the top ten for Jan., Feb., March, etc.

I am trying to build a query that returns the top ten costs for separate billing cycles. I have tried two approaches: one discussed on this forum and in the MS Knowledge base, and another I got from another Access site. I can't get either to work. Does anyone know why: Approach 1: SELECT...

All, I have saved a report as an Access Data Page and have exported the data to XML. I have two problems: I get an error message saying the "recordset GroupLevel0 does not contain records" if the report is grouped. When I remove the grouping, a field that contains a date/time value returns...

It Worked! Thanks very much. I had referenced DAO 3.5, but it had a lower priority. I can't believe something like that would cause such a problem. Neal

Hi, I am having a problem with recordsets. When using this code: Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("combined") I get a type mismatch error message. (Combined is a table name). Can anyone tell me why? Thanks, Neal

Yes, Pat, that does the trick.

The nice thing about Access is that you don't need to know DB fundamentals. The bad thing about Access is that you don't need to know DB fundamentals. How do I populate an array with data from a table? Say my table has three fields: Name, Date and Time. How do I put that information in the array?

Fornatian, You're great! I was about to pull my hair out, and none of our office VBA experts were able to help. Thanks, Neal

I need to use a variable to set the focus on one of a dozen fields. I have a user input form with a textbox (txtField) on it where the number of the field (the field names are all numbers) is entered. The code behind the after update event of txtField is: Dim intField as Integer Dim...

Does anyone know of a way to make a new record appear at the top of a continuous form? I have set the record numbers to sort descending, but when I want to start a new record, I always drop to the bottom of the recordset.

Yes, the where condition has to provide the second form with infomation on what record to open. If the relevant field is ID, your where clause would be (in quotes)" "[ID] = forms!YourFirstFormName!ID" That says the ID of the record in the second form has to match the ID of the record in the...

Could you put your code behind the On Format or On Print event of the report header or details section? Those events occur after On Open and -- hopefully -- after your argument is available.

You can put a command button on the form and have this as the code behind the On Click Event: Docmd.OpenReport "YourReportName",,,"[RecordId] = forms!YourFormName!RecordID"

Have you tried using a subform? Link the main form to one table and the subform to another table. The parent/child relationship would be the field in each table that establishes the relationship.

On the On Open event of the form you can write this code: YourControlName.SetFocus

Put the start and end dates as text boxes on a form. Use a command button to open the charts, and use the text boxes as criteria in the queries that provide the data for the charts. Each time the dates are needed, they will be plucked from the form.

I have used a convoluted method to do something similar with a Word document. I output the report as rft, open the file in Word and execute a macro that copies the text into clipboard. Then I close the file and Word, open Outlook and use SendKeys to paste the text into the body. I suspect you...

Your first method should have worked. I would have had combo1 showing me the ProviderNames and combo2 the site names. Combo2's record source would be the query. The query would have the two fields and the criteria for ProviderName would be: forms!YourForm!combo1 The Afterupdate event for...