Macro / Query - Can't Update

J

Jani

I have a macro that calls a query that I need to update. The Edit Mode on the
macro is set to 'Edit' but no changes can be made... would someone please
advise what else I should check on ? Thanks!
 
K

Kernow Girl

Hi Jani - what kind of Query is it? and what happens when you run the Macro?
yrs - Dika
 
J

Jani

It's a regular query - the macro simply opens up the query - nothing fancy
about it. The query does contain several tables.
 
K

Kernow Girl

Hi Jani --
If a query is based on tables with a one-to-many relationship, you might not
be able to edit the data for the following query fields.
Look in the Help screens for Query - Troubleshooting and it will give you
info on how to alter the relationships so you can update. Sometimes it just
won't work when you link tables.

HTH -- Dika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Need Help with Macro Security 1
Making a macro only work on certain files 2
VBA word change keys 0
Macro to select and delete levels of a document 2
Macro to copy table of contents to a new doc 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Removing a repeated words 0

Top