Recent content by ITMannie

You can use Update and Delete queries to do what you're asking for. To change the incorrect names I would set the criteria on the Update query to return the relevant records then set the correct value in the Update To line of the query. Delete queries are even easier to use as you just set the...

Have you got the data type of the column set to AutoNumber? If so, that would cause the problem. Change it to a Number Cheers

Good point Skip. I forgot to mention in my last post that it would be unusual to reach that row limit in Excel. Cheers Iain

Hi I think it's also worth mentioning the Domain Aggregate Functions that are available in Access. In particular, the DLookup function would do here. The code would be: txtValue = DLookup("[FieldName]", "QueryName") or you could just set the control source to...

John I guess you'll just have to extract the data from Access row by row and keep a count of the number of rows you are importing. When you reach the limit of an Excel sheet, just create another worksheet and assign it to your worksheet variable. Your code would look something like this (I...

I take it your ValidateString function returns true or false. If so I would do the following: 1. On the Access form, select [Event Procedure] for the Before Update event and press the build button (...) 2. In the before update event, put the following (substitute txtField for the name of a...

Sandhu I would extract the comments and put them into the column next to the one containing the data - then import them as usual. The macro would be something like this: '================================== Sub ExtractComment() Dim RowCount As Long 'set these constants to suit your...

Since you have multiple parent/child relationships, you will have to query the data for each parent item and export the data into Word (I would create tables because you can access specific cells). This would be a pain. Have you considered using Snapshot files (this is one of the options when...

It's not your day - have you tried kicking the crap out of your PC (that sometimes does the trick - at the very least it makes you feel better) I've never had problems with shortcuts other than incorrect paths. Have you got anything unusual in the shortcut? You could try creating a new...

Here you go. This was top of the list when I searched on Google. http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20082719.html There are bits of code and useful links. Hope it helps

It's not clear what the problem is. Sometimes when I get errors that don't have any explanation, I just open a new database and import everything I need from the other database. It can sometimes flush out the errors. Give it a try. Cheers

Save your money. I found some code that will return the password on and Access 97 database (don't know about later versions). I will have a look for it again. Keep searching the internet - it is out there. Cheers

Gladys You won't get errors unless the data is invalid in some way (i.e. doesn't meet the validation rules or constraints). If your update query links the tables on their key field(s) by the default INNER JOIN, then Access will only update the records that are in both tables. When appending...

Gladys I assume you are looking for one query that will do both the Update and the Append. I don't think you can do this. I would create separate Append and Update queries then run them in sequence using a macro. Hope this helps.

You don't have to check if the form is loaded. If you just want to ignore the error you can put On Error Resume Next before you set the value on the subform. So you will have: On Error Resume Next Forms![frmOrderStatus]![zfrmCRM].Form![zfrmCRMNotes].Form![ONote] = Nz(rst!OCmt, "")...