Search results

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...

@Trimmel: you'r such a bad faith, it's almost funny!!! - Check my signature: my ref. to office is clear. - Automation does not work with Opers: it is admitted by every using that package. - I now realize that report events comes with the app.; so for my apps created with A2007, they work fine...

Is it transferring auto the bar code read to the field selected in your form: I forgot the procedure so I don't remember if Windows treated it as an input device or if the installed DLL was taking care of the conversions...

You, friends of MS, are all the same: avoid talking about the real think... First your quote is truncated: I do not talk about Office 365 but Office 365 personal. There are at least 3 versions of office 365! Do you use Activex ctrl? I do and there gone!!! Do you connect to Excell files or...

@HiTechCoach:At what time does Access updates the register? When selecting add?

@HiTechCoach: none of MS stuff list explicitly the draw back with A2013. Problem with links solved!