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 Chriss Miller 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: MsMope
  • Order by date
  1. MsMope

    What is wrong with this statment: a variable within a sql statment

    ERROR: The query could not be executed. The following message was returned by ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '#'.
  2. MsMope

    What is wrong with this statment: a variable within a sql statment

    The code that I posted previously is all that is behind my integration for vbscript. I am anticipating pulling in order information who's shipped date is between those two values.
  3. MsMope

    What is wrong with this statment: a variable within a sql statment

    OK so I did as you both have suggested, using the #, I retrieve 0 records, which is incorrect. Now what?
  4. MsMope

    What is wrong with this statment: a variable within a sql statment

    Skip, Here is the code for the other script that I am asking for a date on:'Prompt the user to input a value dStartDate = InputBox("Please enter a start date.") dEndDate = InputBox("Please enter an end date.") 'Test the values to make sure that they are both dates. 'If not, cancel the...
  5. MsMope

    What is wrong with this statment: a variable within a sql statment

    Error on line 11: Unterminated string constant that is the message I get when I remove the tic's, any suggestions?
  6. MsMope

    What is wrong with this statment: a variable within a sql statment

    Hi, this is written in VBScript, but the query values are not working, I am still retrieving a years worth of data instead of just the data I am looking for. Query.AdditionalCriteria = "Date_Shipped >='" & dStartDate &"'" Query.AdditionalCriteria = "Date_Shipped <='" & dEndDate & "'"
  7. MsMope

    ERP Application Samples using VB/VB.NET

    I have samples using VBA, but not VB/VB.NET
  8. MsMope

    MultiLine display

    OK so maybe I can do the formatting to the table itself??? I do not have a website to post the image too...
  9. MsMope

    MultiLine display

    No I don't think so, maybe I didn't explain this enough. I have a listbox, which is populated by a table, several fields, the "note" field can have 255 characters, but I do not want the listbox control to have to be that wide to accomodate 255 characters, I would like to have it display to fit...
  10. MsMope

    dynamic datagrid

    Good morning, I posted the following thread in the forms forum, but recieved no response, does anyone have suggestions? thread702-928194
  11. MsMope

    Default Value of Option Groups

    Yes the values are 1,2,3, but if I use the control source then I cannot change the values by clicking on different buttons, that is when I get the above listed error. So this is what I put in the onCurrent, which also didn't work Private Sub Form_Current() Dim DelValueDefault As String Dim...
  12. MsMope

    MultiLine display

    Good morning, How do I display a text field as multiline in a datagrid view on a form, such as I have a description field on a form, it can have 255 characters, but in the datagrid I want it to display to fit the grid, this also needs to carry over to the report.. any suggestions?
  13. MsMope

    Switch Focus between main form and Subform

    Good Afternoon, I have two forms, frmMain and frmAddChange. On my frmMain there is a button cmdOpenAddForm that when clicks opens the frmAddRecord Private Sub cmdOpenAddForm_Click() On Error GoTo Err_cmdOpenAddForm_Click Dim stDocName As String Dim stLinkCriteria As String...
  14. MsMope

    Inserting into a table using values from comboboxes

    Good Morning, I have 4 comboboxes on my form cboEmployees cboSystem cboReason cboType these are bound to the corresponding tables with select statments ex: SELECT Employees.EmployeeID, Employees.LastName FROM Employees; I have another table called ChangeDetails, this tables stores the ID...
  15. MsMope

    Default Value of Option Groups

    If I need to reference each button within the group, then what is the advantage of using the group? Isn't that what the .value property is there for?? anyway, i have more issues with this, imagine that. Now I recieve the cannot edit error that I have read many posts on, the timestamp fix that...
  16. MsMope

    initial value set to option group,

    I have resolved the issue, please see the above listed thread.
  17. MsMope

    Default Value of Option Groups

    FYI~ I have corrected this issue, I reviewed the underlying query and it did not contain the field I was trying to reference therefore giving me the error.
  18. MsMope

    Default Value of Option Groups

    SO I went back into the controlSource for the option group and built the following [tbl_userAccountProp]![Delivery_Value] there is no (=) in front, and I recieve the same message as above, with one exception Control cannot be edited; it is bound to an unknown field...
  19. MsMope

    initial value set to option group,

    Please see thread Default Value of Option Groups thread703-921823
  20. MsMope

    Default Value of Option Groups

    as an add-on to my last post, when the form is loaded and I attempt to click on the option buttons I recieve the following message on the bottom of the form: Control cannot be edited; it is bound to expression 'user_tblAccountProp.Delivery_Value

Part and Inventory Search

Back
Top