Recent content by boiker

thanks for the help, but i don't see how this addresses my main issue. The function searches the "detail" field of the record which is memo control. If I want to search for the records which contain "fence" "residential" and "height".....how do I do this?

In my database, I've got records that are identified by a ordinance number, entry date, and a detail field. I'd like to create a form that will perform a text search of the [details] field. I have a basic text search that uses a query with the Like command. I'd like to allow the search to be...

that may work, however, I already have 3 tabbed forms within this form already. i don't want another tab to add to the confusion. However, I will explore the option. The goal was to have the form popup on click or something to attract the end-users attention. Also, the form may be called up...

apologize for the confusion. The durations should remain equivelant. The end date drives the train, just as you described in #1.

The forms in question operate like this: Form1 contains business information and a table called tblBusinessInfo, BusinessID is the primary key. Form 2 contains contact information and a table called tblContactInfo, Business Id is the primary key to keep a one-to-one relationship between the...

here's my problem. In my project file the end date can flucuate. As the final date changes, the preceeding steps must move to keep the same amount of time between each step. I'm rather new at project so any simpley worded help is appreciated.

i want my vb code to break and not run if a certain field is null. currently the vb code compares an address to the name of a graphic file, if that file exists it loads that file. If the file does not exist, it loads a noimage.jpg file. I want the code to break if the address field is null...

ok.. i don't know how this function works or where to type it. would you elaborate?

I have a field with addresses. i want to be able to sort by street name. from what i know, i need to create two more data records one for the number part. and one for the streetname part CURRENTLY: Address -------- 300 NE Jefferson St. 400 S Elm St. 1213 Oak Ave. -some addresses have two...

Each record in my database has the path of the photo listed in a column. how can i use that path so that an image will print out for every record based on each records unique image path.

To continue the question. fields are: Case Number Result ZCA MV 1212 Approved ZCA 2321 Approved ZCA MV 7584 Denied ZCA MV 1222 Approved ZCA 6433 Under Review that statement from above won't reconize wild cards. how can i have it...

one more question... why the 1,0),0)) stuff at the end of the array?

thank you, i was looking it at all wrong. i understand how the array is working now.

i'm really having trouble understanding all this array stuff i want the excel sheet to count all the values in B2:b10 that are "m" AND c2:c10 are "a" and report 1 number to me. So that i can say, this many boys had A's is there an example i could look a?

i know it would probably be easier to create a database but....... EX. SEX GRADE M A M B M A F C F A M D i need a statement that will give me a total number of boys with a's i've tried countif() but...