Search results

I solved this problem now, by opening a temporary recordset, I had to do this because apparently you can't set the cursor type in the circumstances of the code above. Here's what I did instead Set rsTemp = New ADODB.Recordset rsTemp.Open "SELECT * FROM [Attendant circumstances]"...

I'm doing an export program in VB to export records into Access. I want to add a progress bar as there could be a large number of records. Here's what I've got currently: pbrExport.Min = 0 pbrExport.Max = mrecData.RecordCount intCounter = 0 'Do... loop to Add some records to text file...

When you import the data, why don't you just change the data type in the wizard. Move to the field that is causing the problem and change the combo box accordingly (in the field options page). HTH Rich;)

Thanks Doc, The double conversion did exactly what you said. Cheers Rich

In the code below I think you've got it back to front. txtTotal amount is null, so you're assigning the null value to you're current total. mcurTotalAmount = Val(txtTotalAmount.Text) change to: txtTotalAmount.Text = mcurTotalAmount I think you're doing the same with the average, assigning...

I've tried executing your code for the calculate button. I put 5 in txthours and 20 for txtAmount. The calculation results in £61.25 in txtAmount and £12.25 in rate (obviously as it is constant). Is this what you want to happen? curAmount = intHours * mcurRate at the moment you are storing the...

In the click event of cmdTotals you seem to have a variable which is undeclared - mcurAmount. This variable is always going to be empty, since you don't assign it a value anywhere in the code. Are you having problems with the cmdCalculate or cmdTotals click event, because the calculate button...

When you create a text box on a form it is unbound, so you can do what you like and it won't change any fields in your tables. Table fields are changed if you have set a field as the text boxe's control source. It sounds to me like you need to read the help more. Click on control source in the...

The problem is not that simple unfortunately ): I'm running some code that checks a another field (road type), depending on the integer in the road type field the code adds a letter in front of the road number, eg M (motorway) A,B,C or nothing if it is not classified. The data can then be...

Greetings Folks! I'm trying to write code to remove zero's from the start of a road number. The problem is that there are normally between 1-3 zero's at the start, so i'm not sure now to set up the expression sought. I then want to "trim" off the zero's. Anyway I'm having problems achieving the...

Have a look at this previous post: http://www.access-programmers.co.uk/ubb/Forum4/HTML/003669.html

Cliff, Depending on the design of your table - changing the queries properties may work. Right click and select properties and change unique values to "Yes". HTH Rich

Try checking for the empty string instead of checking for null eg. If yourCbo = "" Then MsgBox ("You must select a Category") Title = "No Category selected!" HTH Rich

Try something like this, play around with the left property increasing it will move the form further to the right till it goes of screen. me.top can also be used to alter the height. Private Sub Form_Load() Me.Left = 10000 End Sub HTH Rich

You are probably in the detail section of the form. Click on the square in the top left corner of the window, then try again - there are a lot more than 2 options. HTH Rich

Thanks Fizzio, That's the point I was trying to make except not very well! The criteria does contradict itself. Tuili63, maybe you could try and explain it again? cheers Rich

If you only want the records between that date then why don't you just omit the OR [Balance] bit. "I don't want to pull the records that have a balance but aren't between the two dates I specify." Surely the balance is irrelevant if what you said above is correct. rich

If I understand properly all you have to do is change the forms properties in design view. Go to properties and select the format tab and change navigation buttons to No. HTH Rich

I'm storing the the last record for Accident Key like this: m_rsAcc.MoveLast lAccKey = m_rsAcc.Fields![Accident Key] but then the code adds a load of new records. Later on in the code I want to move back to the record number stored in lAccKey. There are no forms involved in displaying...

In my code I'm adding in extra data to my tables with an export program. I'm storing the last value for the primary key in a public variable called AccKey then importing the new data to the table. How can I find the value of AccKey later on and move back to that record. I've been trying Seek but...