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...
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...
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.
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...
this is my problem. i have a databse that access linked images utilizing code found here.
Me!Image.Picture = "s:\pgm\historic pictures\" & Me![Current Address] & ".jpg"
piclabel.Caption = "File: " & " s:\pgm\historic pictures\" & Me![Current Address] &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.