Recent content by tdubs

Oh, figure out myself.... just needed to get rid of all the indexes thanks anyways

I am trying to work it out in another way.. ColumnName would be the column I want to change - I add a column named TempColumn - Copy data from ColumnName to TempColumn - Delete ColumnName - change TempColumn's name to ColumnName The problem is that I can't delete ColumnName... it gives me the...

yeah iknow.. just that I need to do it in VBA code... thanks anyways..

Becaue I am importing an excel table to access, where all the columns are transfered as text, even the number ones...now I need to convert a couple of specific fields to number type... this is due to the sorting problem... I like to keep all my column as text to avoid the type dismatch when...

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

thanks... ill try that

The SQL Statement: Select * From Tablename was just an example.. usually my statements differ from each situation. cuz basically what i am doing is comparing two tables and see what are the differences for this one my statement is SQLStr = "SELECT " & DBNameB & "." & KFieldB & ", "...

Thanks for the replay.. tried what you said.. didnt make any difference... Thanks for help thou... any other idea?

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 ansentry, I just took a look at your autofill subform... I am wondering how can you make the subform to automattically add a row when the a hotel is added in? also, how come you can fill in other fields when you select the hotel without any coding? cuz I looked at your code and can't...

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

Thanks, I checked the libraries and my supervisors laptop's have all the libraries I have as well... Another thing I think it mite be is that when I open the program in my suspervisors laptop, access says somethinga bout blocking unsafe expressions... I tried lowering the macro security...

Hi, Thanks So much.. I used the compact on close option...It works perfectly.. the size of the file went from 44 mb to 1 mb...

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