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

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

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

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?

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.

I have a number of fields in a table that contain values ranging from 1-5. What I need to do is count the number of times each value is used in each field. I can do it for one field in a totals query by putting the field in twice and setting one field as "count" and the other as "group by."...

I am working on a job evaluation db. I have a bunch of rating for which the values are drawn from a repeated scale. I.e. Rate this guy's work: Good Fair Bad Rate this guy's punctuality: Good Fair Bad I'm sure you get the picture. I am collecting those values using an option group and...

Does anyone know the VBA code that will expand a text box on a form. I know you can do it by hitting Shift+F2, but I would like to have my users do it on a double-click event. I have seen it done in a sample db I downloaded, but can't find the db. Thanks, Neal

I have a report built off a table with multiple yes/no fields. I need to list only those fields with a yes value. For example, there maybe six colors a car comes in, but only three are available. I only want to list those three on the report. Does anyone know how to do this? Thanks Neal

Can anyone give me the code to open an an existing Excel Workbook from Access. I have tried Getobject following the help file instructions, but all that happens is Excel opens briefly, then closes. Thanks, Neal