Search results

Create a query contains the columns you need. Type in forms[formname]!txtname at Criteria row in the column where you want the name to be searched. Create a subform or listbox bound to this query. add this in the click event of the search button: listbox.recordsource = ""...

You can use currentData.AllQueries to list all available queries to a listbox. Once user click a queryname in the listbox the query will open. when the listbox is clicked The query you want to display perhaps have similar name like "qrySales2003, qrySales2004" for example. Change criteria so...

That may also because your right on your pc expires after a certain time period, or may be the library file is located at a remote location.

Thank you all for your reply Both arrays are contains random numbers, but they can be sorted. Example #1 Array1 {1,2,3} Array2 {1,1,2,2,3,3} By comparing two arrays, the result should tell that the second array has two copys of the first array. Example #2 Array1 {1,2,3} Array2...

Well, If I combine array1 {1,2,3} I will get "123" and If I combine array2 {1,1,2,2,3,3} I will get "112233" I am not sure how you can compare this two, they are two different strings.

I was trying to compare two arrays, to identify whether one contains another Both arrays are sorted, for example: Array 1: {1, 2, 3} Array 2: {1, 1, 2, 2, 3, 3} There are two copys of Array 1 in Arrary 2. I wonder how could I make the comparation possible, for example: I can built two...

Yes, you can use Windows API in your VBA code.

You can have a separated field in your database like "Serial" for example to record the a human readable serial code for your data. The ID and the PK are only for computers.

You need set user permission to only "Read" an object, disable "Write". Use "Tools->Database Security".

MS Access has a built in authentication feature since the first version. If you are using 2003 then use "Tools->Database Security". If you are using 2007 version, try to find user permission command from customise tab dialogue. After you set security, every time some one open the database, he...

Import tables (either link or data) from your other database. Create a query that insert each record from the imported table to your master database table. Make sure you do not select the ID field. New inserted record will have its own ID assigned by Access if you are using Auto Number type as...

Use DoCmd.OutputTo command. But I am not sure this command is available in A97

Is that really an error message? You can make yourself a function that replace or delete "0-9" characters in a string. For example: msgbox(errorWithoutANumber(err.Description))

You need word to open a word file. You may see a embeded word file open in Access or Excel, but I can asure you that machine has word installed.

If you send your letter via email, security is not a problem. Your client will see the link. If he use outlook, he has to press ctrl key then click that link to open it. You can send yourself an email, to test how it works. Different email agent react differently to embeded links.

Create a public sub, then link all your textboxes ongetfocus property to that sub. Trust me, this is the only way to do it, I did the same thing 2 years ago.

If you have Word or OutLook, you can use "Mail Merge" from tools menu.

Use "DoCmd.OutputTo" command. Check Access help file for parameter explanation. You can't export chart with this command

I think you need some serious VBA and ADO lesson. Add a new record in ADO is quite basic for an Access developer. Dim rs as new adodb.recordset rs.activeconnection=currentproject.connection rs.source=tablename rs.open do while not rs.eof if rs["id"].value = idyouaresearching then...

Check out the database attached. You search table "Book" by book id and represent result in a list box.