Recent content by carl6885

Hi All Looking for a little bit of help on a strange one..... I have an Access Database (mdb format) that users opening using Access Runtime 2010 (has to be this where I work). Within the main form there is a listview loaded with any number of records. When a user double clicks on the...

Hi, you could use the NET SEND API, in order to do this you need to know the computer name or IP address. Example from Immediate Window in Access would be: Shell ("NET SEND " & "ComputerName" & "Message", vbNormalFocus) You will need to ensure the functionality is turned on to allow...

Hi Thanks for the advice, didn't think to debug that way..... I did any modified code slightly to: if not isnull(control) or listbox.listindex <> -1 then msgbox(something is selected) end if this seems to work now no matter how many controls allowing me to add the where clause. Thanks

Hi Guys/Girls Im having a little trouble and I can not seem to fix it.... i'm tearing my hair out! I have numerous controls on a form including combo boxes and list boxes which are effectively used to build an sql statement based on values. I need to check whether any of the controls have a...

Hi All Hoping someone could help me with this as I can't seem to find anything by Googling... I have the navigation control on my forms (new control post 2007). I have numerous tabs on it. Within the tabs it shows the assigned form. My problem lies within the sub form. When a record is...

thanks for this however it seems to just hang whenever run it forcing access to close.

I have stepped it through and it seems to iterate through every file in the folder no matter what is in the file....

Sorted referencing issue but I can seem to get it to work. Getting the done message but nothing seems to be happening other than that

Also getting error on: Dim fso As FileSystemObject User defined type not defined... this a referencing issue? Thanks

Hi Thanks for this - I can see what it is doing in the code so it should work. Only thing that concerns me is that I dont think it will find the files. The file im looking for would be ID(something else).pdf. Is there a way to find it if there is extra text in filename? Thanks

Hi Little query for anyone that can help. I have a table that has some details in. one field has an ID in it. In one field I have to add a http link to a file that will be uploaded to a file server. The http field will include: http://www.example.com/filename.pdf. filename.pdf will consist...

Hi Thanks for the reply. I have code that checks for a comma and if not it warns as the client wanted, initially the latter option above. They have since they want to be able to just write 5 if 5 years rather than 5,0. The bit I am struggling on is how I allow for both scenarios... Thanks Carl

Hi I have a form with a text box on where a user can enter a value. Providing that value is in the right format it will change it. For example if the user enters 5 or 5,1 they will get the following output when exiting: 5 year(s) or 5 year(s), 1 month(s). What I need to do is ensure the user...

Hi All I am after a little guidance. I am creating a database for someone and for the first time I am being asked to provide functionality that will allow the storage of documents and images such as CV/Resume, scanned ID documents. Now I know its a bad idea to store the images directly to the...

Hi Both Thanks for the responses. vbaInet, I do have a thorough error handling function that alerts the user as well as logging to a data table with the option of emailing the error or dumping the error tables to an excel document for sending at a later time. this is what made it confusing as...