Search results

Oh, we did. We did. But they changed their minds to let me do it my way and then changed it back after I finished everything.

Here's the deal. I have been working on a project (I am an intern at a large company) for Access 2003. I have been coding it and reworking it and I just finished it yesterday...or so I thought. Apparently my superiors who are running the project are scrapping EVERYTHING that I did because they...

PERFECT! Thank you for all of your help again.

Are [FirstName] and [LastName] supposed to represent the variables I had in the previous post or are they supposed to be direct connections to the appropriate table and field?

I've been mulling this over in my mind. Would something like this (or at least along these lines) work? Dim FirstName as string Dim LastName as string SQL statement to pull out first name = FirstName SQL statement to pull out last name = LastName combo_User_ID = First & " " & Last...

This is probably a really simple solution that I am overlooking, but I am just not able to figure this one out. I have two combo boxes (User ID and Assignment ID). The Assignment ID combo box is dependent on the User ID combo box. This works just fine. However, this is what I want to do. The...

This code is for anyone who wants to limit the user to which keys they are able to use for data entry. Private Sub myTextbox(i_KeyAscii As Integer) Select Case i_KeyAscii 'Allows users to use ONLY integers 0-9 and all capital letters as well as the backspace, except for vowels Case...

This code is for anyone who is new to VBA and/or Access and is not sure how to deal with null values in their textboxes. This code changes the null values of the First Name and Last Name textboxes to empty strings. If you don't want an empty string then you need to do some KeyPress event...

The only reason I even thought about it is the fact that I will most likely pass the project on after an undetermined amount of time and the other person may not know what to do AND the other people that I am working with on the project have already forced me to change a number of aspects of the...

Yeah. This is the thing that I was afraid of. I was thinking of trying a different even procedure. Are there any out there that might work if I switched it from an Unload event procedure to the other one?

The line... Public AllowClose as Boolean was one line to low for some reason so it was declared in the wrong spot. However, I am unable to view the form in design view now. Is this because you are essentially closing the form when you do so? Or is there another reason? Any idea how to...

Thanks. I new I was missing something tiny. I am now getting the error... The Microsoft Jet database engine could not find the object ". Make sure the object exists and that you spell its name and the path correctly. I am not even sure what this means exactly, let alone how to correct it...

I want to make it so that the user has to hit my close form button in order to close the form. This is the code that I found. This works perfectly, except I am unable to close the form because I get the following error... Compile Error: Label Not Defined It then highlightes the line Private...

Yes it did. I just got it working. Thank you for your help. It is really nice to know that a noob like me can get help from knowledgable professionals like yourself.

Yes, I accidentally did. My computer at work has been having problems across the board, including internet connection and graphics issues. I meant to put a poll in and because of some glitch with the screen I deleted it. Sorry about that.

I have two combo boxes that contain information that needs to match. The combo boxes are Assignment ID and User ID. I have these choices in the combo boxes directly linked to the field in the table where they can be located. The table that these two need to match up in are in a table for...

I think this one was directed at me. If not then please just ignore my rambling. lol I was told that the Unbound form was the way I was supposed to do this project. I started with and still have a bound form that I have been working my way through. I have been learning a tremendous amount...

Set the default values of the textboxes to 0.

I am under directions from my bosses to use unbound controls and then have the input go to the appropriate fields in the appropriate tables upon the clicking of a submit button. I am not sure how to go about writing code for this. Could anyone give me a hint as to where to start? I had the...

I absolutely agree with everything you said. I was just trying one last time to see if I was missing something, but I guess I wasn't. I will simply let them try to figure it out if they want to. I was not sure at all about the multiple errors in multiple records like you talked about, but now...