Search results

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")...

Tried this - didn't work I'm afraid. Still gets stuck on the 184th field update.

There's no error - it just doesn't update the row...

Thanks Galaxiom - you're right I got my rows and cols mixed up - I'll refer to them as fields and records from now on. I'm very junior with vba :o. I'm guessing that the RunSQL text must have a limit because if I increase the size of each field (from 10 to 20), the max fields becomes 97 (if I...

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...

It reads a file of raw data, and populates a table of user selected columns. The raw data is mapped to an offset db which I've created so it knows which fields are in which position. It's supposed to be dynamic so that the fields / values can change without the need to recode / perform a...

Sure - thanks for the quick response. I've created sName / sPos / sLen as arrays: Dim sName(9999) Dim sPos(9999) Dim sLen(9999) Here's the full code: strSQL = "SELECT * FROM DES_Display WHERE [Display] = True;" Set dbs = CurrentDb() Set rst = dbs.OpenRecordset(strSQL) Do While Not...

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 = "'"...