Search results

Thanks for your suggestion. I found a way thats meant to do it using a union query. The idea is: GROUP the union of two tables on all columns, then if the two tables are identical in all groups will result in a COUNT(*) of 2. But for any rows that are not completely matched on any column in...

I want to compare all fields in two tables (one of which has just been imported from excel) They are called tblStudents and tblSIS. Both tables contain exactly the same information. What i am looking for is something that will tell me either if a record is missing from tblStudents (for instance...

It works :D :D :D Thanks both of you for all your help!

At the moment the first recordset only inserts 1 record and so does the second and there will never be more than two thousand altogether. Is it because exSheet.Range("A1").End(xldown).Select selects the last cell in the sheet? Because at the moment i can see it inserting the first recordset...

Its now highlighting Set xr = exApp.ActiveCell.Offset(1, 0) And saying application defined or object defined error?!?

Im still having trouble with this; has anyone any other suggestion please, its driving me mad! I want to insert the new data from the second recordset into the next empty cell, thats why im trying to use the end(xlDown) and offset

I made a separate table for space cause it was the only way i could figure out how to update the recordset containing space

dp_no is a department number. Thanks for your help Gemma that works now, should have figured that last bit out for myself-think i need some sleep!! Thanks again

Hi Gemma, thanks for your reply. Someone suggested the way below before i read your reply. It works but an error comes up when a tutor runs out of space saying the values are prohibited due to the validation rule >0 in the tblSpace. Is there a way to ensure in my code that space doesnt go below...

The original system was designed so that it does store students and calculates space from this as you suggested Gemma but now we've come to a roadblock where it might not be possible to store student information on the system so i may have to go about it this way by initially saying how much...

Hi there. Is it true that you cannot update a recordset if it has a group by clause? Im trying to make sure that a tutor has space (TU_SPACE) and then decrease their space by one when a student is assigned to them but the following results in "cannot update database or object is read only"...

Think it has something to do with quotation marks. Im not the best with this stuff but maybe try: "[Surname] = '" & Forms![License]![Surname] & "'")

I tried that. It inserted it for the first function and then an egg timer appears on the excel sheet so that eventually i have to end the process

Ive changed things around a bit. Now in the first function im creating hte excel sheet and copying from my recordset into it and in the second function i am trying to get that spreadsheet and add to it. My code looks like the following. Contained in the first function: Set rs3 =...

Sure i'll show you what i did and then you can adapt it to your tables. Firstly i declared replacedept as a string. Then the following dlookup found the department name from tblDepartment where the department number was equal to the number on the form. So maybe you could look up the housename...

Dont know if this is the best way to do it but i recently had something similar. I got about it by creating a variable that looked up the value i wanted (using a dlookup) and then inserted that value into the bookmark.

Its not two separate functions but its contained in two separate functions that run one after the other. I took out the On Error Resume Next line and it then highlights With objXL.ActiveSheet.Range("a1").End(xlDown).Offset(1, 0) And says Application Defined or Object Defined Error; this happens...

I thought im only creating a new instance of excel if there's not one open already-no?

Hi i have two modules; both contain the code below to insert entries into an excel spreadsheet; this code works for both modules separately. However when i run a sub that runs both modules one after another, the 1st modules entries are put on the spreadsheet but the second modules entries are...

Wondering if someone could help me with a subquery (i only learned they existed today) Is it possible to have multiple criteria in them? For instance i want a TU_CODE where they're in a certain faculty, tu_only is false AND where the number of students they already have (gotten by me trying to...