Recent content by DonLo

Thanks to everyone for your suggestions. I ended up getting a backup copy of the database from our network adminstrator. He suggested, that to avoid this problem in the future, I make sure to compile my code regularly - something I hadn't known to do. Don

Your statement of the problem is correct. I can access the form in all views, but I can't access the VBE window from THAT form, and even from VBE, I can't access THAT form's module. (Actually, using the Alt+F11 trick, I can get to the VBE window, but it is blank - no window for the the code I...

Yes, I tried closing and reopening Access, and then completely rebooting the computer, but no help. The last change I made was pretty simple. I had some code that I had previously commented out, and I was putting it back in. At one point, when I removed the ' before the first line of the...

Thanks TomCologne and dboulos, Neither of your suggestions worked, but I have more information. I opened another form in the database, and got to VBA that way. Looking at the Project Explorer in VBA, the form which is causing me problems is not even listed as a "Microsoft Access Class...

I hope someone can help me! I've got an application which I was tinkering with, and I clearly screwed something up in the VB code, however, I can no longer access the code. Normally, when, in the Properties window, I click on an "Event procedure" and click on the "..." next to it, VBA...

Thanks hymn. I assumed you meant default value, which seems to work. I'll have to let this run for a few days to make sure if fixes the original problem. I'm still a bit baffled as to why my original approach had problems, but.... Don

Thanks SiJP, but I need to record this date, so I'm using bound textboxes. Don

Thanks for this suggestion. I just tried this out, however, it only sets the date for the very first record entered, not any of the subsequent records. Don

I have a form that I use for entering data on sales of an item. On that form I have two fields, "CreatedDate" and "ChangedDate" which are locked and set by the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) Me!ChangedDate = Now() End Sub Private Sub...

No. I haven't added any code at all yet. Don

Hello, I've got a master form, which is made up of many related subforms, each or which is based on a query selecting the relevant information from the underlying table of that subform. The master form is based on a query which links 3 tables, tblAssign, tblLease and tblBusName. tblAssign has...

Yes this did it, especially the first couple of lines: var spaces = / +/; if ( obj.value == "" || spaces.test( obj.value) ) I don't quite understand it, but it clearly allows me to check for not only " ", but also " " and " " Thanks for...

I should add that I've tried to do this with the following code in the function, but it doesn't seem to reset the value in the textbox: if ( remainder != 0 ) { alert("You can only redeem Commuter Bonus vouchers in multiples of 5")...

Well, I need to have a number in this text box. So, ideally, if the user deletes what's there and leaves nothing, or replaces what's there with a space, I'd like to insert the value 0.

theboyhope's script worked, except that it doesn't check for a null value, either nothing entered in the text box, or a space. Is there some way I can 1) check for a null value or a " " and 2) reset the value of the textbox to 0 ? Thanks