Search results

Well, it's just another way to store data (think about the cubes in datawarehouses). Vectors can be far beyond 3d (think about 10D etc). The logic between data is well captured in a relational database, but when searching 'text fields' you have a problem because of the physical storage of a...

Of course, the generated query will be wrongly generated by access. You'll have to make subqueries by hand and use union all Make a new Query Select your table make a new expression called: date()-[tablename]![tabledatefield] (replace tablename and tabledatefield by your database datefield)...

Vassago, you can define your own schema.ini . Put the schema.ini in the same directory where the import/export takes place. There is VBA code to convert import/export specifications to schema.ini, all you need to do is typing schema.ini and import/export specifications in the ms knowledgebase...

Hi Systemx, there are some vector databases out in the world. Lately I heard on the radio a dutch company designed a vector database (multiple coordinates to store data) to enhance text search. Instead of ansi code the text is being stored as vector data which massively enhances searching...

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)?

Thank you, now I know how to get the mail address in outlook. Only thing I miss is exporting the current record in an attachment

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

Thanks for the replies. I downloaded sql server express as it's a project which is not at my work. I have mucht ADE experience and that's why I didn't want to rebuild all the queries which have form references. I will try ODBC or linked tables and will check at the server side or everything...

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

I've created an access project (adp) and placed a reference to a .chm helpfile in the helpfile property of the form. When pressing F1 it's not working, microsoft acknowledges the problem as a bug in access. I've used the workaround as described in kb 275117...

I've tried shift enter didn't work. Didn't change standard behaviour

Is it possible to use <enters> in text or varchar fields?? In this way users can easily switch to the next line instead of typing everything all together

I've made an adp (access project ) file. I want to permit some users to look in the data but i'm not certain they have access installed, can i give them read-only rights by placing a data-access page in a network map? Can they use the functionality of a data-access page without having access...

I would like to use an infolabel to send the contents of a record by mail. One column has the mail address of the 'owner' of the record, how can i fill the 'subject' of the mail and the body with the desired parts of my record? Here's an example of a record From Description...

Every form has an on error property. Is it enough for error handling to code the on error property for each form? With enough I mean error handling which lets you resume the program. Ontherwise I have to code (or call a procedure) for each coded event which i wouldn't prefer For instance now...

Platform : access2003 / sql server 2000 How can I document my project automatically? I would like to have a 'query option' to see which sql server object is being used in which access object. Anybody known with a addin tool or 3rd party tool to accomplish this? The odd thing: when working in...

Within your standard menu you have the menu choice 'window',and in the bottom all activated windows are being displayed. The currently activated window has a sign. I made my own menu with also a menu called window. I can't find the 'runcommand' macro action which lets me view the current...