|
Double Click to add
I have a combo box on my order details form. If the information is not
listed in the combo box, I would like to be able to double click, have the
products form open and allow entry of new product without having to leave
the order details form.
I have this working on another field that is a drop down list and it works.
Will this not work with a combo box?
Thanks
...
|
4 |
17.09.2006 18:38:36 |
|
|
How do you add automatic numbering to standard invoices to print
trying to pirnt blank invoices with company name and logo but would like to
have them numbered in triplicate, Does anyone know how to do this with MS
Office programs?
...
|
4 |
17.09.2006 18:29:01 |
|
|
PLS help i need to Add new record to an existing records
I have two forms (linked)
The main form contains employee details(1)in a listbox.
The user clicks on an employee in the list box, then selects the toggle
button to the linked form...a booking form(2)where the employee primary key
is present. I want to keep the primary key but i want the rest of the booking
form fields to be blank and a button that adds the new booking booking record
to/for...
|
1 |
17.09.2006 18:25:22 |
|
|
Get values in real time
Hi:
I try to get the value in a real time. There are two subforms inside a
mainform. First user enters value into mainform. Than comes to
subform1. And after that on the basis of a choice in subform1, the 2nd
subform is open. In 2nd subform i create a listbox with that query.
SELECT [tbl_Events].[PPVVOD_Outlet] FROM tbl_Events WHERE
[tbl_Events].[ticketnum]=[Forms]![tbl_PPVResearch]![ticke...
|
2 |
17.09.2006 17:37:07 |
|
|
In Access, some form fields have black background. Why?
...
|
2 |
17.09.2006 16:59:22 |
|
|
dlookup problem
Hi!
i have problem inreport when i use dlookup
As Example:
Table1
Id TranDate FieldA
FieldB
(AutoNumber) Date/Time Currancy Currancy
Now I Create Query as Below
Id TranDate FieldA FieldB Balance
1 9/1/06 100.00 100.00 200...
|
6 |
17.09.2006 16:47:51 |
|
|
Insert Info from 1 form to another form automatically??
I have a Customer form and an Issuing Office form. The issuing office form
is filtered by the Customer Form (Customer ID = 1, for instance). Many
times the issuing office name and address are identical to the customer name
and address.
I would like to be able to have the issuing office form pull the name and
address from the customer form, but allow editing also.
For example -- add...
|
1 |
17.09.2006 13:41:17 |
|
|
Record - User, time login - time log-out
I maintain a database used by a lot of people.
I want to be able to record who's signing in and what time they log off.
I have set up a table to record this info....but I can not make it work.
Any reference regarding the issue.
ALSO: Sometimes users sign on, but they don't exit the database, thus taking
up resources. Is there a way to kick them out after a certain time?
Thanks in ad...
|
4 |
17.09.2006 13:15:17 |
|
|
Change data before save
Hi: Can any one please tell me how do i convert data from (1,2) to
("1","2","3") before i save it into table. I mean when user enters
value in a textbox like 1,2 i want to change it into above format
before i save it.
Thanks.
...
|
4 |
17.09.2006 12:07:15 |
|
|
Verifying that printing is done
After entering a batch of transactions our AA prints a paper copy of
the transactions, then merges them with the year-to-date transactions.
The database is desined to present the report in review mode. Once the
AA has verified totals and other data in the preview, she prints the
report by clicking the 'print' icon in the menu bar. After the report
prints she clicks a command button to merge t...
|
1 |
17.09.2006 11:45:07 |
|
|
Best way to cancel out of a data entry form?
I want to put a 'cancel' button in a data entry form so that if a user
enters some data and then cancels it discards the data entered, if I do
a delete record:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
It seems to work but prompts the user 'do you want to delete 1 record'
which scares them a little. Is there ...
|
3 |
17.09.2006 10:45:00 |
|
|
Toolbar disabled
Hello.
I have a form with the property popup defined as 'yes'.
However, after I did that, my toolbar attached to the form (where I have the
navigation buttons), appears disabled.
Can anyone tell me if it's possible to enable the toolbar keeping the form
in popup mode?
Thank you.
Acores...
|
5 |
17.09.2006 09:39:01 |
|
|
Blank field force entry
I have three forms:
frmCustomers; frmOrders; sfrmOrder Details
frmCustomers is opened and it has several tabs one of which is for orders
where I have the frmOrders with the subform sfrmOrder Details. On the
frmOrders I have a field labeled ShipDate, and on the subform I have a field
labeled Item. The ship date must be entered before the item so on the Got
Focus event of txtItem I put...
|
5 |
17.09.2006 04:50:50 |
|
|
why won't switch function won't work
I have the following in the criteria field in a query of mine to filter
records from a table:
Switch([Forms]![frmMapEx]![Combo11]=">=",>10000,[Forms]![frmMapEx]![Combo11]="<=",>100000,True,>0).
Why doesn't it work?
Thanks!
...
|
6 |
17.09.2006 04:06:03 |
|
|
ComboBox tool unavailable on toolbox in design mode
I am working on a Access application to track nurse educational
requirements. I am using a number of combo boxes in the app. All of a
sudden when I open my form in design mode, the combo box and navigation
buttons tools are greyed out.
All my apps on this machine behave this way.
I have tried the suggestions from similar posts on this site( uninstall,
Install full, and running th...
|
4 |
17.09.2006 00:19:21 |
|
|
Combo Box does not display data from table until it gets focus
I have a combo box in a subform. When the user selects and account and then
goes to enter the contract for the account, they need to select the
associated contact. When they select the contact, the name appears just fine
and the information is stored in the underlying table, but the next time they
open the database and scroll through the account records, the selected
contacts do not sh...
|
1 |
16.09.2006 22:14:01 |
|
|
Join two tables
Hi:
Can any one please help me how to i join both tables so that i get
value from FieldC. Table A of val(left(FieldA,5))=Table B
of FieldA
Table A
FieldA, FieldB
02212-324354-02, 123
03243-657483-98, 324
05463-928764-07, 443
Table B
FieldA, FieldB, FieldC
2212,123,ABCDEF
3243,324,GHIJLK
5463,443,LMNOPO
Thanks.
...
|
3 |
16.09.2006 19:46:16 |
|
|
Hide everything else when using a data entry form?
We have a service request database that we want to use a single form to
enter new requests. We have it set to close out of the database when
the close / submit the request, but I'd LOVE to have it open with JUST
the form and not the remainder of the database windows. Is there any
easy way to pull that off? Thanks!
Mick
...
|
3 |
16.09.2006 17:20:21 |
|
|
Scroll of Mouse
Hi,
How do to block my scroll of mouse not to alter the record current of
form?
Thanks,
Michel Ank
...
|
4 |
16.09.2006 16:14:07 |
|
|
Match problem
My criteria in query is:
where outlet in [tbl_events].[PPV_Outlet]
Outlet type is text and [tbl_events].[PPV_Outlet] type is number is
there any way by which i can match the values.
Thanks.
...
|
8 |
16.09.2006 12:49:38 |
|
|
Find a value in a listbox, then show it?
I need to update a display in a listbox because of other user activity in
form.
How do I look through a controls list to find the proper row to display?
My textbox control that I want to base off of as this is correct, is called
Name.
Rowsource for Combobox27 =
SELECT Company.CmpID, Company.Name FROM Company ORDER BY 2;
How do I compare the value in textbox Name and find it and SHOW...
|
4 |
16.09.2006 02:59:01 |
|
|
can i use a webcam on may computer
i wan use may web cam but can't i don't knw way ...
|
2 |
16.09.2006 01:51:29 |
|
|
Show a single record
I have two forms. The first form is frmCustomer_Lookup and the other is
frm_Customers. In frmCustomer_Lookup I have a combo box where the user
selects a customer and then clicks a command button that takes them to that
customer in frmCustomer where they can see all the data. How do I make it so
they will only be able to see that customer and not scroll through the
others. I'ce taken off ...
|
2 |
15.09.2006 23:27:01 |
|
|
1 Form, 1 query, different criteria on diferent tabs
I have designed a form which allows me to edit records in my database.
The data is a list of issues and each record has a status ID (1=Review,
2=In Progress, 3=Completed, etc.). The form contains several tabs (one
for each Status) and ideally I would like to use the same form in each
tab but each form should use the same query except the criteria on the
status should change to filter record ...
|
2 |
15.09.2006 23:26:01 |
|
|
How do you eliminate duplicates in a bound combo box?
I have a form with a bound combo box that has duplicate numbers in it. I
need the duplicates removed. How do I eliminate the duplicates from the drop
down?...
|
2 |
15.09.2006 21:29:26 |