Recent content by RBCCFD

How do I create a Report that generates with search by category or keyword?

I so lost with the query. Do I need to add all fields from all tables into this query? what expressions do I need to use next? I tired Like "**" under some fields, seemed to work. Not sure how to translate all that to a form with botton. Thanks

Hi, I tried playing around with it today. I changed table fields to short text. In the form, I inserted all the fields but couldn't figure out how to change the text box to a combo box allowing muliple entries. I tried a combo box on the side which shows a list, but doesn't show check boxes...

I just remembered why I did Look up Fields in Projects List table, I need to be able to pick multiple Sites or Buildings or Dept for each project. So how else would I be able to do that without having redundant records or would it just be better to copy the record and change info in those fields?

The field names don't actually have spaces, the caption in general properties does so it displays that way, will that work fine? The verified and # of structures was intended only for my use and not the search form, forgot to mention that, I had to track/verify that info. Read the article...

I am new to Access. I know the very basics. For my work I need to create a database that search for any keyword to retrieve records. I have 4 tables. A SITE table with file number, address, description, TMS # and links to file location and GIS image. A BUIDINGS table, because we have...

I work for a property and construction management company in Charleston, S.C. My background is in architectural and structural design drafting on CAD. In addition to producing drawings, I have been given the task of creating a searchable database for our properties. I love living in the...