Search results

Hello, I have a question I am trying to find a network printer by using a function and wia object. On a local PC this function works just fine but on a network it doesnt. Does anyone know how to fix this? This is my code Function SelectDevice() Dim DevMgr As WIA.DeviceManager Dim DevInfo...

Did you compile the code before you created your runtime front end? Also make sure that your procedures do not open reports in designview for editing etcetera . Design view is not available in runtime, you wil get runtime error. For as far i know shift bypass is not possible in runtime

I suggest you use the WIA object to automate the scanning process with VBA I recently needed to build a scan application in MS acces. Found some good information about how to do this ://stackoverflow.com/questions/17008480/scan-multiple-pages-with-adf-scanner-using-vba

Thank you for your reply. I found a way to solve these issues by setting my 17'' laptop screen properties to the resolution settings of a 15'' screen Now i can develop my forms in a 15'' resolution enviroment. This way i am sure there wil be now screensize issues.

Hello there, I've created an MS access 2013 application on my 17'' laptop This application wil be deployed on many different computers with different screensizes.. Keeping that in mind i developed small userforms so that ther should be no issues with the form size on computers with 15'' inch...

Yesss i found a way Created a sub based on a thead i found on the internet Sub DeleteFieldProperty() Dim tdf As TableDef Dim curDatabase As Object Dim fld As Object Dim prp As DAO.Property 'Get a reference to the current database Set curDatabase = CurrentDb 'Get a reference to a table Set...

i need to set the date notation to 24-12-1977 instead of standard format. the fieldtype DateTime is ok but in the properties window of the field i need to set the date notation to short date.

thanks for the replies i need to make this change to multiple application tables so therefore it has to be done trough VBA.

hello everybody, i am trying to edit a datefield propertie into short date format trough VBA but its just not working for me . this is wat ive come up with so far DoCmd.RunSQL ("ALTER TABLE tablename ALTER COLUMN fieldname TEXT(255);") this is a text field propertie change and this works just...

Hello there , thanks for your response to my question. I just received an email from my webhosting company. They informed me that SQL databases on the servers are not available for remote applications..... But never the less i have learned quite a lot while searching and trying to find the...

does anyone have some suggestions for me? keep getting error : Connection Failed [HY000][MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on ''my ip adress' (10061) also titlebar of the ODBC connector form display's (application not responding). i've tried to reinstall several times but...

Good afternoon, I just registered at this forum. My name is Bas and i'm from the netherlands. Programming in VBA is a hobby of mine Got infected with the programming bug a few years agow. I earn my living as Captain of a inland oiltanker. I've developed a planned maintenance systeem in MS acces...