Search results for query: *

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

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.

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

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

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

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 & "'"

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

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

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

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

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

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?

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

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

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

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

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.

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

Please see thread Default Value of Option Groups thread703-921823

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