Search results for query: *

I have created a blank database and have imported into it all tables, forms, queries, reports, modules of my Access XP 2003 program. When I open the program, I get the following Compile Error message: Invalid use of property. The mark goes onto: msgbox "My message" . I have checked the...

I have moved into Windows XP with Access 2003. When I click the Preview button of a report, it appears in FIT . Is there a way to change this setting and make it into 100% ? Thanks

I posted this question by mistake to the wrong forum, so I repeat it here: I have a field named 'TransNo' in the MainForm. The subForm is in the Detail Section of the MainForm. In the footer of the subForm I have another field called 'InvoiceID' and its Default Value is set to...

I have a field named 'TransNo' in the MainForm. The subForm is in the Detail Section of the MainForm. In the footer of the subForm I have another field called 'InvoiceID' and its Default Value is set to [Form]![subForm]![TransNo]. The problem is that, when I start filling the subForm with...

I have all my tables in DB.mdb and my reports, queries and forms in MP.mdb . I have a Make Table query qryMT in MP.mdb and want the Another Database File Name, where the new table will be created, to be obtained from a field fileName in tblArea in DB.mdb . Are there any suggestions how to...

I have a main form frmMain and a subform subFrm. On the on-Current event of the subform, I use: Me.AllowEdits = True Me.AllowDeletions = True so that all the records are locked. To unlock, I have created two command buttons, one to unlock the records: Me.AllowEdits = False Me.AllowDeletions =...

Hi, I have a main Form called "frmMain" and a subform called "subFrm", there common field is NotNo. How can I check that a text field called "eacNo", which belongs to "frmMain" is Null, from the on-entry event of field "fName" of the subform "subFrm" ? I have tried if Len(Forms!frmMain!eacNo)=0...

Hi, I have a table with 5 Memo fields. I fill each Memo field from a form and then use each field in a report. The problem I have is that for some Memo fields, the report showes only a part of it , first 3 lines. I changed the Can Grow, Can Shrink properties into Yes, of the report's field but...

I need to find the maximum value of field IDPost (integer) and then icrease this value by 1, using code. I then declare this value as maxIDPost1 and use it on a form. qryFindMaxIDPost is the query that gives all the numbers from where I will select the one that has the maximum value. This is...