Search results

If you set AllowZeroLength to Yes, then if you are assigning a value to the text field then you can use: yourtxtfield = "" If you set AllowZeroLength to No, Then you can't do the above. You would have to make the text field Null.

Try: DoCmd.OpenForm "frmEditContact", acNormal, , "[ContactID] = " & Me.lboRecent.Column(0)

And after you change allowedits to False on the subform: When you click the edit button on the main form you can use, Me.subfrmName.Form.Allowedits = True

Just my 2 cents worth: All knowledge is worth something somwhere down the line. I started learning about computers and programming more than 30 years ago (because I was genuinely curious). But I started out my career as a sheetmetal worker. Little did I know that later on in my career that...

The are probably just hidden. Under Tools - Options - Show Hidden Files

Try this for your filter. Report_report1.Filter = "[docstatus] = 'approved'" If wild card is needed, Report_report1.Filter = "[docstatus] Like '*approved*'" Hope this helps?

You should consider splitting the DB into Front-End (forms, queries, reports, modules, etc.) and Back-End (data tables), then any changes you make to the front end would not affect their back end data. Hope this helps?

Check to make sure that there is a default printer installed. Hope this helps?

Instead of DLookup, use a filter instead. Hope this helps?

Try this under your edit button. Private Sub Edit_Click() On Error GoTo Err_Edit_Click Dim stDocName As String Dim stLinkCriteria, stFilter As String stDocName = "EDIT Enquiry" stLinkCriteria = "[CustomerID]=" & Me![CustomerID] stFilter = "[Address] = " & "'" &...

CustomerID is a unique field so you don't need to include the Address to identify it. stLinkCriteria = "[CustomerID]=" & Me![CustomerID] Should work. Hope this Helps?

I picked this method up from some other site. Do not preview but open print dialog ! Open your report in design view, add the following to the Report's On Activate event: Private Sub Report_Activate() On Error Resume Next DoCmd.RunCommand acCmdPrint DoCmd.Close acReport, Reports!rptName End...

I'm not sure but on a previous line try: strWhere = strWhere & "(DenumireDosar) Like *'" & Me.txtDenumire & "*'"

You will probably need to save the record first, if it has been changed, for any updates to be shown on the report.

The filter for the form does not automatically transfer to a report. You will neet to use the same filter for your report (example) Open your report Set your filter Turn filter on Or Pass the filter on when opening the report.

Are your linked tables pointing to a drive letter "D:\..., E:\..., etc." If so you might try using the UNC path "\\Servername\..." to link to your tables. Mapped drives don't always follow to well from computer to computer. Hope this helps?

A single database will work for your needs with the appropriate tables for each set of informaton.

If using the same form to continue a new record add (The next line after the save) DoCmd.GoToRecord , , acNewRec

See if this helps. (Part way down the page) An Access 2000 add-in that applies the Leszynski Naming Convention to database objects http://www.helenfeddema.com/CodeSamples.htm

In the form properties make sure you delete the Picture property. Hope this helps?