Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mayday999
  • Content: Threads
  • Order by date
  1. mayday999

    Fields and labels for null values

    Hi all, I am putting together a report, is there an easy way to eliminate the field and the label if there is no entry for the field (ie null or empty string) Any help is greatly appreciated! TIA D
  2. mayday999

    Can Grow

    Hi all, I have a report I have developed, I have label and field butting up against each other with the border solid on both forming a datasheet look. The problem is that when there is a large amount of data in a field, it expands, while the label does not. Is there any way that the label can...
  3. mayday999

    Check for existing record

    Hi all, I have a form with two comboboxes which upon clicking a save button writes these two values to a table. Does any one have code to check to see if the combination of the two values already exists in the table I am writing to so I won't get duplicates of the same combination. Any help is...
  4. mayday999

    SQL in code

    Hi all, I have this SQL statement defined in a piece of code, I'm not used to doing this.... : ) i keep getting expected end of statement errors, can anyone tell me what I'm doing wrong? SQL = "INSERT INTO TblScore ( AssessmentID, ParmsID, SiteID )" & "SELECT Assessment.AssessmentID...
  5. mayday999

    Writing from form to a table

    Hi all, I have a form that has two unbound list boxes, I then have a command button which is supposed to write a record two a table when clicked. The table has three fields, a Primary key (autonumber) Then two foreign key fields, which the two list box values should populate. I have the...
  6. mayday999

    Show Database window

    Hi all, I have an access database that was created before I got here and the person who put it together is long gone. When opening the App, you immediatly get an input screen, and you can see part of the database window behind it. However I can not get to it to look at tables, forms etc.. also...
  7. mayday999

    Open form criteria

    Hi all, I have code to open a form and I am trying to pass two criteria to open the form. I keep getting syntax errors. here is my link criteria: stLinkCriteria = [("[Site_ID]=" & Me![Site_ID]) And ("[AssessmentID]=" & Me![List38])] Can anyone help with this? TIA D
  8. mayday999

    Continuous forms

    Hi All, I'm baffled (as usual). I have a form, based on a query. The query contains a field that is a question, and parameters for an answer... ie. Did you like the show (field 1) Rate from 1 to 4 (field 2). I have my form set up in continuous form view. Also on the form is an unbound text box...

Part and Inventory Search

Back
Top