When I am trying to add a subform from the tool box onto the form, I am getting an error "For loop not initialized".I am not getting the subform wizard...

hi all, I want to populate datasheet based on some search criteria in the mainform using an sql statement.I wrote a sample code for this using dummy table...

Hi , I really didn't knew where to put this suggestion as I didn't find a general suggestion/comments section. I think we can make this site more user friendly...

When I tried to set focus to the image , using Me.Image16.Setfocus, it is giving an error. It says -" Microsoft Office Access can't move the focus to the...

How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday. say for eg. a no. 3 should be formatted as Tuesday ------------- Anand Vaidya I'm here...

how do I disable/invisible the Application's main window close button because I don't want the user to close the application using this button.Rather I would...

I haven't seen this before. Main form - subform situation. ACCDB Subform has records. Right click on the record selector in the subform shows no...

I am using an combobox based on a recordset (adOpenDynamic, adLockBatchOptimistic) and populating it on FORM LOAD Set cboName.Recordset = rsTemp I make an...

I hope I can explain this. I have a form that has fields updated using a combo box. On the form, I have ID as an autonumber. When I click to create a new...

High I have an option group on a form. The option group does not reset when I move from record to record. That is, if I make a choice in one record, when...

Hi, I have problems with executing Access 2000 command "SendKeys ... " in Windows 7 environment. I get message "Run-time error '70'. Permission denied". Is...

Hi, a friend of mine supports a very simple Access 2000 database for keeping tracks of his .JPG file. The database has a table with several field, and one of...

Hi, the Format (MiTime, "Short Time") command works fine in code and returns the string "09:35" when the time is 9:35 AM. But then used in forms or in...

Hi, the function Round in Microsoft Access returns 66.22 = Round(66.225, 2), but the same function in Microsoft Excel returns 66.23. I'm really embarrassed!...

Hi, please help me. I've never done it before. How to to open an DBF file to read its data? Thanks in advance. AK

Hi, is there any ActiveControl or a driver which is could use in an Access application to read data from a USB (for instance, reading data from a bar code...

Hi, i use a form in the continues forms default view for opening a form in the single form default view to edit records in the continues forms. The problem...

Hi, what should I put in a condtional text box to make formating work when the field is equal to NULL? Thank in advance, A.Kurilin

Hi, I got no problems with producing Word documents with fixed number of bookmarks using Automation, but I've no idea how to add a variable number of lines...

Hi, I have two similar subforms connected to two different tables. Each subform has a textbox control. I have to check its contents in the event...