Search results

Hi JHB- You make a good point. (I forgot about the Checkbox background)....but my code fails on EVERY controltype. ArnelGP - Nope - Each subform is a SINGLE record, so that shouldn't be a problem. Since I need to get around the checkbox issue, I may as well change the LABELS for all unmatched...

Hi All Despite HOURS of one-on-one training on how to prevent the capturing duplicate records, I am still called on a weekly basis to merge the information of two students (Who are in fact the SAME person) Consequently, I am developing an unbound Parent form (FRM_DUP_Student) that contains 2...

Hi All At the boarding school that I work for, students frequently run away. If we are unable to track them down within 24 hours, we are obliged to file a 'MISSING PERSONS' report with the police. I am able to extract much of the information (Student details, parent and family member contact...

Of course that's the answer! I was obviously in 'over-analyse' mode again. Thanks for your input.

We need to complete a number of 3rd-party application PDF document for each student at the beginning of each term. For example, We need to fill in a separate application PDF document for each of the following: 1. funding for each boarding student. 2. To request that Centerlink arrange (and pay...

Hi Sajara As I understand it, if you run a DELETE query on the SP table, this should delete all the records, but keep the table structure in tact so that you should not need to rejoin the table. The above DELETE query will empty all your records before you do the update. Hope that helps.

Hi Sajarac. If I understand you correctly, then you have two identical tables. One in the Access database and one in Sharepoint. . . .and you want to synchronise them. Provided that your users are not changing the data on sharepoint, then you could use a query (or two) to update Sharepoint. If...

Awesome - Thanks - I Got it working like a charm!

I had something similar (with a pass through query) the other day. It turns out that access doesn't like the query to be on the server. From my limited understanding, you should be able to create (and use) the query from the access front-end. This may help...

Hi all My users are dismissing messages that I display with a standard msgbox. I therefore want to display a bespoke 'msgbox' that looks completely different to those displayed by the system. That way - they will (hopefully) take more time to read the message - and answer the question properly...

What about trying to use File\Options\Office theme?

Thanks Ranman - I like your thinking. Will give this a go and see what happens. Ridders : That was my first port of call too.

Hi All Before putting my problem out there, you n eed to be aware that I am working in a very different (technically challenged) environment which does not necessarily lend itself to automation in the 'ideal' world scenario. Hence the following (partly manual) process. In my Stu_Student table...

Hi Glaxiom I put in a qdf.Execute statement as suggested. I still cannot get it working. I am wondering of there is something wrong with my ODBC connection? It used to be able to connect to the database using the 'SQL Server' driver, but my system crashed (like TOTAL wipeout) the other day...

What you are actually saying here is that the departments used to have a 5 character code and they are now changing to a 3-characters code. So then, they are NOT 'set in stone' FOREVER. My point is that sometime in the future, (maybe even 10 years from now) someone might decide to go back to the...

Hi All further to https://www.access-programmers.co.uk/forums/showthread.php?t=294892 I am have now converted the queries to stored procedures (in the back-end SQL server) as follows. I have a SYSTEM DSN connection using the 'ODBC Driver 13 for SQL Server' But they are not firing for some...

Thanks again Im not too concerned about it right now since you have clarified that (in my case) access will parse the query for the server to handle.

Awesome - Thanks I have learned something new again. All my tables reside on the server, so there should be no issue here. Hmm . . . . In light of the first comment, this is not really an issue to me any more. However (for curiosity sake) ....I found that after closing the form and re-opening...

Hi mtagliaferri I the number of departments seem to be 'set in stone' . . . for now. But what if there is a reshuffle or the department name changes? I would think about creating a department table and then doing a simple DLookup. That way, you don't have to change your code every time there...

Hi all I currently have an access Front-End with a SQL Back-end. I recently read that when queries (which reside in the front-end) are run, that ALL the data in the linked tables is sent from the server to the client before any filtering, sort etc is applied. The client then does the filtering...