Search results

for example I have this one table which has two fields: mypage (memo type) and myID (number) and the latter field contains almost 1 page of short size bond paper information. for example this field contains the name or text "criticism", the seach engine will show the MyID with all the hits...

Hi, I am a user of ms access. I am planning to make table where I can input a memo type field for texts informations. I know that a memo type field can hold more than 65000 characters. i know that query can give me a result when I search base on my criteria. Is there any other way to create...

what is your real problem, exporting or looping? gemma is right. you may want to use query. study normalization of database for improvement of your tables and query.

what is the use of your access program if you don't use it.

you already found your answer arvdot. play around with allowbypasskey. try it first on a sample database before using it on your actual program.

if you tried Sam Summers advice to put > on the format properties of your textbox and did not work try this one: let us name this textbox as txt1 1. goto the properties of your textbox, goto Event Tab and look for On Key Press 2. place this code Private Sub txt_KeyPress(KeyAscii As Integer)...

if you pertain to search record in your table, you can make a query our of your tables you want to search and put in the criteria the expression: Like "*" & [] Or Like [] & "*" where [] will be the value you want to search.

you said that those tables are linked together. so probably in your query, you have more that one table that the employee name appears? am i correct? please give us more info so we can understand more.

have you done formatting that field to standard format. you can do that by right clicking that field, goto properties and setting its format type.

hehehe nice one. :)

my advice is to use dsum(select statement) in a query.

As I can see in your syntax above, did you use DIM for your "txt" and for your "reportname". Moreover, what is that date in your inputbox syntax, is that a criteria or a default value? if that is a default value then is should be date(). if that is a criteria then you should also dim it.

if you are trying to say that your database where your tables resides was secured by microsoft database password using Tools->Security->set database password then your solution is found in the internet. Just search for Access Password Viewer. It can crack the password. Maybe it is illegal but...

on my opinion, if God exists in your belief and God is the creator of all things, this include Good and Evil. Therefore, God is the creator of Good and Evil. However, he gave us intelligence to govern all His creations starting from the book of Genesis. This intelligence include deciding for...

wow you have quite a problem there. :) what's the problem using your previous ms access? you don't have problem there isnt it?