Search results

Hey all I am having a problem with my form filter. I was wondering if you can just direct a filter from form 1 to form 3 without referencing form 2. I am thinking not cause I am having a problem getting the filter to work. Here is the code I have in my load form. framfiltval = "CONSTR_LOCATION...

Does anyone know if this code is correct?? I am linking my Main form Address value to my inspections form constr_location value. However the inspections form is linked throguh my building form. Main - building - inspection address3- pin- constr_location This works fine on another form that I...

yes those are the control names, I did add the "with me" and "end with" code. They types are integer. but I changed the portionval to currency. Now I have a error cannot perform with out seting focus, and i set focus to the text field and then it said cannot set focus to that field? have a good...

I just tryed it and I got an over flow error? as well I had to remover the "." infront of all the variables. So what is an over flow error mean??

Thank a lot FlyerMike, I hope it works. I will get back to you about, it. one more question is that "." suppose to be in frount of "." portionval??Thanks

So what is that code doing exactally??It is doing the calcculation? So can you explaing the NZ function a bit more? I would like to know a bit more about it before just adding the code. Thanks

I have a new table called CONRESVALCALC with contain lots of fields. I need to use a command buttons so when the buttons is clicked then a calculation is performed for that specific button. The field Mainarea and unitval have to be multiplyed to have portionval appear. This button can be pressed...

Hey what does anyone know anything about a copy function? I think it is vb code but I am not sure. what i am trying to do is to. create a id number using the last 2 digits of the year from the date, and adding a "-" and adding the last record number plus 1... SO I think I have the date things...

I need help my filter will not clear, after i use my filter I want to clear it out so there is nothing in the field when I go to filter again, I have tryed different code, and nothing seem to be working. Can anyone help me! Code I tryed: ReApplyFilter= Me.filter= true Me.Filter= ""...

I need help my filter will not clear, after i use my filter I want to clear it out so there is nothing in the field when I go to filter again, I have tryed different code, and nothing seem to be working. Can anyone help me! :confused: :confused: Code I tryed: ReApplyFilter= Me.filter= true...

Thanks alot, this example really works. I have the filter problem solved. Such a weight off my sholders. Thanks again

your on the right track you know when the days are >= 0 then change the backcolor of the object or the forcolor. that will give you the color. I am not too sure on the other part though.

I have been trying to find the answer to this question as well, so here it is what I got from it. Hope this help you. Form Sizing

supercharge has hit it on the nail, with exactaly what I need. Thanks for all the help ghudson.

I have a function button set up to filter my data, if I push the F8 button the filter displays and then enter my filter critera and push F9 this then displays my filtered search results. Once I am finnished with my results I would like to clear the filter so it does not appear in the field...

the for the help, I was to use a delete button with the select case what would I use instead of undo. Save and undo make sence, but what if I want to delete, and not delete what would I use then? If I was to use a exit yes and no case what would i use for that. yes exit and no... Thanks

I am having some problems, I tryed a msgbox with only ok and if I would like to save the record I see now needs to be a yes/no buttons, so I changed the ok to yes/no and it saves the changes no matter what. so i will need a If statement correct, but what do I put in it?? The Same thing is...

actually I did try the code that you gave me and I kept getting an error for the size, so I was looking for another way. Thanks for all the help

I know that it is a sample, however I changed the code to suit my program but it is not verifying my main form name, I was thinking maybe you had some ideas where I could check the name or something... thanks again

It doesnt not recgonize my form name for my main form. it has been doing this since I starting working with the program. why is this it is spelt right, I dont know...