Search results

On that popup form (second link) I get error 13 Type Mismatch! This is the full code: Private Sub Set_Filter_Click() Dim strSQL As String, intCounter As Integer ' Build SQL String. For intCounter = 1 To 5 If Me("Filter" & intCounter) <> "" Then strSQL = strSQL & "[" &...

Thanks man. That is what I am looking for. Hopefully it works in access 97...

Thanks!!!! I got it!

Ok, I am a noob at reports and did a search on this. My searching DID NOT HELP ME! I thought I would make that clear :D Maybe someone can tell me what to look at for this issue. I need to take one report, allow the users to easily use a dropdown or listbox on a form to Sort and Group many...

Ok, I dont have much time but I know of a good way to do half what you want lol. mhartman told me a way to make a button next to your field and use this code so that when they click the box it will autofill the field with the date. You can prob ask or figure out how to have it do the time also...

once you get your data working great and in one location you can use a subform and do a bunch of stuff to pull data of employees to other forms using a ID # or something unique like first initial last name... Im not much help but this is what I did to get autopopulation going on! :)

Thank you QT! Edit: When I change close button to "NO" It still shows it. Any ideas? Edit 2: The maximize command puts the close button back because when I minimize they are not there like I told it to do. I dont know if there is a way to get around this one? Any Ideas?

Of course, of course! I have done this several times. In this case and prob several others you need to realize I have been using access for 4 weeks with no classes on it and I dont know what to search all the time... This is a forum and I guess a database (no pun intended) of answers to search...

I dont know how or what access did but I used the expression builder to throw some stuff in and the code it had worked :D I think it was dumb luck but it seemed easy. I should use the expression builder more ;)

Im a noob when it comes to code but I understand it when I did in it and I know what it does. So, I am saying that I do not now how to do what you said banana. Could you write me some code with a little explanation or tell me where to do this command? Thanks much, ill keep looking for how to...

I have a refresh button next to a box in my form. I would like to make it so that when someone clicks another field or out of the key box it will refresh the form automatically because that box makes other fields autopopulate and the way I have it set up thus far is that you half to refresh the...

I would like to tweak my database so that when it opens for the users it will not show the minimize, maxamize, and close buttons at the top. Also, I would need code that will maximize my forms automatically. Let me know if this is not a good idea? I am trying to eliminate someone thinking that...

I was afraid I would half to make these buttons and go to the code for every one of them...

Well I half to track the dates of when these 16 tasks get done. It isnt a default value by any means. A person will be leaving the form and returning back to it when he/she finishes thier task they will hit this button to tell everyone they finished this task on this date. ;) As for having the...

Whats the fastest way to code in 16 of these buttons? Do I just half to put in one at a time or can I make the code, copy it 16 times making sure all the values are correct, then tossing in 16 boxes naming them the corresponding name as the code has.

I knew it was easy...And yes I figured one of you guys would respond. Now if Ken responds we have all the smart forum posters posting on this topic, haha! I am going to rate marks answer better because its descriptive and lets me know how the code above will look in my code. ;) Thanks guys.

What code would I use and how would I insert it into my Code to make a button on a form fill in the current date into [fieldname]??? I think I already know who is going to respond to this! ;) Thanks! :D

Need button to close form without saving! :D Is there a way I can add a button called "Cancel" that will close the current open form without saving it. Im sure this is easy if someone could tell me the proper way to do it, include code. Thanks.:D

Autopopulating fields/Relationships? These are similar things right? :confused: I am trying to do some autopopulating of some fields to other forms. Say I type in someones number, name, and address and then I go to my other forms and enter thier number so that it gives me thier name and address...

So If I had this code that I located, where would your code go in there Pat? Private Sub Close_Click() On Error GoTo Err_Close_Click DoCmd.Close Exit_Close_Click: Exit Sub Err_Close_Click: MsgBox Err.Description Resume Exit_Close_Click End Sub