Recent content by LDG1234

Hi guys Can I disable the use of the F11 key to display the database window. Thanks Lloyd Gozzett Process Developer

Hi guys I have a quick question for you wizards out there. My database is used my multiple users and they are updating records. The update screen retrieves the record for editing by way of the recordset that I have written. It is possible for multiple users to open the same record for...

Thanks for your help on this one. I opened a recordset before I opened the report which displayed the recordcount in a message box and asked the user if they wanted to continue. Works nicely but thanks for your input on this one. Lloyd Gozzett Process Developer

Thanks Wildhare Only getting 0 each time I do this. Any other hints please??? Lloyd Gozzett Process Developer

Hi guyz... Need to display a message box with the number of pages for a report they know how many pieces of paper to load... Thanks Lloyd Gozzett Process Developer

Hi guys Hope you can help. I need to do the following... I have a table with a list of customers with a contact date. There are multiple customers, many which have the same contact date. I want to write a function that will go in and check which customers need to be contacted every morning...

Hi guys Can anyone tell me what the maximum capacity of an MDB file is?? Thanks Lloyd Gozzett Process Developer

Thanks guys......thats really helpful Lloyd Gozzett Process Developer

HI guys... i hope that you can help me out. I have a mass of data which I need to analyse, specifically by lots of different criteria, but I need to calculate in blocks of months. Does anyone know how to group on calender months?? Eg. Date Volume 01/01/01 2 04/01/01 3 08/01/01...

This was just an example of the usage. I have a fairly complex function that is executed on the click of a button. It calls lots of different functions and then the last piece of code will prompt the user for a reference number for audit purposes. This is where the input box comes into play as...

This is in the code that I have written: ie Me.Name = InputBox "Enter Name", "Please enter your name" Any ideas for this?? Lloyd Gozzett Process Developer

Hi guys Is there a way to make an input box mandatory??? Lloyd Gozzett Process Developer

Sylv Not sure you understand my query fully. If I have the input mask on and they dont enter it correctly you get a Access Msg Box saying: Incorrect Input Mask Format "LLLLLL" etc etc. This means absolutley nothing to the users so I would like to replace this with a specific message...

Try this link: http://appdb.codeweavers.com/ Lloyd Gozzett Process Developer

Thanks Slyv I don't want the message to be displayed everytime that a user enters the cell as this will slow things down and would start to frustrate people. I just want to adapt the msg which is displayed when that entered does not match the input mask. Any ideas? Lloyd Gozzett Process Developer