Search results for query: *

HI I am trying to create a form in MS word. i want to have a drop downlist that is populated (automaticly) from a table that is in the SQLDB. That form will be used everybody. I am having problem with setting my connection. here is my code so far.... ====== Dim rs As DAO.Recordset Dim str As...

HI I have a list in MS Excel looks like this ID Fname LName ContactRoleID 1 A B 1 1 A B 2 2 C D 1 3 E F 1 3 E F 2 4 G H 1 5 I J 1 5 I J 2 What i want to do is, remove...

Hi I am trying to execute a sql sp in ms excel. it seems like i am doing something wrong that i couldnt figure out. here is the code ======== Sub PutRecordsetInRange() Dim cn As ADODB.Connection Dim cd As ADODB.Command Dim rsData As ADODB.Recordset Set cn = New ADODB.Connection...

here is my code(partial) DataGrid1.AutoGenerateColumns = False Dim datagridcol As New BoundColumn datagridcol.HeaderText = " Image Name " datagridcol.DataField = "Name" DataGrid1.Columns.Add(datagridcol) Dim...

i have a button on the form with click event that opens a different access application. I have to get the variable from the first application and use it on the second one. Could you tell me how? Thanks

I have a form that has 5 frames with option boxes. before updating my table, i want to see if they select all frames or not. if they didn't, i want to show a warning msgbox with the frame name that they didn't select. Thanks in advance

Hi, i have a db on sql server, i have to have a dsn connection for Oracle Db. Could you tell me how i can do this? Thanks

Hi I have a table for each subforms object. CatTable =========== CatID CatName ParentID ParLvl FrmName 1 CatName1 0 0 2 CatName2 1 1 FrmCatName2 3 CatName3 1 1 4 CatName4 3 2 FrmCatName24 ============ I want to create a tree view...

Hi All, I need to create a SQL DB from a huge XSD I.e.have to create all tables and relations which foolow from the structure of my XML-doc. Is there any automatic tool for this purpose? Thanks in advance

I've created a reporting system in MS Access. It reports data from access to excel with formatting, calculations, chart and results. And it is saved automatically. It works like a charm. My question is, am I going to update my db system to sql server? Will I be be able to use this code in SQL...

I have a table which is importing from MS Access. That table has empty cells in it. What i want to do is fill those empty cells with "na" word automatically. I don't know how i can do this. Thanks in advance E.

i have a list box with multiselect option i want to have a select query based on the items that user selects. the problem is it works with the last seleted item not all selected items. i don't know what i am doing wrong. Thanks my code For Each varItm In ctlanalytes.ItemsSelected Debug.Print...

i have more than one queries that need to export into excel file my problem is, when i export 3rd queries results, i want to insert them in query23 (which is already exists) and start from A34 cell. here is my code DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Chart", filename...

With oExcel .Sheets("FirstEntry").Range("A1:E2").Select .Selection.Cut .Sheets("FirstEntry").Range("A10").Select .ActiveSheet.Paste .Sheets("FirstEntry").Range("A1").Select .ActiveSheet.Pictures.Insert("C:\mypicture.jpg").Select End With i have this code to move...

i have 2 tables, i want to compare them and create a new table with these 2 tables. Table1 Table2 A A B B C B! D C D! D E E E! F so my new table should like these after comparing NEW TABLE Field1 Field2 A A B...

i can not make change my chart type in VBA code could you tell me why? here is my code everything works but not my charttype Set oChart = oexcel.Charts.Add() oChart.chartType = xlXYScatter With oChart .HasTitle = True .HasLegend = False .ChartTitle.Characters.Text = "Mercury Deposition Network...

i have a select query that shows everything from 2 tables have inner join. Query Results like: tableA tableB A A1 A A2 A A3 B B4 B B5 B B6 . . . What i want to do is , i want to eliminate the first records of Table B (A1 and B4). Is there anyway...

i have a form with checkbox, combobox and 2 textboxes. i am trying to export my query results based on the form's control into excel. here is my code im frm As Form, ctl As Control Dim varItm As Variant Dim strList As String Dim rs As Recordset Dim qdf As QueryDef Dim sql As String Dim filename...

Hey I have a report with a subreport on it. When i put a page break control between two reports. I am having an extra blank pager between reports. i dont know why? Please let me know what i am doing wrong? Thanks

afte i exported my data into excel ( DoCmd.TransferSpreadsheet...). How can i set the formatting settings such as fontsize, bgcolor, fontcolor... of this excel file? Thank