Search results

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 =...

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

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...

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...

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...