Search results

Based on all the treads in the Forum in ref to the OutputTo command this line should work, but it doesn't. I have the following code in a command button under the click Event: Docmd.OutputTo acOutputQuery, "NameOfQuery", acFormatXLS, "C:\Path To Document", True When I click the command button...

Inserting Single string Thanks Mike. I'm going to try it as soon as we return to work.(We are off due to Isabe) Maritza

I search the Forum and Knowledge base for this topic, but was unsuccessful. Here is the problem, I'm inserting the value of a textbox into a table. I'm doing that with the following code: Set cmdInsertCode = New ADODB.Command cmdInsertCode.ActiveConnection = cnx1...

It Works! Thanks Pat

I'm working with Access 97, windows 2000. I call a report from a form with the following code: dim strSQL as string strSql = "Select * from tblInvReports where invDate = " & "#" & dtdDate & "#" DoCmd.OpenReport "rptInvoices", acViewDesign...

Enable Routine It works! It's unbelievable. It wouldn't work with me.controls screen.activeform.controls But it works with Forms!FormName.Controls Thanks Again

Enable Routine I just tried using Screen.ActiveForms.control. I still get the same error. Also, the sub is not a private sub, and it is in the module of the form that I'm trying to modify. Any more suggestions? Thanks

Sorry, I press the wrong button, but here it goes again. The following routine works in some projects, and doesn't work others. Sub EnableText() Dim ctl as Control For each ctl in me.controls If ctl.ControlType = acTextBox with ctl ctl.enable = true end...

I have the following routine that works fine in one computer, but gives me an error in a different computer. The purpose is to enable or disable the text boxes on a screen Sub EnableText() Dim ctl as Control

the first strCon = is a typo, the strings stars strCon2 = "......."

I’m absolutely perplex, I'm using the following strings and commands to establish a connection and get recordsets; strCon = "provider = Microsoft.jet.OLEDB.4.0;Data Source=" strDBName = CurrentDB.name set cnx1 = new adodb.connection cnx1.open strCon & strDBName I also tried the following...

Is there a command, or coding that would allow you to group records by categories in a form. Similar to what we can do in the reports? Thanks

I'm currently working with Access 97 on a Windows NT enviroment on a LAN. I'm establishing a connection using the following code; dim cnx1 as ADODB.connection dim strDBName as string dim strConStr as string strDBName = CurrentDB.Name strConStr = "Provider = Microsoft.Jet.OLEDB.3.51;Data...

I have an Access 97 application developed using a 1280 X 1024 resolution. My customers are all over the world and probably have all kinds of resolutions. Does anyone know how to dynamically size the forms to fit the Screen resolution? This subject was discussed before. One of the solutions...