Search results for query: *

hwkranger When you use a form reference as criteria inside the code, must put <<“ &>> at the begin and at then end. Also double quotation marks at the string, for example: [DAILY OUTAGE TICKETS].RecoveryType = “&quot;Recovered”&quot; If you use the expression << qd.Execute>> and the querydef...

Roy-Vidar Thanks for your replay. Unfortunately i didn’t forget to give all needed permissions for new tables and queries. I believe every thing is correct. I’ve done the same in Access ’97 and works fine. I don’t know what the wrong in Access XP is.

I have a secured Access XP database. I 've gave full permisions for tables and queries to a new group &quot;YPALL&quot;,put when a user of that group is logged on and open the data base,cannot make a new table by running a make table query or make table from data base window. Why that happens...

You can have access to the fields for any recordset like this: DIM DB AS DATABASE,RS AS RECORDSET,N AS INTEGER,ST SET DB=CURRENTDB SET RS=DB.OPENRECORDSET(&quot;<<TABLE NAME OR SQL STATEMENT>>&quot;) FOR N=0 TO RS.FIELDS.COUNT-1 ST=RS.FIELDS(N).NAME 'IF YOU WANT FIELD'S NAME OR...

flyax63 I want to thank you because of your example i found a solution to my problem, that was to open any file from my code. Thanks very much GNIKOL

Hi pansophic I'm a VB and Access programmer. I've already used mscomm control so i know how it works. Now i'm working on a very difficult project. I have some voice files in a folder.I want to make a call to telephone numbers that are stored in a database,and when the receiver answers to the...

THERE ARE TWO WAYS TO PRINT LINE BY LINE 1)USE OPEN STATEMENT Open &quot;LPT1:&quot; For Output As #1 Print #1, Tab(4);TEXT1; Tab(19); TEXT2; Tab(33); TEXT3'FIRST LINE Print #1, Tab(4);TEXT1; Tab(19)'SECOND LINE .....AND SO ON Close #1 2) USE OPEN STATEMENT TO MAKE A FILE Open...