Search results

Hi mubi_masti, Have you actually read my post and followed my instruction? Have you actually tried it? I don't think you have. :mad: You slacker! :D If you had you would have seen that my method generates the SHIFTS and TIMESLOTS column in your XLS. I attach the zipped mdb that shows you how...

Hi mubi_masti, Having now seen your xls and what you are trying to do, we need a completely new approach for the solution. This is because at the beginning I was thinking that we were dealing with signals and discrete mathematics, whereas now I can see you are creating a timetable. It will...

Hi mcktigger, Well done - I was about to suggest that to look into using Access 2010 because it has native PDF output facility. But you beat me to it! :) Nice codes that you have written there, it will sure help others using AC2003 and wish to generate and email PDFs - one to keep for the...

You are becoming lazy and asking for too much! I might start charging you! What you can try is to add a IF-THEN statement in the function that: if the value is 13:00 then add an extra delay of 1 hour from then on. I am sure you can achieve this - but if you are stuck, just give post here again...

Forgive me to be contrary to what has been said. One way hash functions were designed for security purposes. That is to say that: even if your adversary obtained a copy of the function (i.e. the vba code) of the hash function, and also obtained a list of the encrypted password(s), there is no...

Hi Ramshan, How about importing that word document as a table, then using a query, joining your original table and the imported table using the ID as the join? You can then get a list of CountyID and CountyName which are matching.

Hi JesseH, Also take a look at Dropbox. You get 2GB free online storage. Once you've installed the dropbox client software, a folder called dropbox is created on the computer. Any updates to the dropbox folder (where you can put your database there) is saved automatically to the cloud storage...

Yes you simply use the convert to date function: CDate and convert the output from the function IncrementValues() to a formated time value with am/pm. I've done the work for you :D Output: format(CDate (IncrementValues([SR],intBASE)/24), "hh:mm am/pm") [SR] is the value from your SR column...

Hi bakkouz. You should be looking at a hash function. It is a one way encryption. Common ones are MD5 or SHA1 (google them and have a look) The idea is that: when a user saves his/her password, your code encrypts the password using the hash function, and saves the encrypted version in your...

Hi lifeis, How about using a make-table/append query and download/merge those two remote tables into one table into your MDB locally? You can then query that local table instead.

Hi Marlan, The following code works in Access 2010. Maybe you can give it a try. Sub GetMACAddress() ' get a list of enabled adaptor names and MAC addresses ' from msdn.microsoft.com/en-us/library/windows/desktop/aa394217(v=vs.85).aspx Dim objVMI As Object Dim vAdptr As Variant Dim objAdptr...

Hi mubi_masti, Try this: Function IncrementValues(intSR As Integer, intBase As Integer) As Integer IncrementValues = ((intSR + intSR Mod 2) / 2) - 1 + intBase End Function intSR is your SR value, starting from 1. intBase is the base value that you wish to set (from what I saw, it is 10)...