Search results

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

Sorry, Can you direct me to that import data screen? Cuz I don't seem to find it... and could that be done by code or the option stays there when i save the file??? thaaaanks

Ic how can i do that.. like setting it up to be imported as text

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

IC. What I did was making a Value list for the Combo Box mmm for you method.. I tried using it.. In Rowsource type i put Query/table in Rowsource i put MsysObjects But when I expanded my combobox, There seems to be something there but it was all blank. But anyhow Thanks for the Help