Search results for query: *

G'day Jordon502, Thanks for more perspective on the problem. As far as I can tell, no version of MS-Visual Basic apart from the Acess VBA editor was ever installed on the work PC I was using. So I don't really know how or where the comdlg32.ocx control came be on the work PC I inherited in the...

I haven't heard of commit or rollback before. The current method I am trying is to make two copies of the form - one devoted to browsing the records, and one devoted to adding/editting records, and flip between them via buttons. That way I don't have to worry about changing record and control...

I suspect what you want to do is put a call to some sub-routine, call it say CalculateCost, in both the Change event handler for each comb-box. Put in some error checking to see if a valid value has been selected in each comb-box. If valid values selected, then do your calculation in your...

Somewhere in my fiddling with the code I half solved the problem. I can now successfully Save the new record. However, I still can't successfully "Not Save" the new record and go back to browse mode. However, because I was doing much of my testing by going through the "Not Save" section of my...

There is probably an easier, or at least more elegant way to do this, but my first thought is: Dim nFalse as Integer Dim strSql as String Dim myDB As DAO.Database Dim myRST As DAO.Recordset Set myDB = whatever strSql = "SELECT yes/no field FROM table" Set myRST = myDB.OpenRecordset(strSql...

Sorry Dr Simon, I don't really understand this advice Most of the DataType properties are text, with one Date and a couple of Numbers that all Bind to textboxes, and a couple of Booleans that Bind to check boxes. Besides, what does that matter in the case when I set the Form.RecordSource = ""...

Addenda to the above problem. I have no problem going from the browse data mode with the huge SELECT statement to the add record mode with the simple SQL statement However, whatever I change the RecordSource to after the Add record phase causes the error. Even if I change the RecordSource to

Hello, Over the last two days an error has developed in the Access 2003 application I am developing. I can't seem to get rid of it, or work my way around it. Essentially I have a Form that has two modes, browse data and add new record. When in browse mode, it draws in data from several tables...

I am not an expert, but aren't ActiveX controls always with the .ocx extension? They do API calls to the .dll If you don't have the .ocx, I suspect you can't create the control.

Sorry johnwm, I wouldn't be able to follow your advice anyway. I can't rename the existing comdlg32.ocx because somewhere during the re-install process it was removed from my PC. I don't even know which installation would be supposed to put it on my PC. My guess is Office, because that has...

Thanks for the suggestion, but I am afraid to play any further with Windows settings. Fortunately I found the following article on API calls that does exactly what I need: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima01/html/ima1101.asp

Unfortunately I don't know where this control came from, since it was already on this PC when I started work at this company. It just seems to be something common and basic to Microsoft applications, as I have used it at other workplaces. I have just spent way too much time re-installing...

Yes indeed, this has helped. Don't quite understand it all, but the DLookUp() function did the trick. Thanks

I hope this is the right forum to post this. At the new workplace I have just started at, I have been asked to write a MS-Access application (using a licensed 2002 copy under Windows XP Professional). Everything is going fine (though some of the SQL statements made me pull my hair out)...

Hello, I am normally an embedded programmer, but I now need to write an inventory-type Access application. I was doing OK until I tried to make a Form to browse the Parts table. A quick search of this site's archives does not present any obvious solutions. The problem comes down to 3 tables -...