| Thread | Last Post | Replies |
|
| ADD method syntax for collections | 21 Apr 2008 19:58 GMT | 2 |
If through ignorance of group netiqette I cause offence, I apologise, and ask you to calmly point out my mistake. I barely understand email, let alone newsgroups. I'm hoping to get advice about writing a line of code to Add a member to a
|
| Today's date in Pop-up calanedar | 21 Apr 2008 18:44 GMT | 9 |
I have a few pop up calendars and I would like it to default to todays date. Here is my code: Private Sub duedate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
|
| Call Dialog box for Import (and errors) | 21 Apr 2008 18:13 GMT | 1 |
I've managed to use this script to call the import dialog box to navigate to the file to import with the associated import spec. However, occassionally there will be import errors that will need ammending at source and the import process to be re-run. How after running this ...
|
| Checking for Empty Table | 21 Apr 2008 18:05 GMT | 3 |
I have a form that is a continuous form and occasionally the table that the forms data comes from is empty. I have code in the Form_Load procedure that is executed and causes an error because there is no data in the table. Is there a way to test for the absence of data before I ...
|
| Issue with UNC Path (I think). Trying to build Dynamic Report | 21 Apr 2008 17:59 GMT | 11 |
Issue with UNC Path (I think). Trying to build Dynamic Report, using SQL Just recently I encountered a problem that I’ve never dealt with before. I think it has to do with something called UNC Path. If you are not frightened at this point, please read on…
|
| access option group value | 21 Apr 2008 16:53 GMT | 1 |
I have a group option on the form and would like to have a case statement to excute the code depends on user option selected. The frame only has default value which does not change. Are there any property to access option value or I have to use if statement
|
| combo box not updated | 21 Apr 2008 16:40 GMT | 2 |
i have a combo box on my form. the combo box allow user to select a customer from a list of customers. the data of the selected customer is then displayed on the form by some code in the combo box's afterupdate() event. the combox box's gotfocus() event set the combo box row ...
|
| Code dependant on if a form is open or closed | 21 Apr 2008 16:03 GMT | 3 |
I have 2 forms (frm_1 & frm_2). After I click on a command button I want frm_1 to close ONLY IF frm_2 is open. If frm_2 is not open then I want frm_1 not to close. What code could I use to accomplish this?
|
| Take Highest Value in record ID | 21 Apr 2008 16:00 GMT | 4 |
|
| Requery Combo Boxes on a Continuos SubForm | 21 Apr 2008 15:57 GMT | 2 |
I have a continuos SubForm that contains dependent combo boxes on each row. For some reason, the combo boxes show blank values when records are changed, mainly after a "NotInList" event successfully finishes on any of the combo controls.
|
| coding questions | 21 Apr 2008 15:44 GMT | 6 |
I have written some code for end users that when they click a command button on a form a msgbox appears. If the user clicks yes, then my code works fine and runs through all the lines perfectly. But if the user clicks "NO" I want the code to open a table up so the user can ...
|
| Apostrophes in search strings | 21 Apr 2008 13:47 GMT | 5 |
I have an SQL statement which I build as follows: strSQL = "UPDATE tblDesign " & _ "SET " & strFieldNameForUpdate & " = '" & strDM & "' " & _ "WHERE DesignName = '" & strName & "' ;"
|
| Access automation not releasing Excel | 21 Apr 2008 13:29 GMT | 5 |
I've seen other posts and have been working through them to resolve my problem. The following code (I've cut some of the fluff) works to loop through sheets of an Excel workbook and import the data into an Access database. But will not release Excel. Any help would be greatly ...
|
| MDE doesn't like module (can't be created) | 21 Apr 2008 08:39 GMT | 16 |
Hello Newsgroup, I got this wonderful code (below) from the internet to refresh links to a front end database. It in one module in my mdb. Its works perfect BUT I can't create a mde-file with this module in
|
| closing all forms | 21 Apr 2008 02:41 GMT | 2 |
My Main Menu form has an Exit button with the following code: Private Sub cmdExit_Click() CloseCurrentDatabase End Sub
|