Search results

I instaled dao 2.5 compatablility and I get a different error now: Variable Not Defined On Set myConn = CurrentProject.Connection with CurrentProject being highlighted.

I have the following references checked in this order:' Visual Basic for Applicatinos Microsoft Access 8.0 Object Library Microsoft DAO 3.51 Object Library

Here is my current code Dim PurchSpecialHandling As String Dim dbTemp As DAO.Database Dim rsTemp As DAO.Recordset Dim sTable As String Dim CurrentProject Dim myConn sTable = "InventoryMaster1" 'table name Set myConn = CurrentProject.Connection Dim Part As...

Using access 97 btw

On this line of code: Dim rsTemp As ADODB.Recordset I receive the following error: User-defined type not defined How do I go about fixing it?

I wish to display a message box, only if a query returns results. I would have it on the OlLoad portion of my form. The problem I am having is doing the sql in the vba portion of the code...it would look something like this: sql = "select * from table" if results of sql are not blank, then...

I figured out the code...thanks for pointing me in the right direction. Below is the code I used: Dim PurchSpecialHandling As String If IsNull(DLookup("PurchSpecialHandling", "InventoryMaster1", "[Part #]='" & (Forms!PreRequisitionBuysMasterForm1!Part) & "'")) Then PurchSpecialHandling =...

I get a variable not defined error when trying to do the code...here is what I have: Dim PurchSpecialHandling PurchSpecialHandling = DLookup("PurchSpecialHandling", "InventoryMaster1", "Part='" & PreRequisitionBuysMasterForm1.Part# & "'") It points to PreRequisitionBuysMasterForm1 for the error

I would like to display a pop-up message on a form when a specific field has been changed. I know how to add teh pop up message for that section; however, I would like the pop-up message to display data from a sql statement. Here is the sql: select PurchSpecialHandling FROM InventoryMaster1...

Does any version of Access have the ability to automatically generate PDF files from a report and then email them? If it doesn't, does anyone know how I could do this? Thanks!

I have a simple macro set up to send an email in Access. It sends a word doc via email. The To: field is blank so the user can enter in the address. When they run the macro, they get the following error message: I put in a To: field and it works. However, we do not want our users editing...

I got it figured out witht the following code: Dim stAppName As String Dim strPO As String stAppName = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://mydomain.com?PO=" strPO = PONumber.Value stAppName = stAppName & strPO Call Shell(stAppName, 1)

I have it so the form loads a web page upon opening; however, I need to send it information..here is what I have: Dim stAppName As String stAppName = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://www.mydomain.com?PO=" Call Shell(stAppName, 1) I need to add at the end of...

I have a form that displays data based on a simple query. The query asks for a PO number (from the query) and then displays the data. I wish to open a web page after the PO number is put in. What is the vb code to do so and is it on the onLoad or onOpen portion of the form? Also, the web...

I figured it to be a permissions problem..thanks!

I have a link to http://localhost/ which causes an error when trying to go to the page...the error is: Unable to open http://localhost/. Cannot download the informtion you requested. Does anyone know why this is? It works if I place other hyperlinks there...I have tried the local host also...

I found a solution... Application.FollowHyperlink "Http://www.google.com" thanks!

On my form, the user clicks submit at which point in time the form closes. I would like then to have a specefic html page automatically open up in IE...so, it needs to start IE, and then to go a web site. shell "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://www.google.com" that code...

that code still produces my database to fail...I have a workaround which works perfectly for this database, and, the queries are used later on in other applications..so I'm going to stick with that. Thanks though :)

I have made a workaround for this that works great...one of hte values was a primary key, so I just stored that and ran an update query afterwareds...thanks!