Recent content by hmushtaq

I would like to sincerely apologize to all the readers for not knowing the etiquettes of posting, as I don't use the forums very often. But I do know now and will adhere to the rules of "cross posting". Due to the short deadline to finish this project, I got desperate to get some answers to my...

Thanks The_Doc_Man. I thought about the Union queries. But then I am worried if it is going to be a good design practice. Or do you recommend me separating the two types of contracts not to overcomplicate it for development? I am concerned about the ease of use also. Do you think my proposed...

Thanks jdraw. I have the test data along with the business rules. The "Agency" is any organization that fascilitates us in issuing tickets while "Airline" is any organization that provides us the means of transportation. We deal with them separately based on the individual contracts we do with...

I am designing a database for the ticketing department of our company. Along with dozens of other tables, I have 2 tables namely, Contracted Airlines and Contracted Agencies. I would like to store the scanned copies of the contracts that we do with both the airlines and the agencies. The other...

Honeslty, I haven't been able to get something of the like you have asked for. There is normally a one-day error on some dates upon conversion. Two days is what I haven't experienced so far. Should be a max of one-day error. What is the hijri date you have that's producing this error?

try this example database. if the problem still persists, you can send me what you are trying to do through your code. I may be able to figure out where you went wrong...

Copy all the above code, open the VBA editor in your Access Database (using Alt + F11 shortcut), select Insert from the menu bar, and select Module. Paste all the code in the newly opened window and save it once you are done copying. You can now use the functions imported in your newly created...