Recent content by Swillsy

Hiya Pat, Thanks for your help working out the problem, the ondirty saverecord didn't work but I realised that the updates would be looknig at blank records so Halfway through I paused the code then me.recalc and its working now. Thanks again James

Hi All, i've got a very strange problem with an update query. I have a linked table that I grab data from and put into another table using a select query - this works fine. I thne run a query to update info from this table to another table using the code below. The problem that is occuring...

Hi Dcrake, Thanks for Reply I didn't know you could format the autonumber. the work around i created in the end was to create another table: Autonumber column PersonID column Name column Then I used a form where you enter in a name and in the PersonID field I used some VBA to basically add...

Hi All, Ive got a problem with my table design I'm hoping someone might have solution for: Noramlly I have studentIDs generated on a central database which links my whole databse together. However I will need to generate new numbers for non-students so that the database is still linked...

Just a quick update - the code from my original code should work to update the table. however having talked to the administrator it became clear that there was an issue with permissions allowing me to update from the table. As a workaround I created a table to select into records then updated...

I'm not keeping both tables because I can only update data on one of the tables. So im moving the needed info from the tblStudents_Current into my table Applicants. I have tested it a bit and Its not the WHERE clause of the SET values that cause the problem. It seems to be the way the join...

Hi MSAccessRookie, thanks for your swift reply. I wasn't sure whether its needed either tbh have tried it with and without the WHERE statement and stil lget the error which is why I'm sure its a join issue. Basically I am changing a table by adding extra columns and need to update the table...

Hi, Im trying to make a query to update a table i just added an extra column too however I'm getting an error: this query must be updatable I think it has something to do with the join in the query. How would i go abotu creating a outer join? Heres my current query: UPDATE Applicants...

awesome thanks for advise Nightmayor :)

Hi Nigel I think the admins here changed the index which is why it suddenly stopped working. the students can have 2 addresses on the system which is probably the reason why it has changed. Swillsy

Ok I'm an idiot as you can see very clearly see the index changes in the Addresses table to Per_Person_Code instead of Person_Code Thanks for looking anyway:) *runs to dark corner*

Ok here is a dummy form attached. It is replicating the same problem I have been having with the worknig db. The form will update the student info,course info but it wont change the addresses. The tblStudents,tblStudentAddresses,tblStudentCourses are central databases which I cannot change.

Hi Nigel, sorry been busy enrollnig etc last few days will put up a dummy form and tables shortly. Yes I jsut started at the uni on monday and my code is very amateur because I havent been taught any vb yet, so I have jsut been picking it up as I go along:(

no gary its for emailing reports to users who aren't using the database. and instead of installing the snapshot word addin on all the machine I would have prefered to use word .doc files. Thanks for explaining why it cannot happen though. Swillsy

Hi Bob, I did at one point put the control source as a query and it displayed the records however it wasn't allowing me to change any of them. Thanks Swillsy