Search results

Re: Combo box issue Hi Harry, Thanks for your reply. It works w/ bound column to 2. But could you explain why bound to column 1 not working?. Thanks!

Re: combo box issue I have a combo box in a form. It display two fields-[Company], [contact] when user clicks on it. MY problem is when user clicks on it , it replaces [Company] with [cust id] in [tblcustomer ]; Form’s recordsource links two tbls If I remove Company in the combo box’s...

Re: Populating a field in a new record Thanks maxmangion for your responses. I got it working, except I had to place on Current event. Thanks much!

Re: populating a field in a record Correction. It's the navigation buttons I like to add code to populate a field in the new record or any suggestions. Thanks! I tried openargs property it only sets the form to open to a specific record not for new record.

Re: populating a field in a record Hi, I have a question on populating a field on a form from another form. I have a form(frm_customer) that opens to a filtered form(frm_ear). W/i the frm_ear user wants to populate the customer id field from frm_customer when add a new record through record...

Re: Unable to locate error Hi all, When I open the AC2Kdatabase I rec'd the error messages below. MS Access The expression On Error you entered as the event property setting produced the following error: Variable not defined. The expression may not result in the name of a macro, the name...

Re: Error in setting recordset object in option explicit Thanks Roy & Pat for the info. I think I figured it out. Thanks!

Re: Error in setting recordset object in option explicit Hi all, I like to set form's recordset visible throughout the form. I declared the variable and set the recordset object in option explicit but is giving me the error below- Vb Compile error: Invalid outside procedure Option Explicit...

Re: Need help in Date syntax Hi again. This is what I tried: doesn't work: no records returned 'str = str & "WHERE dbo.tblshipping_sched.cust_ord_due = '" & CStr(Date) & "'" 'str = str & "WHERE dbo.tblshipping_sched.cust_ord_due = 3/28/05" this is one works str = str & "WHERE...

Re: Need help w/ Date syntax Thanks for your reply, Kodo. What should my query look like? I tried below and it 's giving an error and no records on the report. str = "Select * from dbo.tblshipping_sched " str = str & "WHERE dbo.tblshipping_sched.cust_ord_due = '" & Date & "'" Thanks!

Re: Need help w/ the DATE syntax Hi, I'm trying to set the date criteria in my query but I'm trouble w/ the syntax. Could someone take a quick look? I'm using AC2K, SQL Server 2K. This is what I tried: str = "Select * from dbo.v_print_shipping_sched where [cust_ord_due]= #" & Date & "#"...

Re: "Save Operation Failed" Hi all, I tried to use DIR function to check if file exist, it executed fine. But when I tried to save it Access is giving an error that "Save Operation Failed" then db locks up. Does anyone know why this is occurring? This also happened when using LEN...

Re: set focus to the beginning of the text box Hi all, I have a text box with an input mask property set. when you click on the text box it focuses the last character of the control. Is there a way to get it to go the beginning of the control(first character in the text box)? I tried...

Re: This recordset is not updatable Hi Pat, I do have an aggregate function in my query. Is there a way I can get around it? Thanks!

Re: This recordset is not updatable. Thanks tjs206 and Pat for your replies. I might be the queries instead view that worked. So how would you to display data from more than one table in an Access form using SQL Server tables and also edit a table? Thanks!

Re: This recordset is not updatable hi tjs206 Thanks for your explanations. I was trying to update a table thru the view in the form. Does it make a difference the view is in Access or SQL Server? I thought it worked before in Access.

Re: This recordset is not updatable Hi all, I created a form that links to a view. The view joins the two tables and both of these tables are defined w/ Primary keys. But when I try to update the table is giving an error in Access form: "This recordset is not updatable". Would anyone have an...

Hi SJ, Thanks for your reply. I have the following in my code: Option Compare Database Option Explicit Private Sub Report_Open(Cancel As Integer) Dim str As String, dt As Date, dte As Date Dim rst As New ADODB.Recordset : Could this be problem using report object. I'm using AC2K and Sql...

RE:Application-defined or object-defined error Thanks for your reply. I have MS ActiveX Data Objects 2.1 Library checked in Reference Library. This code works in the form open event. is it because it is a report? This code the similiar code for the form open event: sqlstr = "Select * From...

Re: Application-defined or object-defined error :mad: Good Morning, I am trying to set my report's recordsource by using the code below in the report open event but it is giving me this error message: Ms VB Runtime error 2465 Application-defined or object-defined error The same code is used...