Search results

This is actually a rephrase of the scenario I posted in the other thread yesterday. I have a form, titled "Danish", now i wan to make a copy of it, i.e, its textboxes, buttons and save the new form as "English". How can i perform ALL of the above in coding? Thks.. FT :)

How can i create a form programmatically? I read somewhere tat i can use the createForm function to create a form and i can also specify the template of an existing form in my DB. CreateForm( , existing_form) is the above code correct assuming existing_form exists in my DB? In addition, how...

Hi all. Below are the info tat i am providing so that u can advice me on how to solve this problem of mine. Table name = ImageTable Fields = 1. Code 2. Pic I want to pop up a MsgBox If the table is empty, i.e. there are no records in the table. How can i achieve that? Thks..

Hi all, below are my codes to display bitmaps in a MS Access form by just inserting the path to the image. Option Compare Database Private Sub CH1_Pic_AfterUpdate() On Error Resume Next Me![ImageFrame1].Picture = Me![CH1.Pic] End Sub Private Sub...

Hi all, I encountered some weird symptons with my Access forms. I am using the form to display images(done by setting the OnCurrent and After Update property). When my PC is just powered on, and i try to load say form "ENGLISH". Form "ENGLISH" will appear, but the focus will switch in between...

i am using file browser to save a file in MS ACCESS forms. However, i want another file browser to allow the user to specify the folder he wants, then from the folder he selects, i will generate a series of codes. Any advice on How can tat be done? thks FT :)

I am using VBA to open an excel spreadsheet with the comand below, Set objBook = objExcel.Workbooks.Open(tbFile) to close the workbook, i use objExcel.Workbooks.Close however, if i have 3 active windows for MS excel, it will close all 3 windows after the statement above. I onli wan MS...

Hi all, I got a very weird scenario here, i am using VBA in my MS access forms to do automation to export a table to exceln run a excel macro from MS access. however, the 1st time i open the db n run this form, it works. The 2nd time, it fails, then i need to go to VB editor n acknowledge the...

Hi all, below is a sample of my code Sub Export() Dim objExcel As Excel.Application Set objExcel = CreateObject("Excel.Application") DoCmd.OutputTo acOutputQuery, langName & " Q", acFormatXLS, tbFile, False 'export the query OpenFile (tbFile) 'using shellexecute to open tbFIle, file tat was...

Hi all, below is a sample of my code Sub Export() Dim objExcel As Excel.Application Set objExcel = CreateObject("Excel.Application") DoCmd.OutputTo acOutputQuery, langName & " Q", acFormatXLS, tbFile, False 'export the query OpenFile (tbFile) 'using shellexecute to open tbFIle, file...

Hi all, When i put my codes in the following sub, Private Sub Workbook_Open() , into my spreadsheet, the codes in this sub will be executed whenever this worksheet is loaded. However, I need to pass in an argument into this sub, isit possible to be done? Thks FT :)

Hi all, I want to open a form everytime MS Access loads this DB. Can pls guide me how it shld be done? Thks FT :)

Hi all, From my MS Access Form, i used shell command to open a file in MS Excel. however now, i want to run a macro in the MS excel file tat i have opened.. Any specific commands to execute macros? Thks FT :)

I read from VB help file that to replace question mark, "?", we enclose it in brackets since "?" is a special character. However, i tried (?) or [?] but it cant work? Anyone can help?? Thks FT:)

After exporting an EXCEL file from MS access, how can i call MS EXCEL to open up automatically and execute a macro to be run on the file tat i exported? I have done the "export" part of the codes in MS Access. I need help on how to open MS excel n run the macro.. thks.. Eg. I export test.xls...

Hi all, From MS Access, I want to export my files to MS excel. However, i want to allow the user to open up windows file browser to select the folder n filename. Any advice on how can i go about coding this? Thks FT :)

Hi all, I want to insert a picutre into my MS excel spreadsheet. However, I want to dictate the position within a cell that the picture shld appear in.. For example, i wan it to be right justified when it is inserted..Is it possible to be done? Thks FT :)

Hi all, i have got 2 questions here : 1. When i click on the dropdown list, i am able to select the listed options, but how do i DISallow the user from entering text into the combo box? I do not wan the user to edit the text in the combo box. thks.. 2. After selecting an option in the combo...

Hi all, For example u have a string tat spans the width of 1.5 Cell, (e.g. cell A & B). In some circumstances, the string will be chopped off at the length of cell A, tat means, certain words are hidden behind cell B. However, at other instances, the entire 1.5 length of the string can be seen...

Hi all, I am using a combo box in my form and its row source is set to Table A, however, the data in the combo box arent displayed in alphabetical order even though the data from Table A is sorted in ascending order. can pls help me by teaching me How to display "row source" in combo box in...