Search results

Have an adp database connected to SQL Server. Trying to read one table to update another one. Getting error about "Object variable or With variable not set" I'm used to dealing with mdb DAO connections and not ADO. I'm sure I'm just missing how to Open the Recordset. Dim strSqlQuery As...

Thank you for the helpful code and about the ESC key. This solved both my problems. This is a great forum. I always find my answers looking at others posts or receive help from experts. :)

I have a form that on the field the user inputs a number. On the After Update event I have a event procedure that does some testing of the values on the form. If the user gets an error I'm using the MsgBox, but it does not focus back on the field that I indicate and it places the cursor in the...

Never mind. I think I just missed one of the fields assign default to 0. Now it works.

I have a form that adds a record when the user clicks a button. It does some edit checks and then the insert statement is CurrentDb.Execute "Insert into [Trip Details] ( [ListID],[Price],[Departure Date],[Group],[Cruise Line], [Category], [Ship],Destination,[Cabin No], Insurance)" & _...

Thank you for your solution. I had not thought of using a query to determine the first occurrence. I figured out another way of doing it by adding a field to my table when these records are generated and then used the same type of conditional formatting on the form. Sometimes I just have to step...

I have a form that lets say has the following fields on it. date, location, precinct, type, low, high and lets say my data as filtered and sorted using a query on the screen looks like this 5/7/2010 A 100 D 1 50 5/7/2010 A 100 D 51 100 5/7/2010 A 100 D 101 150...

Thank you. I knew it was something easy, but forgot about the DoCmd properties.

I have a form that performs a procedure on the click event. I want to set the properties of the mouse to an hour glass so that user knows the process is running. Is this possible and what is the code for this action.:confused: Thank you, Marnie

I figured out my problem. I needed my export filename in a path with quotes.

I am just trying to export the contents of a table to a csv file. Here is my command. DoCmd.TransferText acExportDelim, "ballotdist", "BallotDistribution", ballotdist.csv, True The "ballotdist" is my specification file and "BallotDistribution" is my table name. I want all the data for this...

The statement I submitted was correct. I was not viewing my data correctly in a test query to validate I was getting the correct coun.t

I have a Dcount statement where I want to return a value based on a Select criteria of finding if the value they entered on the form is found between two fields in the database. Is there a "Between" method that can be used on a DCount. Here is my code now but it doesn't give me what I want...

Thanks for the reply. You are right I always want to add the 23:59:59 to the from date. This forum always gets me to the solution I need. Thanks:)

Sorry wrong posted of code. If Not IsNull(Me.SrchLastCDate1) And Not IsNull(Me.SrchLastCDate2) Then 'ChangeSearchType If Me.SrchLastCDate1 = Me.SrchLastCDate2 Then Me.SrchLastCDate2 = Me.SrchLastCDate2 & " 23:59:59" End If Cond = Cond & " AND...

This is how I ended up fixing it. If Not IsNull(Me.SrchLastCDate1) And Not IsNull(Me.SrchLastCDate2) Then 'ChangeSearchType If Me.SrchLastCDate1 = Me.SrchLastCDate2 Then Me.SrchLastCDate2 = Me.SrchLastCDate2 & " 23:59:59" End If Cond = Cond & " AND...

This statement is working the way I had it for those records with no timestamp. I'm just trying to include those with a timestamp. Again remember I'm just building SQL statement here not executing it.

This is not the syntax I need, remember I am coding a string statement to be added to my whole select statement. If Not IsNull(Me.SrchLastCDate1) And Not IsNull(Me.SrchLastCDate2) Then 'ChangeSearchType Cond = Cond & " AND LeadContacts.ContactDate BETWEEN '" &...

I have a form that has many fields and when the user enters data and tabs off the field a select statement is dynamically built to query the table(s). I have one problem where I have a date range the user can enter, and the fields on the screen are of type date. They are going against a column...

I was having the same problem and it WAS the width of the report. It must fall within the 6 1/2 width range. Thanks:)