Search results

change this line & "WHERE (((TblCONTACT.CompanyID)=" & cmbString & "))" to & "WHERE (((TblCONTACT.CompanyID)= '" & cmbString & "' ))" in other words, add the single quotes. good luck, sam

open the subform in design view, and go to the properties of the form, and set the default view to continues form (or single form). good luck, sam

not so sure what your question is. do you that the main form and the subform relate to the same record? then you need to link them. please explain, sam

go to Tools | Startup and uncheck display database window, and display form/page, pull down the menu and select the switchboard form. if you don't have one then go to Tools | Database Utilities | Switchboard Manager. good luck, sam

Hi i have some solutions but i am looking for more ideas on ho to go about it. I have a form that is a Claim. each claim involves an employee. the employee should be entered if there were no other claims for this employee. so employee is related to claim one-to-many. the main form's datasource...

i think you need help with a survey. i found an interesting toturial and i don't think it is easy to implement, but it may give you some good ideas. go to: http://www.rogersaccesslibrary.com/OtherLibraries.asp and on this page there is a guy by the name: Hookom, Duane download a full featured...

it may not be referenced in the propertied. check the properties of the form to see that in each event item there is "Event Procedure" sam

just add the code i gave you. it will automatically know the parameters. sam

i think its because you are using as part of your recordsource a query. what you need to is use a simple for loop to make sure your parameters are all set. try this: Dim QueryCmd As ADODB.Command Dim Pa As ADODB.Parameter .... For Each Pa In QueryCmd.Parameters Pa.Value = Eval(Pa.Name) Next...

this is a new concept to me and i have not tried it yet. but i am troubled witht this idea. would you not want to create something in access like a form/report concept? entries are on forms, they don't work on reports (at least that is not what they are intended to do), you will not have the...

there is a missing "VideoSoft vsOcx Controls" in the references. can view the form "Sure" sam

you can try refreshing the links. go to the VBE | Tool | References and see if there are any missing. you can refresh them there. sam

you can also assign the value on the onclick event. or on the on open event.

you need a query with an outer join. join tblUserDepts with tjxCompanySubscriptions then count tjxCompanySubscriptions.UserDeptID and do where countOfUserDeptID = 10 good luck, sam

i think you want to reconsider using one table. did you normalize it? sam

i am assuming you are talking about a "text box". go to properties | Data | ControlSource and enter =[tablename]![FirstName] & " " & [tablename]![LastName] sam

instead of all the code above try this Private Sub cmdNew_Record_Click() Me.DataEntry = True Me.RecordSource = "dbo_Contracts" end sub sam

i am assuming you know how to create a query. so create a query save it, and then you can go to Macros and start a new one. the action will be "SendObject" and then you will see all the parameters for email. sam p.s. i would help you with the VBA, but i have no clue what you are doing, what...

you need to format the textbox that holds the "difference between budget and actual" with custom formating. try this: #,###.00;(#,###.00) if you open excel and go to help type in something like "custom format" you will see a better explanation and description of this. sam

i am assuming that you are doing the following: Tools | Customize but what you are not doing is: Tools | Customize | Commands | Categories | Format and then in the commands side choose the buttons you want. btw, ctl-drag is like copy/paste and works in all of office. so if you have a picture...