Search results for query: *

Hi Remou, This brings me to a couple more questions: I have alot of fields in this report, about 50, does the line of code need to be inserted for each of the 50 fields? and I want the label gone as well Next, I am sorry, but neglected to mention, will the fields move upusing this code or...

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

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...

PHV, Not sure how this would work, I am kind of a novice. Thanks, mayday

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...

Hi all, Thanks for all the great suggestions, I must have been missing a space, because I redid the whole thing from scratch and went by all the spacing conventions that were mentioned and it is now working fine. Thanks again everyone, mayday

Hi PHV I put the spaces in and I'm getting the same message "expected end of statement for each line. Thanks for the help, is there anything else you can think of? TIA Mayday

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...

Just got back to this, you are both right, I was missing an "S" at the end of the table name. That drove me crazy! Thank you both for your responses!

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...

Thank you, much appreciated!

Hi Remou All the menu options, Tools etc... are disabled, anything else you can think of would be greeatly appreciated. Thanks, Mayday

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...

Thanks PHV, Went a little crazy with the brackets and quotes...lol

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

Tried puting the form into single form view and the same thing happens, I really can't bind the field for my purposes

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...