Recent content by JLCantara

CJ forgot one possibility: a 6 day schedule, to avoid the same class falling on holidays... I have made an app for a college here (30+ years ago on a HP250) and it is very tricky: one must constantly check for possible conflicts with already assigned records.

You will find an attachment that represents a possible solution to your OP. It covers all your needs without the use of 'temporary default value' since the user is able to filter the question/hypothesis at will. Good luck, JLC.

@BT: you are right and I was right too; here is the story. When I subscribed to O365, I choose the French version: lets call it O365.fr. Most of you guys (if not all) use O365.us (that is the us English version). So you are using A2013.us while I was using A2013.fr. After your post, I started...

@Trimmell: don't say it's possible say how you can load any Activex and perform automation... I posted something in this forum and no one could help!!!

@Gina & Trimmel: your stubbornness is just appaling: you are misleading people!!! A2013 can do both web and desk top app. I do not give a s.... about web app: it is so primitive that it is not worthed any comments. If one is ready to forget about automation and Activex, well go...

@Jaye7: you do not have to convert to web app to use A2013. If you are happy with A2010 stick to it. A2013 (desktop) have many limitations: check the other posts on the subject...

It's not that a basic problem since out of 107 pers. who visited your post, no one proposed a solution. 1 - You need 2 tables: one for the Questions and one for the SubQuestions, linked to Questions. 2 - Make sure that the records are numbered so that they can be presented in proper...

@APeters: if you adopt a constant location for FE and BE, on first load you app can update the registry; see the following link (not sure it will work with A2013): http://vba-corner.livejournal.com/3054.html

@BTrimmell: using Laptop: Acer 14". OS: Windows 8.1 64 bits. Off.: Office 365 Personal. App: Access 32 bits, desktop. I tested the functioning of trusted locations: I must tell you that your are wrong. Registry updates are done by Access when accepting mods. One very strange thing...

If your not using A2013, there is, among the Acivex collection, a TreeView that is rather easy to use. You will also need a special table to store you tree.

@Alfredo: the solution is quite simple but you will need some knowledge of VBA. Attached is a sample relationship; I do not pretend that it's a solution but a caneva used for the sql solution: PARAMETERS prmAccount Long; SELECT Accounts.Account, SaleReps.SaleRep FROM SaleReps INNER JOIN...

As I mentioned I do not remember all the procedures I used. At Domfer, the PC receiving the bar codes needed a DLL while at MultiCaf a DLL was necessary to GENERATE bar codes but I didn't know that reading was a pass through.

@Moore: there is a problem with your method. You are XORing an integer with a long. Wonder what's the result. I propose that you convert the result of Asc to byte then XOR it with a byte Salt. Note that your method is very easy to break.

First, you never start wandering about forms when DB structure is not set. Attached, is a solution to your post. You will need 2 forms: frmContacts, the main one, having a combo to select the contact. The 2nd one, frmContactSkills, is a sub-form of the previous one (Contact is the link...

According to the bold characters in the OP, SalesRep should be linked to the account. On the other end, Spike's question is quite pertinent. By the way, it's the first time I hear that a bank is using Access to manage accounts...