Search results for query: *

Hi, It works and I feel dumb. Thanks, saw the extra comma and forgot to place the table name. I appreciate your help!. Ken

Hi, Sorry took so long. I did what you suggested and received an error: Run-time error '2006': The object name " you entered doesn't follow Microsoft Access object-nameing rules. Thanks...

Hi, I would like to import a Dbase file into my access database using the api browser. I have all of the code and the dialog opens and I can select my file. The problem is when I try a domcd transferdatabase, I can't seem to get it right. The error is: run time error 3044 'C:\data\paradise.DBF'...

Hi, An easy way is to do this is to create a word document and select the mail merge wizard to guide you through. After linking your access database and creating the letter template, select the insert word field, (if then else) to create your multiple paragraphs using the Apr field(s). If you...

Hi, In design view of the form in question, in properties for the form go to the event tab and onopen add this code.... Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub Hope this helps.... Ken

Tarena, If you intend to have any one of the three fields below 80 change to red...make sure of the formatting of the fields, if is set to a format percent and the values are entered as .80 instead of 80. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.First.Value...

Hi, The "keeping together" should have taken care of this. I have created a sample database and this works fine with 4 lines per record. If you would like to keep the group by itself on page, break after the group, by changing the group header property to force a page before or after the group...

Hi, Make sure in the sorting and grouping for your report, Group On: each value Keep Together: whole Group Hope this helps.....