Recent content by bohemian9485

You need to set the inputmask property of the control to that of the field too

I think you need the Microsoft Access 11.0 (this is for Access 2K3) Object Library as well

Have you checked your references in VBE? Maybe there are some missing references that's why Access is acting this way...

Bob is right:D

You can use On Error Goto line in your startup form's Open event

It's quite there are actually two locations for managing ODBC connections on a 64-bit machine. I installed Access 2K3 on a machine running Windows Server 2008 Standard 64-bit. I also installed Visual Basic.Net 2005 Express on the same machine. When I tried to connect to an Access database using...

Re: keypress - "T" for 'today' in a date field and "N" for 'now' in time field After you have detect the key "t", you have to set the KeyCode to 0 so not to raise conflict with date data type.

You can design query in the report recordsource by clicking the ellipse button at the right side of the recordsource property. This will bring up the query design window. Then in the click event of the commandbutton that will show the report: Dim strDocName As String Dim strLinkCriteria As...

Check the underlying table in the form that you enter new customer info, maybe it still points to the old field name.

In form design view, put the name of the foreign key field name from the query of the subform in the link child field property and the name of the combobox in the link master field property under the data tab of the subform control's property window.

First you have to set the form's KeyPreview property to yes, so the keystrokes will be evaluated by the form, before being evaluated by the controls. This property can be founded under the event tab in the form's property window. From your description, I would suggest using a key combination...

Put Me!ComboBox.Requery before the End Sub to reflect the change you made in the rowsource of the control

You can move the visible field up to cover the blank left by the field that was made invisible by using visibleField.Top = invisibleField.Top in your code

Create a report with tblContacts as underlying record source, save this report. Then create another report, this time using tblActivities as the record source. Save this too (we are going to use these two reports as the sub-reports in the main report). Now, create the main report with...

S = S & " obj LIKE '*" & fldadrese. Text & "*'". You placed the wildcard outside the string expression