Search results

Okay, so in attempting to recreate the problem on a blank form, I realized there was a number control being set via code and that's where the problem lies. Will I need to manually set all controls to "' or NULL?

I am contemplating making all controls unbound, and passing the entry through when the save button is clicked. It will remove all of this hassle, if creating some extra work that should be automated. I suppose as a benefit I will stop losing autonumbers when users cancel forms. Or I can remove...

I did. The current code is now: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Form.Undo Cancel = True End Sub and the error is: Error Handling doesn't pick it up and I still get the error. I tried sticking a message box into the before_update, and I get the above error before the...

Closed, saved, and not working again.

Yea that was the problem, not code per se, but I had a default date value.

Nothing has been done. I'm talking I open the form and attempt to close it immediately. EDIT: Works all the same... Thanks a million, it was driving me crazy.

Alright folks, It's been a while, I hope everyone is well. This is a stupid error that I am hoping is due to some small oversight. I've simplified the process just to minimize that chance. Here goes: Private Sub Form_BeforeUpdate(Cancel As Integer) Cancel = True End Sub I have several...

Paul, Thanks. I don't know how I could've done such a thing! I used the reference table. EGADS!

hi there folks, So after not touching Access for a year and a half I feel like I've forgotten everything. So please forgive me for this: I have the following SQL string: SELECT courseID, SUM(num_labreport * enrollment * (SELECT estimatehrs FROM tbl_guidelines WHERE itemindex = 1)) as...

Unbelievable. I changed the single line if to a block if and presto! No more problem. I'll keep that in mind for the future!

Thanks Bob. I will try it this evening when I have time to work on my database. @RuralGuy: I always thought that a series of items would all take the type specified, ie: dim strOne, strTwo, strThree as string

Greetings folks, So I spent the last couple days dug deep into my database project and it was all coming along smoothly until I had an untimely system crash. Fortunately I save regularly so I only lost about 5 minutes of work. Unfortunately, I do not backup regularly otherwise I'm sure I...

Its not actually gone. I got it to work with some code I found for use with Excel user forms. Also it works well with hiding the access window, though the best I can figure is to have it flash on startup as access loads before any of the forms to run any code

I've been hunting for a while. Since they've removed the show in taskbar option after 2003 I figure the quick way is out, but, surely there is still a VBA method of getting it done. I've done searched several forums, asked some experts, and browsed microsofts database. Nothing so far. Anyone...

Elias, Thats another interesting snippet to store somewhere. Using it in Load would serve no real purpose to me other than controlling the start location. It does almost do the job when used in Form_Resize. Except that it doesnt lock the size it just moves it. Meaning that while trying to...

Gina, That just might help. Though I won't be certain till I sift through it. Somewhere buried in there is also a solution to setting minimum form sizes. Though I suspect there is alot of unnecessary functionality there. It seems that that piece of code was developed for excel VBA users and...

Again I'm going out on a limb here, but I am assuming you have the equivalent of two listboxes and a table where the records which have a field which might contain the function exist. Without specific names we'll refer to them as lstFunction: Where you select your function and; lstOutput...

I want to set a minimum size. I want the users to be able to resize. Maximizing is fine. However, I do not want them able to resize a window until all there is is a two inch title bar and no body. For example I would like to prevent the user from resizing the form narrower than 5000. Many...

I'm not entirely sure what you are asking. Try and clarify. I am assuming you are trying to filter your output based on a selection in a listbox, or group of listboxes. The easiest way to handle that is to use VBA to build an SQL statement. I generally split my SQL statement into 4...

I found one or two Active X controls that handle form resizing, but have been unable to find a way to establish resize limits using VBA. But is there a simple way using VBA to set minimum form widths and heights? Cheers folks, Steven