Search results

Hi guys Thanks very much for your help. CJ ;you are very observant. Changing the quotation marks fixed that problem. John, I'm using Access 2010 and when I try your code I get a 'Run-time error '5': Invalid procedure or call argument. datafiend

Hi there I'm following the code that appears in a number of posts about how to open one database from another database. I'm using the following code: Private Sub Command0_Click() Dim appAccess As Access.Application ' Create instance of Access Application object. Set appAccess =...

Thanks for your reply Big Pat. Yes, it has to be Word as the person who wants it wants to be able to send it to users for editing then be able to use the Word track changes feature. datafiend

Hi there Is there a way to export a report from Access into Word so that it keeps all its formatting etc. The only option shown is in RTF format. Thanks for your help. Datafiend

I posted the thread 'Adding a number to a field' and now want to mark it as 'Solved'. I've followed the instructions - opened it, clicked Edit, then 'Go advanced' but can't locate any dropdown next to the word 'Title'. Am I doing something wrong? Again? datafiend

Thanks very much CJ_London and plog for your replies. CJ, your solution worked fine. I had tried autonumber but didn't know I could set it to start at 000... datafiend :)

Hi there I have a table with 100,000 plus unique rows and I want to add a column (call it 'ID') and place a value in each row starting with 000001 and adding one on to each row. Is anyone able to show me the correct code to do this. I've tried with various combinations of For...next but can't...

Hmmm Lagbolt. that's worth thinking about. My reason for this is because I am only linked to tbl Ttransactions as it belongs to another section and I can't change it, but maybe I can run a from it and add a field, populate that field and use that. Thanks to both of you for your suggestions...

I have a number of names and Ids in a table (TblTransactions) and a subset of these in another table (TblSubset). The values in tblSubset are unique. I’ve written a function for a field in a query that I want to populate for each row from tblTransactions with a ‘Yes’ if the name from...

Thanks very much for your help and advice. ;)

Hi there Below is a simplified version of what I'm trying to do which is to combine the two wildcard statements into one statement so that I don't have to repaeat the table and field names again. In my actual query I've got so many of these statements that I've exceeded some limit and cannot...