|
How to Test if a Record Exists
Hi all,
For the recordset associated with a form, how can I tell if a record is
in the set... For example, if my primary key is pkID, how can I tell if
the form that the user is looking at has pkID 15 in it's dataset?
(Once again) I attempted to use for example:
Me.pkID.SetFocus
Me.FindRecord (15)
And this works just fine as far as the UI is concerned... It will jump
down and h...
|
3 |
19.09.2006 22:21:44 |
|
|
On hand quantity and location
I'm using Allen Browne "On hand quantity" and I works great.
The same item can be at 20 different locations.
When I do my invoices I want to select a location with available items using
a combo box.
I can show a "summary" of the locations and the quantity available at those
locations in a sub form linked by the "itemID".
My problem is that I need to "restrict" the 'location combo b...
|
4 |
19.09.2006 21:31:03 |
|
|
Pass 'Not In' data to query
I have a form for running queries that has a field called Exclude. Users need
to be able to type in numbers separated by commas that they do not want to be
included in the query results. In the query, I added the criteria Not In
(Forms!FormName!Exclude). However, the data from the Form appears to be sent
as a literal - not as multiple numbers. In other words, if they enter 250,251
then t...
|
5 |
19.09.2006 21:22:01 |
|
|
NO SPAM PLEASE - Stock Value Help
I have the following code which gives me my stock quantity ....
Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long
'Purpose: Return the quantity-on-hand for a product.
'Arguments: vProductID = the product to report on.
' vAsOfDate = the date at which quantity is to be calculated.
' If missing, all transactions...
|
2 |
19.09.2006 21:18:54 |
|
|
Stock Value Reposted NO SPAM REPLIES PLEASE!!
I have the following code which gives me my stock quantity ....
Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long
'Purpose: Return the quantity-on-hand for a product.
'Arguments: vProductID = the product to report on.
' vAsOfDate = the date at which quantity is to be calculated.
' If missing, all transactions a...
|
1 |
19.09.2006 20:56:36 |
|
|
Stock Value
This is a multi-part message in MIME format.
------=_NextPart_000_00DD_01C6DC35.22FE0CD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have the following code which gives me my stock quantity ....
Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As =
Long
'Purpose: Return the quantity-on-hand for a product.
...
|
1 |
19.09.2006 20:47:00 |
|
|
Do.Cmd Printout Help Needed.
I have a report that I need multiple copies of printed. The report is based
on a query and opens up in print preview mode. I can then enter the number
of copies I need. I need to be able to use the do.cmd printout method, but
I need a way to change the quantity to print, instead of hard-coding the
number in the do.cmd printout statement. Is there a way to do this?
Thanks,
Terry
...
|
1 |
19.09.2006 20:36:06 |
|
|
DATABASE / DYNAMIC REPORTING DESIGN
I am New to Access, not new to VBA in Excel or Visual Basic 6.0
I am working on a database in Access 2003 that is to do the following:
Take test results from measurements done on certain units (gathered via
a visual basic program I made earlier), store them in an Access
database. The end-users will then have to be able to query the database
by selecting maybe 3 parameters, and then a repo...
|
3 |
19.09.2006 20:24:07 |
|
|
Coding a sum in vba subform
I have a form "POReciept" where I am trying to receive line items against a PO.
There are 3 tables, PO, POItems, POReciepts
There are 2 subforms, 1 showing the line items and the other showing dates
received.
Users open the form where it asks for PO#, opens fine, subforms have all
correct data...
when the user highlights the line item in subform1, he can then enter the
quantity received ...
|
5 |
19.09.2006 20:04:03 |
|
|
advice for tabs & 1-many tables
Hi,
Just need a bit of advice as to which way is the best to go.
I've got a form that has tabs on it, when I flick to a tab I want to
display/edit/delete a subset of records from another table. The table
for the form has a 1-many relationship with the records I'll be
displaying in the tab control
Now, what is the easiest way to go? I don't know about subforms, they
seem weak, display...
|
3 |
19.09.2006 19:40:09 |
|
|
#error
Someone has told me this before but I cant remember for the life of me how
to resolve it... How do I stop the #error messages?
Thanks in advance
s
...
|
6 |
19.09.2006 19:39:02 |
|
|
Getting a 'score' for a question
I thought I had this working, and now it's not - so some help would be
appreciated.
I have a series of questions, sort of like one of those Cosmo quizzes where
each answer has a different point value. I have the questions and answers in
a three column table (Question_type Question_Response and Question_Value). I
have a series of combo boxes where the responses for each question are
c...
|
8 |
19.09.2006 19:17:02 |
|
|
Modify Existing Data in Reference Table
I have a reference table of material prices that I use to fill in a
Purchase Order in MS Access 2003 front-end linked to MS SQL Server
back-end. The purchase order uses the reference table to fill in item
name, descriptions, and unit prices for material, I want to be able to
update the reference table field "unitPrice" from the "Unit Price" text
box afterupdate event on the Purchase Order fo...
|
6 |
19.09.2006 19:08:02 |
|
|
Do Until... Help Please!
Hey Guys (and Gals),
Having fun with Do Until statements, can't get this one to work...
What I want is if you double-click on one field then clear the contents.
What it's doing is asking you the question 9 times instead of just the one
you double click on. Hope that makes sense. Can someone help me?
Thanks in advance,
Gina Whipp
Public Function ClearViolation()
Dim LabelNum...
|
12 |
19.09.2006 18:55:31 |
|
|
form to subform filter
Hi there
im alittle stuck on filters and was hoping someone can help me out...i have a
form and a subform (continous). the parent form has command buttons whereby
they filter the subform which work great (their basic ones such as filter by
form/filter by selection) what im having a HUGE amount of trouble with is
trying to make specific filters...for instance:
the subform has a txtDate. s...
|
5 |
19.09.2006 18:46:29 |
|
|
I am trying to build a database to print off address labels
I am a home typist. I have a list of names and addresses to print Avery
Labels 3 accross and 10 down. I can use Avery 5160 Labels for Desk Jet
Printer.
I need something I can load all of the data and notjust one at a time.
Jane W.
typeladynow@hotmail.com ...
|
2 |
19.09.2006 18:33:21 |
|
|
combo box for filter
I have form with 2 combo boxes for filter and search button to do the search.
what i want is remove search button just only combo box when they click or
select cboFirmName and cboCountry it will auto Update the
txtCity,txtstreet,txtphone can anyone help i'm just new in access i'm just
studying by myself
cboFirmName:
cboCountry:
txtCity:
txtstreet:
txtPhone:
thanks,
apprecia...
|
2 |
19.09.2006 18:03:12 |
|
|
MouseMove event
Hi,
I have a custom menu form that I have labels as choices for uses. I have
created a public routine that changes the color of the text to yellow when
the user moves the mouse over a particular label.
In order to put the label back to white font color I put a for each
statement in the Detail section MouseMove event. I'm concerned that this
fires multiple times has the user moves th...
|
5 |
19.09.2006 17:27:57 |
|
|
Work order forms
Hi all, I have a question that's been bugging me for some time now.
Basically I have a form for work orders. I have to be able to create new
orders and have some drop down lists that the user can use to choose the
information to be used for the new work order. This info is pulled from some
tables I have already storing a basic "inventory" in which the fields data
may change.
Th...
|
10 |
19.09.2006 16:26:02 |
|
|
Compile Error and Syntax Error on Form
I'm trying to open a form based on informaiton from another form. I have the
following code but I keep getting a Compile error. When I take out one of
the parameters it works fine but obviously does not give me the right record.
I want to find a ProjecNumber and a WorkOrderNumber (that is my primary key
combination).
My code is:
Private Sub Open_Invoice_Click()
On Error GoTo Err_Open...
|
4 |
19.09.2006 15:16:36 |
|
|
Updating a field when another is populated.
Hi,
I have a Form that is used to update customer information and I currently
have a button that runs an update query, that looks up the account number and
update the form but it updates all the records in the table. What I would
like to do is add a after update function on the [Customer Acct:] field that
will populate the Customer Name on the form and update the Table. The
informatio...
|
4 |
19.09.2006 14:43:02 |
|
|
Hyperlink to another form in your DB?
Has anyone used hyperlinks to open forms in Access?
I need to write a report (displayed as a form) that will allow users to
click on an item number to drill down further into the underlying data.
I'll need to have the hyperlinks create themselves dynamically in order
to do this. The resulting form will need to send the value of the
hyperlink to a query in order to filter the data furth...
|
2 |
19.09.2006 14:22:35 |
|
|
Continous Form(s) Issue
I have the following code that resides within a Sub Form which is Continous:
Private Sub Action_Taken_Click()
If Me.Action_Taken.Value = True Then
Me.cboAction.Visible = True
MsgBox "Select an Action", vbInformation, "Action Required"
Me.cboAction.SetFocus
Else
Me.cboAction.Visible = False
End If
End Sub
The code runs fine; except for that when the Action_Taken is eithe...
|
2 |
19.09.2006 14:15:10 |
|
|
Can't open .mdb file from network using Access 2000 on WinXP
Hi all,
Please help me if you can.
We have app that works fine from the network drive using Access 2000 on
Windows 2000 PC. However, when we open it by clicking on the file or
shortcut from Win XP machine that has Office 2K installed, nothing
happens.
...
|
3 |
19.09.2006 14:05:27 |
|
|
Ignore posts - You cant do this in Access 2003
...
|
1 |
19.09.2006 14:01:07 |