Search results

I'm using ado statements to pass values to my stored procedures. for instance myado.Parameters.Append myado.CreateParameter("Autonummerbusbeperking", adInteger, adParamInput, 4, lngAutonummerbusbeperking) lngAutonummerbusbeperking is declared as a long value and fetches an autonumber. The...

I'm using a 5-tabbed form and have put it in my detail section. Within the on click event of one tab knob i would like to activate some knobs in the form header where the tab resides on. I've coded everything properly but in one or other way access doesn't seem to communicate between the...

I would like to redirect my site to another site while keeping my URL in the browser. I'n using a country domain name which only can be hosted by several companies asking too much money. So I bought the name (with a simple hosting account without mysql) and would like to connect to another site...

I've designed an access ade file (based on sql server) and distributed it at the network. Somebody else has made another database (mdb) and placed the users in a access workgroup file by placing their windows logons into the workgroup file. These users happen to be the same users accessing my...

I would love to publish my product catalog from my access database on a website. it should be a browsable catalog with search field on article number range, product group, product type and should be able to display product pictures. Within my access database i have a link to the product picture...

Necessarily I need to use schema.ini to export a table (it's an ade database and doesn't work with the built in specifications). I'm trying to export varchar fields without " " quoted identifiers(i want it without ") but when looking in MSDN i can't find the syntax to tell access not to place...

Violations of SQL Server constraints or messages about 'nulls not allowed' are not being seen as errors by SQL Server. In this way I can't trap them in an error module to trap and redesign the message. Does anybody know how to trap them to make them user friendly?

One of my probs with access is changing the form when a different resolution is being set. Is there a visual basic module or something else to display the form properly dependent of the selected resolution?

I have a report which shows the products in a brochure like style including pics. When exporting to html the pics disappear. I would like to export it the following way: - report keeps same format, pics are being shown - an alphabet browser (a-z) above the report to easily jump to the desired...

I'm requerying a form after an update. I would like to have the form to be set to its current record when being requeried. How can I easily achieve this? I've seen things about recordsets, I'm working with ADP (based on SQL Server) and don't know or all DAO events will help me.

I have an adp (access project based on sql server) showing records with different pictures. The pictures are ole embedded and the records show the name 'picture', that's no proble. When right clicking the picture field I can copy it to word etc. and it will be displayed. How can I easily add VBA...

is it easily possible to move your access reports to microsoft sql server 2005 reporting services?

i have a mdb and would like to upgrade to SQL Server. Instead of reprogramming it to ADP i thought an option would be using ODBC. is it possible to upgrade to SQL Server Express (put my tables in express) and use ODBC to connect with the database? Would this make sure I do not have to...

i'm using a Ms pivot graph on one of my forms which is linked to a broad query gathering alot of information about sales. It's a very nice ad-hoc query tool though some information might be misinterpreted if you put the wrong fields within a combination. Therefore I would like to store...

Is it possible to design a report which layout will be the same on different printers? I know with crystal reports this is possible, is it possible with the report writer of access?

How can i easily establish the form to filter on all colums? I want to give my users a search inputfield and allow them to filter through all columns at once. Is this possible without a specific query?

I have troubles when a report is being printed on different printers. My standard landscape format doesn't show up on some printers and on some printers a part of my datetime fields break off. Is there a way to design a printer independent report (like in crystal reports)?

I've got information stored per row with the name of the person which data-entried the information. If a user wants feedback from that user on that specific row i would like to make it able to send a mail to the data-entrier. The data-entrier name should be clicked in the row and that specific...

I would like to migrate an access application to sql server. I have much experience with adp but I don't want to rebuild the application. Would it be possible to use ODBC and use sql server tables over ODBC without needing to rebuild the queries in SQL Server? So I want to leave the queries in...

I've made an access project (ade) and stored the admin with password in the ade file. When I open a new database I can use the import feature to import all tables with definitions and data from the ade file. All other objects are being locked. How can i disallow tables from my mde to be...