Search results

Hi all, I have an ASP page coming up with this error whenever it runs "Jet Database Engine Error 80004005: ODBC Connection to Oracle Failed" The ASP itself draws off from a query in Microsoft Access, which draws data off a Oracle database. The reason for this is I needed to put information...

I would personally use recordsets. Even though they have a couple additional layers to them (eg defining varibles), they are quicker than DCount and when you start using them with Forms, are a lot more versatile and more powerful.

I presume you are firing the macro off on the on_Click event of a button? If so what I would suggest is modify the code for the on click event to something like this Open a recordset against the query of the report If the recordsets RecordCount > 0 then open the report and perform update...

What you do is create a bookmark in the document, then using VBA on Access side you can open up that document, find the bookmark and insert the data you want.

The only thing I can suggest is that you create a sample output, with how you want the layouts and the text, then split it into static data and what the database will hold. Then you can decide how to progress from there. When doing reports, I always find easy to do it that way, then I can...

Try this: SELECT DISTINCT Cashier_Name FROM Reasons INNER JOIN (Cashiers INNER JOIN Adjustments ON Cashiers.Cashier_Number = Adjustments.Cashier) ON Reasons.Reason = Adjustments.Reason WHERE No_Fault=Yes AND Warehouse=6 GROUP BY Cashier_Name ORDER BY Cashier_Name;

Hi, I've had a database working for quite a while, but we have moved over to a new IT system run by an external contractor. Since moving over, its stopped us using the Publish to Word function, but can't figure out why. The error that is comes up with is displayed in the attached image. Any...

Ok, sorted it out, I was using a javascript and vbscript in the same page, so had to force it to javascript onMouseOver="javascript:form_name.field_name.value='data to insert';form_name.field_name.value='data to insert'" etc

Debbie, What is idname? Is it an autonumber? I can't see how you are assigning a value to it. Message me and I can help you out. Velosai

Sounds like you have a relative path in your connection to the database, needs to be an absolute path

You will need to do it as two separate SQLs, doing the child table first

Yes have a look at http://www.databasedev.co.uk/sql-basics.html

Use somthing like this intCount = 0 Do While not rskg2.EOF intCount = intCount +1 If intCount >2 then <TR> End If <TD>Plug Data in</TD> If intCount > 2 then </TR> intCount = 0 End If rskg2.MoveNext Loop

Its ok, sorted it, in a roundabout way.

Hi, Need some help, creating an ASP page (creating a gant chart), with fields to show more information on the gant they have the mouse over. My code so far for the event is onMouseOver="form_name.field_name.value='data to insert';form_name.field_name.value='data to insert'" etc However, its...

Has anyone any experience with creating word documents containing graphs, from an ASP Application? Currently building an application that needs to do this, but have no experience. A point in the right direction would be greatly appreicated.

Thats the thing, the query doesn't exist....

I currently have a front-end/back-end database, but at some point in time one of the tables has been modified and whenever the front end connects it comes up with a parameter request for a field that no longer exists. I have narrowed it down to MSysQueries, where there is a reference to this...

Are you looking for a duration in days, hours, minutes?

If you create two command buttons, on the save one, you just close the form normally or whatever you wish to do, then on the other one, you use DoCmd.SendKeys {Esc}{Esc} then it will cancel the changes carried out on that record.