Search results

whenever the user imports a file, i wan the form to be autocreated...

Thks Col, but I need to perform the above in VBA coding... Everything should be done by the click of a command button...

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 :)

Hi, Bascially, I am done with my "Language" database, however, should the user wan to define a new LAnguage in my DB, i need to have a new form for it, tats y i need to make a copy of the form. Everything has to be done in coding, tats the requirement tat i have from my supervisor. So ur...

hi robert, thks for your reply. However, i do encounter a few problems Set frm = CreateForm(, "existing_form") If the name of my form is English, i just use Set frm = CreateForm(, "English") Am i correct? In any case, onli a BLANK form pops up in design view and i am required to REDESIGN...

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

okies, thks. i will try it out

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

thks larry, but will the changes affect all my programs? i am actually looking at a solution within MS acess..

i tried to hide the "import" window by setting focus to the form, however, it doesnt work.. anyone else w a better suggestion? thks FT :)

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

thks robert, i got the solution.. When i did the form in MS ACCESS 2002, i enetered the codes into the onCurrent n AfterUpdate () based on the fact tat it is version 2002.. for MS 2000, a different set of codes need to be used.. thks

one thing to add, when i perform the above in MS Access 2002 SP-1, i do not get any problems.. The error onli occur when i open the form in MS Access 2000 SP-3

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

thks..i will take a look

thks, i found the solution.. to close onli the active work book, use activeworkbook.close.. thks

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

got it, thks :)

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