error 2105
Wed, 17 Dec 2008 12:55:01 -0800
Hello,
This was working fine until today.
I have a form with a subform. When I enter in the information on the form, I
have an "Add" button that moves the information to the subform. Today when I
tried to use it, it is giving me a runtime error 2105 and highlights my docmd
line. Please help me figure out wha ...
|
VBA code broke in migration from 2003 to 2007
Wed, 17 Dec 2008 11:15:02 -0800
I have some very extensive VBA code using Access forms for the UI. While
migrating from Access 2003 to Access 2007 I have encountered a problem with
the "visibility" of subform controls and their properties in my VBA code.
One of two things happens when the problem occurs:
1. The code behaves as if I have p ...
|
Access 2002 MAR not opening in 2003
Wed, 17 Dec 2008 08:51:04 -0800
I have some reports that were created in Access 2002. We now have several
2003 users and they are complaining that they can't open these reports. An
error pops up that eventually seems to incriminate the code below as not
being valid in Access 2003. Just wondering if anybody might spot a problem
with this ...
|
MsgBox window when you receive a new record in an IM type of DB
Wed, 17 Dec 2008 08:07:10 -0800
Hello.
I have created an Access database that will be shared by a few people that
will work almost as an Instant Messanger. The querey on the "Main" form pulls
all records created by the person logged in to the computer (using a module
that pulls the LAN login ID) and any record assigned to the person logged ...
|
Inserting picture
Wed, 17 Dec 2008 07:32:06 -0800
I couldn't find another location to put this question out, so I apologize.
This is probably not what you think, I don't need to create an OLE Object or
anything. All I want to do is put my company's logo on an invoice / packing
slip which are both set up in reports. Everytime I have tried inserting,
copy ...
|
rs.FindFirst limits?
Wed, 17 Dec 2008 07:31:00 -0800
Hi, I've been using rs.FindFirst to search by two criteria using the
following code:
Private Sub FilterSamp_AfterUpdate()
On Error GoTo err_Handler
Dim rs As DAO.Recordset
If Not IsNull(Me.FilterSamp) Then
If Me.Dirty Then
Me.Dirty = False
End If
Set rs = Me.Reco ...
|
ListBox.Column(n)
Wed, 17 Dec 2008 07:25:55 -0800 (PST)
Hi,
Me.lstbxListBox.Column(6)
Is there a way to replace the column index by the column field name?
Thanks
H. Martins ...
|
|
|
Modification to current code
Wed, 17 Dec 2008 07:20:00 -0800
I have a database that automatically calculates an employeeâ??s service time in
each Job Classification that he/she works in. I have used the following
expression in the control source property of the form:
=DSum("[WeeksService]","Service Record Query","[EmployeeID] = " &
[EmployeeID] & " And [JobTitleNam ...
|
Problem with requerying a combo box
Wed, 17 Dec 2008 06:52:20 -0800
I have a form where I am using the double click event of a combo box to open
up another form so that I can add additional records for the combo box. On
the close event of this second form I have the following code:
If Forms!frmWorkOrder.IsLoaded = True Then
Forms!frmWorkOrder.cboAssignID.Requery
End ...
|
setfocus problem
Wed, 17 Dec 2008 12:32:54 GMT
I have a main form, frmMain with 2 subforms. By default, SubformSecond is
made invisible. SubformFirst is in datasheet view.
Before updating data in a textbox, txtPhyBal in subformFirst ,a message
popup form opens (fired by before update event of txtPhyBal).
On clicking an OK button on the message pop up for ...
|
