Search results

Hi, is it possible to change the data type a field in a table using VBA code? I know how to retrieve it but don't know how to set it... I retrieve it by temp = CurrentDb.TableDefs.Item("CMAssign").Fields.Item("Chassis").Type i got temp = 19.. so to set it up i tried using...

hi all I am having problems running a recordset. Throught my program.. what I do to query data from tables I use recordsets. This is what I usually do Dim RS As DAO.Recordset Dim DB As Database Dim SQLStr As String Set DB = CurrentDb() SQLStr = "Select * From TableName" Set RS =...

hi... I have a form containing 120 subforms... the form will be loaded depending on the user... i name my subforms in sequence that is: loadA1, loadA2, loadA3,.... to load a form I just use the code: me.loadA3.sourceobject = "FormName" and then I make a counter to keep track of which forms...

Hi all, I have developed a Access program which import excel tables into the the database and queries some data and writes it into an excel file... The problem I am having is that after the program is loaded... the file size of my mdb file increase by more than 3 mb.. I tried deleting all...

Hi, I have this code to find tables already in my DB and delete them if found. When I use my program in my laptop it works peferectly when I use it in my supervisor's laptop it doesnt as it pops up a message box saying invalid argument or proccedure...... any idea on what is going on? is it a...

Hi guys Anyway to import a spreadsheet specifying the type of column to be imported I have a excel table which have several column. In one specific column 90% percent of the data are integers. and the rest are characters. But when I import the table to Access using the transferspreadsheet...

Hi guys, I am having problem with a query. I have to tables. One named wire and the other named Input. As my title says there is not unique ID for the tables to relate.. the only thing to relate is one ID where is not unique for all the rows In the Wire Table I have 3 rows using the same ID...

Hi guys Just wondering how could a make a listbox or combobox to have the names of all or some of the tables that are currently in my database I only know how to get the values from a table or query in RowSource using SQL language... but how can I display the names of the tables Thanks in...

Hi, How can I make a pagebreak in a excel spreadsheet from VBA ACCESS I recorded a macro in excel to see how is the syntax of the code.... it came out to be ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell so I change my code to xlbook.Sheets(sheetname).HPageBreak.Add but...

Hi Experts, I am writting a module program using VBA in Access, and I have serious difficulties. Objectives of the program: -To do many queries from a database - Export those queries in excel format. Some queries must be grouped in one files(i.e. putting the queries in different sheets of the...