Recent content by clerics

To cutun1217: please dont post the same topic in this forum ! :( There re a lot of people who had answered you already. :(

to correct you at this i suggest : StrSQL = " Select " & Forms!UserInput.combobox1 & ", " & Forms!UserInput.combobox2 & " From Project" But this one "strSQL is SQL code (you must change it to query by CreateQueryDef() Or create a new query that have the same SQL What i mean is you should...

Add Microsoft DAO Libabry to Reference After click on button StoreBackup make An Onclick_Event and type this code . (This code below help you to copy one Table to another one) '***** Create new table***** Dim db As Database, tbl As TableDef Set db = CurrentDb() Set tbl =...

let Append it : Dim db As Database, tbl As TableDef Set db = CurrentDb() Set tbl = db.CreateTableDef("Newtable") tbl.SourceTableName = "table 's name" db.TableDefs.Append tbl db.TableDefs.Refresh

i dont know what you re trying to do but it would be easier if you just use only one subform and update your Subform's database base on what user want to see where user click on Main form (Cobobox or anything in main Form) Something like : Dim strSQL as String strSQL = "Select a,b,c From...

your code must be Dim strSQL as String StrSQL = " Select " & Forms!UserInput.combobox1 & ", " & Forms!UserInput.combobox2 & " From Project" But make sure combobox1 's data_type is set as text ! Export to excel this an example 's code (there re more complex ways but this one is simple)...

make a query or SQL code or anything you like that can show info where Table.infoID = Listbox.infoID then type this code in Double_click Event Me.Listbox.RowSource = "Query 's name" //(or SQL code) Remember that set your number of Listbox's column again (example Me.Listbox.ColumnCount = 5 )...

this is a sample for you ! Try to take a look ! :D http://www.access-programmers.co.uk/forums/showthread.php?t=100365

If i dont misunderstand (cuz my english is so so )You mean this ??? Dim MyDouble, MyString MyDouble = 437.324 ' MyDouble is number type MyString = CStr(MyDouble) ' MyString --> "437.324"

may be you lack Main Form 's Name it 'll be right if it likes: Between [Forms]![MainFormName]![sub_fltStart]![DateList_Start] And [Forms]![MainFormName]![sub_fltEnd]![DateList_Start] But make sure both of 2 forms re opening !

The same problem you r getting is here ! Try to take a look at this link -> i hope it can help you anyway ! http://www.access-programmers.co.uk/forums/showthread.php?t=110444 Goodluck :D

Use query or SQL to solve your problem . Something like this strSql = "INSERT INTO YourTBL (Firma,Factuurnummer,maand,Soort,Transport,Product)" & _ " SELECT [Forms]![YourFormName]![Firma] AS S1,[Forms]![YourFormName]![Factuurnummer] AS S2,[Forms]![YourFormName]![maand] AS...

The easiest way is Searching... Let search about calendar you will see your answer .It very simple if you try to use calendar to set time :D Goodluck this is sample link http://www.access-programmers.co.uk/forums/showthread.php?t=103747&highlight=calendar

Let see this code ! may be it helps you anyway :D *Add this code below to Combo1 's AfterUpdate_Event Me.Combo1.RowSource= " Select Bonds.ID,Bonds.Name from Bonds" Combo1 (Event_afterupdate): Dim strSQL as String strSQL=" Select Downtape.ID,Downtape.Name from Downtape where ((Downtape.ID) =...

Acording what you wrote --> with each Index , there 's only one note .So you can not show multinote like you wanted . I think you should make 1 more table to store note --> (this is what you want to try) and show it by ListBox or Combobox not by textbox (impossible with multi rows)