|
Default value on a drop down menu
I have a form that I use to track purchases made through our company. I have
a field named account codes that is a drop down box that displays all of the
account codes available. 99% of the time, we use the same account code so I
would like this to be the default value in the menu. When I tried to use the
default value property in the properties, it didn't do anything. Any
suggestions?...
|
2 |
13.09.2006 21:14:56 |
|
|
Help getting a hyperlink name into a new text box as text.
Hi all,
I have a form with a text box called [TTS] and it holds hyperlinks. I would
like to create another unbound text box that equals the contents of the [TTS]
box. However, everything that I have tried has just returned the file path
that is connected to the hyperlink not the hyperlink name.
I am sure that this is a very simple issue and I am probably missing
something very small bu...
|
1 |
13.09.2006 20:59:16 |
|
|
Formatting Dates for Display in Multiple Regions
I have a relatively large Access App with lots of forms displaying lots of
dates. Many of the dates contain both date and time elements. This
application is used globally, so the dates need to be able to display
according to the user's Regional Settings. Unless someone else has a better
alternative, the only way I know to accomplish this without have to write
code to change all date fo...
|
4 |
13.09.2006 20:32:49 |
|
|
I have a blank entry on a continuous form how do I remove it
I have a form that is set to continuous. On the form are a bunch of
questions under the last question there are some fields but I can't do data
entry with it, not that I want to, I just want to remove it (there are no
questions associated with it. If one of those fields have the focus and I
click to go to the next page I get en error message - syntax error (Missing
Operator) in query e...
|
1 |
13.09.2006 20:31:02 |
|
|
First record disappear when using scroll, continuous form
Hallo,
I have a continuous form in an Access 2000 (secured) .mdb on a network where
the user can select individual contacts via check boxes and then generate a
report via a command button on the same form.
The problem is when I use the mice scroll the first record disappears. I
have no idea how to solve this problem.
I read some posts about using a certain .dll to disable scroll. I...
|
2 |
13.09.2006 19:04:02 |
|
|
Choice in combo box determines other field
Still pretty new to Access, not sure what I'm doing wrong...
I'm working on a database to track quotes, and I'm having trouble with my
Add New Quote form, here's what I've got:
Tables
Parts - fields PartNumber and Description
Quotes - fields Vendor Name, Date, Price, Quantity
My PartNumber field is a combo box because on my Add New Quote form, I want
the user to be able to choose a ...
|
2 |
13.09.2006 18:59:13 |
|
|
Help with Edit and Add modes
I tried to explain this earlier when asking for help with switchboard.
I have a DB that I copied into an other folder yesterday. Originally Two
days ago, I was able to go to the switchboard click on a button and create a
new form in the add mode. I if went back to the switchboard and asked to add
to a form, I would click on this button and was able to edit the records. Now
on the one I...
|
1 |
13.09.2006 18:58:03 |
|
|
Filtering Form With Combo Boxes
I've been racking my brains on figuring this out, so now I'm asking the
experts...
I have a form that has, as a control source, a table - tblSales. As far as
the layout of the table, I have a field called StoreNumber, one called Year,
and then various fields after that. A StoreNumber can have multiple records
distinguished by Year.
On the form, I have a Combo Box for StoreNumber, w...
|
5 |
13.09.2006 18:50:48 |
|
|
Before update formula
I am trying to allow the user to make multiple entries on a form
(numerical) that must sum to zero. This is what I have VBA to validate
this before the button can be clicked
Private Sub Form_BeforeUpdate(Cancel As Integer)
'If SumOfTotalPrice must be =0:
If Me.sum <> 0 Then
MsgBox " Sum of Total Entries must be
equal to 0." & vbCrLf & "Pl...
|
13 |
13.09.2006 18:35:24 |
|
|
curious question about 'onfocus'
Is it possible to stop someone from creating a new record if the cursor is
put into a new record.
The reason I ask is that I have three buttons which replicates the previous
record (each button does something slightly different), but it also
calculates the new date. I don't want a person to try to create a new record
without pressing one of these buttons.
I hope that makes sense!
...
|
6 |
13.09.2006 18:14:06 |
|
|
Cool Form Question
Hello,
I am not sure if this is a crazy idea or if it can be done but... I need a
from that looks like a calendar. When you click on a date you can enter
information for a given employee. My view of this is that I select a
particular employee. A from with a calendar opend up. I click on a date,
enter information and close, similar to outlook.
Any ideas?
Joe C
Big Papi...
|
2 |
13.09.2006 17:36:42 |
|
|
Combo box not populating correctly
I have a form with a combo box using the SQL query below. For some reason,
the combo box is not showing a list of values for the correct model.
Regardless of the model, it shows the list for the model shown in the first
record. If I copy the SQL to a new query and run it, I type the desired
model when the parameter box pops up and it works fine. I'm using the same
tbl for my query th...
|
3 |
13.09.2006 17:09:01 |
|
|
Urgent Help Needed !!!
I have a report with group totals. In one field (groupPortfolioAmt) of the
group totals, if the value of another field (groupPortfolioNo) is greater
than zero, I want to sum groupPortfolioAmt. If not, I want to just print 0 in
groupPortfolioAmt. Why is the following code in the Control Source property
for groupPortfolioAmt not working?
=IIf([groupPortfolioNo]>0,(Sum(Abs([portfolioAmo...
|
2 |
13.09.2006 17:08:29 |
|
|
replicating a record: quick query.
Here is a code I have for replicating the last record. The button is
currently in the same subform in which I am entering records.
Private Sub TempSt_DblClick(Cancel As Integer)
With Me.RecordsetClone
.AddNew
!EmployeeID = Me.EmployeeID
!WeekID = DateAdd("d", 7, Me.WeekID)
!Dept = Me.Dept
!Subdept = Me.Subdept
!Costcentre = Me.Costcentre
!Rate = Me...
|
2 |
13.09.2006 16:28:00 |
|
|
Populating more than one field from a combo box
Combo boxes are new to me. I created a combo box using the Wizard from a
query that has 4 fields per row. One field in my form is being populated
from the row selected, which is correct. However, 2 other fields in the form
should be populated from the same row selection.
How do I specify which fields should be linked from my combo box into my form?
Please help!...
|
2 |
13.09.2006 15:42:14 |
|
|
BeforeUpdate event fired up unexpectedly when form opens
Hi,
I have a form with a subform. When a record is added, or even updated,
on the subform, I want to validate the contents of a couple of the
fields. I put validation logic in the subform's BeforeUpdate event. I
expected that this event would be triggered once the data is entered
and is about to be saved.
I was suprised to see the event getting triggered before the
form/subform has e...
|
1 |
13.09.2006 15:17:05 |
|
|
Can not edit data in form
Using 3 tables linked into query and form data record source is from the query.
Cursor will go into field on form but will not allow any changes of data...
|
5 |
13.09.2006 15:07:01 |
|
|
Help with switchboard
I have a button on my switchboard that will allow a user to edit an existing
form. After we send the form to an area, they will provide a PO number and we
need to go back into the form to input the PO and date. I set the button to
open the form in the edit mode. But now every time I go into it, it is in the
add mode and will not allow me to view previous forms. I have even taking out
thi...
|
1 |
13.09.2006 14:53:01 |
|
|
Not in list Problem
Here is the code I have for my not in list event:
It is giving me an error at the If IsNull(DLookup) line. My combo box
runs of a query that pulls the Violator's Last Name and First Name from
the Violator's table and displays them Violator's Last Name, Violator's
Last Name
with
Violator's Name: [Violator's Last Name] & ", " &
tbl_Violators![Violator's First Name]
Now I need this code to...
|
7 |
13.09.2006 14:49:05 |
|
|
changign control on fomr
-maybe this is the right section to post this msg-
Hello,
I have an unbound form and many textbox on it which I should like to change
into checkbox instead.
Since I'm talking of about 75 controls...I was figuring if there was a
shortcut to achieve my aim by code.
I wrote the code, and I'm pretty sure it works fine, but I constantly
receive the message 'This control can't be changed in ...
|
4 |
13.09.2006 13:21:05 |
|
|
pass mainform.field to subform.field
I have a main form and subform based on 2 tables
PatientInfo Table
PatientID (pk)
PatientRelation
PatientAddress1
PatientAddress2
etc
BillingInfo Table (linked thru PatientID)
BillingID (pk)
BillingAddress1
BillingAddress2
etc.
I want the mainform fields to populate the subform fields:
if the PatientInfo.PatientRelation = "self" i want
BillingInfo.Address1 = PatientInfo.Pati...
|
3 |
13.09.2006 13:00:02 |
|
|
WHERE Clause?
More as a wild hope than anything, I threw this WHERE clause into a Query:
WHERE ((Group.Company_ID)=Company.Company_ID);
Needless to say nothing happens when the Query runs.
Actually the query is the RowSource for a ListBox on a SubForm onthe same
Main Form. Company.Company_ID has been arrived at by moving the pointer in a
Listbox in another subform of the same Main Form.
What sho...
|
3 |
13.09.2006 12:11:02 |
|
|
Import into excell sheet
Hi: Can any one please help me how to i create a button in a report so
that if user want it can be export to excell too.
Thanks.
...
|
4 |
13.09.2006 12:05:47 |
|
|
Filtering Multiple Tabs
I have two tables, both have one similar field. I have created a form for
both, then created another form with tabs and inserted the two original forms
onto sub-forms (one on each page), so I can flip between the two forms. I
want to filter by form the field that is similar and it to bring up the
records in both tabs for that filter. Any ideas?...
|
4 |
13.09.2006 11:37:17 |
|
|
Custom forms
Hi all,
I have the following problem.... I have two tables
e.g.
Company
-------------
Cmp_id
CmpName
CmpAddress
and so on
and
People
------------
Ppl_id
PplName
PplLast
PplCmp_id*
and so on...
I want to create a form for entering people... In the form, the user would be
able to enter name, last name... There would be a combo box where the user
could choose the right compa...
|
4 |
13.09.2006 11:18:49 |