Search results

Thanks for the input but I dont think that is an option for me at this time. So Many people are telling me I should use the DMax funciton however I have got nothing back on how I can use it, and I have see the syntax for it but it is just not clicking for my problem! Thanks

okay, so I think that is a good idea. but I am not really sure on all the details that you are talking about so can you let me know a bit more, Now that i have had a chance to see the add and delete I understand a bit more where you are coming from. So what do you think is a good idea??

Okay so, I am haivng a bit of trouble with my undo as well. In my add I call my undo incase I didnt mean to add I am undo and go back to the original position I was. But it still saves the record. Why is that?? So Why would there be no code for the No button?? UNDO BUTTON CODE On Error GoTo...

I have got it! it works great! Thanks for all the help Dim myCount As Long PERMIT.SetFocus myCount = 1 + Nz(DCount("*", "Building"), 0) PERMIT.Text = Format(STRDATE, "yy") & " - " & myCount

I got it to work, This is what I have now! Works like a charm! Dim myCount As Long PERMIT.SetFocus myCount = 1 + Nz(DCount("*", "Building"), 0) PERMIT.Text = Format(STRDATE, "yy") & " - " & myCount

Hey all I have added a yes no button to my save button, so users have the option to save the record or not. so the save yes works fine, but it is the save no I am having probelms with. I would like to click no, and have the changed not saved, clear that out and go back to the first record again...

Nope I am sorry i cannot post my DB. And I still cant get this code to work. Any more ideas and help would be great!

I keep getting a type mismatch! My Code : Dim Num As String Dim count As String Dim MYYEAR As String Dim NUMBER As String count = DCount("*", "Building") count = count + 1 Num = Str(DatePart("yyyy"...

I would like the 05. I didnt not know that it returned an integer. WOW! Thanks for the heads up I tryed it and it works, but I still cant get the 05, by using the RIGHT Function.

That is what i though, I got an invalid call, procedure or argument. I have heard about the DMAX() but I dont understand it. I cant get the code right.Could you help me out with it?? Dont worry about the boss. Not that kind of Boss. LOL (LAUGH OUT LOUD) It would be great if you could help though!

nope that didnt work. Before the error was that I cant find the CONSTR_LOCATION and now that i changed it to an "&" the error is cant assing value to framfiltval

DatePart Function (STRING) Hey all I have a I was wondering if you knew how I can get a part of my datepart function out, I have taken the year from the the date with the date part function and now I need only the 05, so what can I do to get it out? Thanks MY CODE: Dim Num as string Num =...

Hey guys. I was wondering if you knew how I can get a part of my datepart function out, I have taken the year from the the date with the date part function and now I need only the 05, so what can I do to get it out? Thanks MY CODE: Dim Num as string Num = DatePart("yyyy", STRDATE)

yes that works, However I dont know if all my user will know that or not, is there any code for that problem?

Thanks it does have to be in " " it works awsome thanks alot.

Well that is okay. That is what I need to do, and need help on. Sorry if I am being blunt but if that is what my boss wants then that is what he is going to get, however I have talk to him about that and it is fine with us. Thanks

So I can use the DCount to find the number of records in my table by using this: count= DCount("*", SEWER) Where * counts all the records, in the table and SEWER is the name of my table. HUMM I got an error for my table name: It said variable not defined. Why is that?

Hey all I have a combo box and once I am tabing through my form, and I get to the combo box, then I would like to have the ability to use my down arrow and have the combo box expand for easy selection. This is currently not happening, and I was wondering what the problem might be, does anyone...

that is kind of blunt, and to the point I guess! Okay so I can use the Dcount, but how do I use it? Dcount(WHAT IS THE CODE FOR HERE) I know what they suggest but I dont know what to put in there? That is why I am asking for help with this situation. Thanks

Hey all, I was wondering if anyone might know how to obtain a reocrd count, I need to create a PERMIT number based on the number of records in my table. So I need the number of records in my table plus 1, which will then give me half of my permit number, I will then add the 2 last digits of the...