Search results for query: *

Roy-Vidar, addy, PHV I have finally spotted in one of the tables "msgbox" as a field name. I deleted this field and compacted the database. Everything works fine and msgbox is written as MsgBox. Thank you all for your valuable help

When I right-click in msgbox and choose definition there is a Visual Basic Message saying "Cannot jump to 'msgbox' because it is in the library 'C:\Documents ......... ' which is not currently referenced.

VBA.msgbox "You have permission to view only" has worked. But I find out that, in all cases that msgbox is used, this is written in low case letters instead of MsgBox. Now I remember that a few months ago, I used: Dim msgbox as string but searching through the code now, I cannot find this. I am...

No, I have checked this. I forgot to mention that the problem occurs only in the fresh database where I imported all objects. The original program works without any problem. Rgds

Hi addy, Here is the code: Private Sub Form_Open(Cancel As Integer) If userLevel = "V1" Or userLevel = "T2" Or userLevel = "T3" _ Or userLevel = "T1" Or userLevel = "P1" Then msgbox "You have permission to view only" DoCmd.CancelEvent Exit Sub End If Call allowEditDeleteAdditionW(Me) End Sub...

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...

After many trials I solved this problem using: DoCmd.OpenReport stDocName, acPreview DoCmd.RunCommand acCmdZoom100 Thanks MP9

Thanks. There is an error message "The command or action Zoom100% isn't available now" . Any more clues please ?

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

Thank you both. 1. Lupins46 the field that links MainForm and subForm is OK. 2. TheAceMan1, you are absolutely right. Problem solved. Thank you. Best rgds

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 =...

Thank you both. The data in the Memo field is a text which never changes. It is part of a letter, let's say. May be the problem has to do with the properties of a Memo field used on a report. Maybe there is a maximum of characters it can show on the report, though it holds many more in the...

Thanks BSman. Solved the problem Rgds

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...