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 ...
|
Runtime error 3008
Wed, 17 Dec 2008 03:37:00 -0800
Runtime error 3008
The table tblBaskets is already opened exclusively by another user, or it is
already open through the user interface and cannot be manipulated
programmatically.
Ive for form_load event on a form (bounded to tblBasketContent) and when it
loads i run Sql to insert a record in tblBaskets, ...
|
How to find the text contol
Wed, 17 Dec 2008 03:16:10 -0800
Hello:
It could be when I redo the textlabel or the other text control, I changed
the name. Can anyone tell me how can we find where is the "text139". I know
how to find it in the VBA and the form, but I do not know where is the
control, I went a round the form one by one but I still can not find it. Is
...
|
