Search results for query: *

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

Okay, I can see how this works. I just need to adapt the msg that comes up to explain to the user what exactly they need to input into the cell. Any ideas? Lloyd Gozzett Process Developer

I know there is one out there because I have borrowed code from it before...I just can't thing where. I'll traul through my files and see what I can find. In the meantime, you might find someone else will come up with answer. Lloyd Gozzett Process Developer

Hi guys Can anyone help me with a robust bit of validation. I need to ensure that users only enter alphabetical characters. I have used the IsNumeric function to eliminate all numbers, but they can still enter abc456defg. Can anyone assist???? Thanks in advance.. Lloyd Gozzett Process Developer

Hi Guys This is an interesting one for you. All my users only have access to the forms that I specify in my own security and they can't see the Database Window on startup. My DB holds stacks of info and every other day someone asks for a new report or query. IS there something out there...

Hi guys Just a simple one for you today. I have a date actioned column and I work out how long a file has been open by subtracting it from Date(). This gives me the number of days. What I need to do is to run a query to select the 10 oldest items in the recordset....can this be done...