Search results

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...

Sorry, I am getting: Execution of this application has stopped due to a run-time error. The application can't continue...... These are only happening in the runtime version on my virtual machine and the clients machine. It all works perfectly in the full version of Access. I am wondering if...

Hi All I am hoping someone can help me with this one. I am developing an Access database for a company in London in my spare time. I develop these at work also. All the work machines are running XP with Access 2010 runtime installed, obviously my dev machine has full version of Access 2010...

What is your email? I will send you a db I am working on for work (with no data in) that uses recordsets and email automation which works that should give you something to work with... you can pm if preferred.

PS dont forget those naming convention I talked about specifically on those controls in the forms.... your combo box is named txtUsername when it would be better calling it cboUsername :-)

Hi Trisha The issue is in your SQL and the Combo box. The combo box is returning the primary key as the value (you can change this using .text) yet you are asking the sql statement to look for a LoginName that equal 1 or 2. You can change the sql where clause to WHERE ID = combo box...