Search results for query: *

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

Thanks all! theboyhope's post was what I needed! Don

This seems like it should be simple, but I can't get it, so I'd appreciate any help. I've got a text box in which a user enters a number, but I want to make sure that the number is a multiple of 5 (e.g., 5, 10, 15, etc.). I know I need to use a function that I can either call on an onBlur...

I know this is an old thread, but I was just struggling with this same question, and this thread helped me find a remarkably easy solution. I'm using Photoshop 6.0 and Pagemaker 7.0 on a PC. The mention of "clipping paths" in the thread sent me to the Photoshop help file, where I...

Thanks for your suggestion. I couldn't create an EPS that looked nice, but something you wrote gave me an idea, which worked, although I don't understand why. I created some additional text (just "..."), in the large font, and hid it behind a graphic. When I did this, and...

Thanks Jimoblak, Using the PM font styling was the problem for the bold italic font. Any thoughts on my other problem? Why would a 200 pt font convert to Courier in a pdf doc. I have other text in the same font at 120 pt, and it looks just fine in my pdf document. Thanks for you help