Search results

I have a query that takes a date value from 1 table say [AreaDate] and a day value from another table say [DaysInExcess]. It then creates a field that adds the two values to get a new value of "NewDate": Example: NewDate : [AreaDate]+[DaysInExcess] I then create another field called...

For anyone reading this and having the same problem, you can solve this issue by simply running your first append query, and then closing access, open access again, and run the next append query. Don't ask me why this works but it does. The key violations that access was giving me were not in...

I will have to try that, thanks for the suggestion.

Yes I meant DSN. And are you sure that's the only way to do it? I have never used the visual basic editor in access. I read somewhere about just creating a DSN file and linking with that, and then after the first use it should be integral to the access file, no longer requiring the DSN file...

I have access 2007 which I have created a DNS to SQL server hosted somewhere on the internet. I need to create a query in access to modify the data on the server side through linked tables, and send this access file to my client to make the changes. Therefore the linked tables have to remain...

I can only load it one way.. there are two tables, one is a base and the other one depends on that base. I load the base table fine, then I try and load the next one and I can't unless I close access and open it again. Then when I load the second table it works. I am populating a new online...

EDIT: @HiTechCoach Sorry, but the names are no better ha. The first table I load is the 1-side, then I load the many-side table. I'm pretty sure I have that part figured out already... but below you can see it works if I open and close Access for some stupid reason. /EDIT Ok, well I...

Using Access 2007. I am using append to move query data from one database to another. Database1 has a lone table (TABLE_A) with one data field Key_ID set up with unique keys and a couple fields filled with records. I am sending the query results to the table (TABLE_B1) in the Database2...