Search results

I am trying to build an application that exports a datagridview to excel. That bit's easy, but I wanted a 'please wait with animated gif' to display whilst it does. After a lot of trying different things, I eventually got that to work by wrapping the thread in a class. However, I would now...

I have a process in VB.net that writes out an XML file. However, I am unable to format the font. Does anyone know how to update the font to ‘courier new’? I have tried adding: fs.WriteLine(" <ss:Font FontName=""Courier New"" ss:size=""10"" ss:Bold=""1""/>") to my code, but it doesn’t seem to...

I have a process that writes an XML file, and when I open this file in Excel, it opens as expected. However, I cannot get the font to format. Can anyone help? This works: <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <ss:Workbook xmlns:ss="urn:schemas-microsoft-com...

I am successfully updating the properties of an access database column, but if I try to update the same properties of another table immediately after, I get erratic results. Sometimes the result says 'Record deleted'; sometimes the result says 'cannot append. an object with that name already...

I am new to Access SQL and wondered if it is possible to summarise / count by field? e.g. If I have a table as follows: Post_Cd Status Type 1234 A1 Z 1234 A1 Y 1234 A1 Z 1234 A1 Z 1234 A2 Z 1234 A2 Y 1234 A1 Y...

Does anyone know how I can update the column properties in Access from VB.NET? I am trying to make the column a check-box after I create the column. Here is my code: con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Test.accdb;Persist Security Info=False;" sql =...

Does anyone know how to update a textbox value on an Access form from VB.NET? Dim oAccess As New Access.Application oAccess.OpenCurrentDatabase(filepath:="C:\TestDB.accde", Exclusive:=True) oAccess.Visible = False...

Hi, In my VB.Net form, I'm reading a text file with thousands of lines of data. For somer reason, on just a few of the lines, there is some data missing. When I check the immediate window for the 'bad' records, and display the text line, it only shows the first 72 characters. If I then do a...

Does anyone know how to centre-align a field in a table using VBA?

Does anyone know how I can set the font name and size in VBA? This doesn't seem to work: Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim DB As Database Set DB = CurrentDb Set tdf = DB.TableDefs("TableTest") Set fld = tdf.Fields("Field1")...

Can anyone tell me if the RunSQL command has a limit? I have created a process to add a number of columns to a table, with each row of each table having an entry of '1234567980'. The process works when I set the rows to 183. But when I set this to 184, the process doesn't load the data into...

I'm pretty new to VB, so don't know what's causing my current issue. I have successfully created a process to dynamically add field-names and their values to a table by looping through a text file: For i = 1 To sMax If i = 1 Then sFldRpt = "[" & sName(i) & "]" sValRpt = "'"...