Recent content by boats02

Morning all: I need some help with a query. This one has me rather stuck. Background: I have a chart embedded in the footer of a report. Obviously, the chart needs a query to run on. I have a basic query that works fine as it is. The problem comes in when I try to add criteria to the query...

You may also need to add a reference to the DAO library in the Visual Basic Editor. 1. Enter the VB Editor. 2. Tools Menu and select "References" 3. Scroll down the list box and select "Microsoft DAO 3.51 Object Library" 4. Click "ok". Now Access should recognize the DAO keyword.

What version of VB are you using? I had the exact same problem. I updated to Visual Studio Service Pack 5. That fixed the problem. It basically occurs because the databound control is only set for Access97 Jet. Access 2000 uses a new version. Installing the service pack will give you a new...

I frequently create a criteria form using the date picker control. I set a command button that opens the main form and also sets the filter property of the main form. frmMainForm.Filter = "[Date] between " & frmCrieriaForm.startdate.value & " and " & frmCriteriaForm.enddate.value Hope this...

I'm looking for the same thing. In VB 6.0 you have access to ActiveX timer controls. I'm trying to find one that works with Access that doesn't cost alot of money. If your pockets are deeper than mine, there is a company that offers some pretty nice ActiveX controls (including a timer) at...

Has anyone ever added an ActiveX timer control to an Access form? If so, where did you get the timer control from. What's the name? I've used the built in form, but I'm looking for another timer to use other than the forms default one. Thanks in advance. Brian [This message has been edited...

Does anyone know of any really useful ActiveX controls for use with Access? I've been playing with some ActiveX and am wondering if anyone has used them in unique or really useful ways? Thanks in advance. Brian

Just a little background on my project. I have designed an access database that records new sales for all the sales reps in our department. I've had a monitor installed high on the wall so that everyone can see it. I want a separate Access DB (with linked tables to the sales log) to rotate...

Try adding a reference to the "Microsoft DAO 3.51 Object Library"... 1. Enter the VB editor. 2. To to the "Tools" menu 3. Select "References" 4. Scroll down the list until you see "Microsoft DAO 3.51 Object Library". 5. Check the checkbox. 6. Press ok. 7. now type the "Dim rst as DAO.recordset"...

Opps, I should mention that this would be done while all forms are currently closed. That is to say, there aren't any forms in the forms collection. I tried opening all forms first and then cycling with: For each Form in Forms The application hangs because each form takes up so much memory and...

Good Afternoon: I am trying to write a module that will open all forms one at a time and keep each open for 60 seconds before moving to the next form. The code should be dynamic and automaticlly open each form, no matter how many forms are in the database. The end result would be something...

To look at this results of my current query in datasheet view, you would think that it is a crosstab query. However, in reality, it's 7 different sub-queries that are brought together in the current query. Each sub-query returns the subscription that the customer had for a given month. Thus...

Thank you for taking the time to reply. In your example, the query will concatenate different fields into one field. What I really need is to concatenate different records into one record. This would be similar to a crosstab query except that I would need to muliple column headers and Access...

Good evening: I have an Access query that lists customer subscriptions to our products for the current month and the 7 preceeding months (One column for each month). A customer can subscribe to more than one product, therefore the subscriptions are listed multiple times each month. (one record...