|
Use CurrentUser to look up ID
I know this should be easy enought but I can't seem to locate anything in the
discussion groups or make it work. I have a combo box that looks up "users"
from a table to be applied to a record. I would like to make the default
"user" populate the field based on their login via CurrentUser(). How do I
look up the ID in the associated table to populate the field and still allow
the comb...
|
9 |
19.09.2006 19:24:02 |
|
|
Match value with combo
Hi:
I try to match values with combo. Values are match but i dont know how
to set the combo with the match value. I ask the same question before
for ListBox and this method works with that. But when i try to use the
same with combo this wont allow me to set it according to the match
value.
Error:
Combo128.Selected(i) = True
-----------------------------------------------
Dim AccI...
|
3 |
19.09.2006 19:23:26 |
|
|
Problems Adding New Records
I am having a problem adding / editing a record in my forms / subforms for a
MS Access 2000 database. When you are adding or editing a record once you
are done you can not leave that record. It says "Calculating ...." in the
status bar. I cancel out of the form, get the message "Microsoft Access may
have encountered an error while trying to save a record." Followed by the
message "...
|
2 |
19.09.2006 19:23:11 |
|
|
Copy and create recordset
I have a SQLString that queries on three tables (form, subform, subform
of subform). I need to provide a button[Command51_Click()] that
essentially copies the current recordset into a new recordset. Any
suggestions???
CODE
Private Sub Command51_Click()
DoCmd.SetWarnings False
Dim SQLString As String
Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command
...
|
2 |
19.09.2006 19:22:35 |
|
|
Combo Box update (fmr)
I think I've seen this done before but I do not have access to my hand books.
I want a combo box to pull the entries currently in the table, the names
appearing only once, so that if the new entry is a repeat you can just select
the name associated with it.
What I am doing is tracking contacts from our offices to the support staff.
I have a date field, a, who handled the contact field...
|
3 |
19.09.2006 19:22:24 |
|
|
Form Floating Total ??? HELP HELP HELP
I have a form with 6 lines of information on it.
I have a field named: AdjTotal
I want to display this field over the top of another field at 1.5 inches
down the forms detail section and 3.9 inches from the Left side of the form.
I have tried the following:
AdjTotal.Top = 1.5
this moves the field up a few lines consistently however not to the right
place.
AdjTotal.Left and Adj...
|
3 |
19.09.2006 19:21: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 |
|
|
Text Box/Table Help
I have a text box that is bound to a field in a table. The user enters
a number in the form with the text box. I want to ensure the number
entered does not already exist and, if it does, have a dialog box pop
up telling the user. This is a unique number, I use it for the primary
key of the table. There is an error message that appears now if you
try to add a duplicate because it is the pr...
|
2 |
19.09.2006 18:54:40 |
|
|
Conditional Summing
I have a form that I use in Datasheet view as a subform. The form has
several calculated fields in it's footer using the sum command.
This works fine, but what I need to do is only sum the records where a
certain field is set to true.
How can I do this?...
|
4 |
19.09.2006 17:45:11 |
|
|
Sub-report on a Form
Is there a way to have an Access report be displayed on a form? I have a
master form with a subform that changes when the user makes various
selections. As it is now, when the user opens a report, the report opens as
a separate object on top of the form. Is there any way to display the report
as a control on a form, so that the user never leaves the main form window?
...
|
2 |
19.09.2006 17:19:02 |
|
|
Click on a field in Form A to bring up record in Form B
I have a form, and I would like to be able to double click on a field within
that form and open a single record corresponding to the entry in that field.
example: computer form with relevant information including an employee
number field. Double click on employee number and that employee's record
comes up from another form (Employee).
Computer Information form
Employee form
tha...
|
4 |
19.09.2006 17:09:02 |
|
|
Access2003, combo box will not save selected value
I had no trouble using Access 2000 pro, now in Access 2003 this does not work...
|
2 |
19.09.2006 17:00:01 |
|
|
Access 97 Run-time fails to print label report
I have created an Access 97 application and packaged and distributed using
Access 97 developer edition tools. I developed the application on mc which is
running Windows XP professional. When I installed the application on a pc
with Windows XP home, I get error in printing a label report. The label
report has used strconv(......,3) function in it. Other reports are fine ,
The application i...
|
2 |
19.09.2006 16:42:45 |
|
|
Combo Requery Question
Hi Guys,
I have an invoice form [frmInvoice] with a button to open the main products
form [frmProducts] if the product is not in the combo list. I want the combo
box on frmInvoice to requery and update to include any new products added to
frmProducts.
On the close button for frmProducts I have added the following code to
requery the combo list on the frmInvoice, but it's not working!...
|
6 |
19.09.2006 16:14:53 |
|
|
INSERT INTO from Sub2 Form
I'm trying to copy a value from a control to a table using INSERT INTO. The
problem I'm having is referencing the control properly.
I'm running this in the Before Update of a control on a subform of a subform
of the mainform:
DoCmd.RunSQL "INSERT INTO Table (Field) VALUES
(Me.Subform1.Form.Subform2.Form.ControlName)"
What am I doing wrong?
...
|
2 |
19.09.2006 16:09:46 |
|
|
Form opening to wrong record
I have a form which is based on a query. The query sorts the records on
ID number. The form opens to someone's record who should not be first.
It's the same person every time, and the records from 2 up look to be
sorted correctly, but I do not know why it is coming up with the wrong
initial person each time. The query is fine, it sorts them perfectly.
Any ideas?
...
|
4 |
19.09.2006 14:15:13 |
|
|
Cannot add new menu to the shortcut menu bar
Access 2003:
Ultimately, a new or customized Context menu that appears when the user
right clicks in a form is required.
I have not done this for a while but as I recall the standard technique
is to display the ShortCut Menu Bar from the tool bar customization
window and drag a new menu from the Command list to the 'Custom' button
listing at the right end.
In this case, it does...
|
3 |
19.09.2006 13:43:02 |
|
|
ControlTip Text does not work
Access 2003:
Mouse hover over control will not pop up the standard yellow window
with tips entered in the control's ControTip text property.
I tried to bring the control to the front but that doesn't work either.
At one time I disabled all bars and menus to have control over which
ones appear for this application. However, I removed the registry
entries for all preferences for th...
|
1 |
19.09.2006 13:06:02 |
|
|
Customised combo box, how to lookup field selections
In my customer details section of my database (form) l have ten rows for
customer specific products, the product type field is linked to a table
displaying all products available, once l have selected ten product types l
would like to have a drop down menu in my sales order form that lists only
the ten product types selected and displays the priceing information in a
field once a product...
|
1 |
19.09.2006 12:48:02 |
|
|
scroll wheel help
I removed the record navagation buttons and text boxes. instead i have a
combo box with the primary key for each record. i then use the code
Me.RecordsetClone.FindFirst "[CoilID] = '" & Me![CoilIDCombo] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
to change the recordset when the combo box value changes. i.e. update the
fields with the record associated with the combo box value.
...
|
6 |
19.09.2006 12:00:01 |
|
|
Field from main page to appear on tabbed pages
I have a "main" page for each of my records plus several tabbed pages holding
further details.
I would like the "Ref" which is held on the main page to be repeated on the
other pages so that the user will always know which record he/she is in.
Advice, please?
Thanks
CW
...
|
2 |
19.09.2006 09:59:02 |
|
|
Create an email group and send report(s)
Hello everyone,
I am using Access 2002 and would like to create a form that will allow users
to setup groups of emails, then have the option of sending a report(s) to the
group.
Any help appreciated,
Connie
PS: I apologize if this posts twice. Waited for about 20 minutes and still
didn't see my original post, so here it is again....
|
5 |
19.09.2006 09:55:02 |
|
|
Why my recordset is not working?
hi.
Very simple recorset but do not work.
It won't add anything to database!! Database have only one field called
city.
Code is:
Private Sub button_Click()
Dim vtputki As New ADODB.Connection
Dim vtht As New ADODB.Recordset
Set vtputki = CurrentProject.Connection
vtht.Open "select * from dbo_cities", vtputki, adOpenDynamic,
adLockBatchOptimistic
vtht.AddNew
vtht!city = ...
|
3 |
19.09.2006 09:13:28 |
|
|
dsum in report
dsum in report...
|
2 |
19.09.2006 08:15:10 |
|
|
import/export specification
How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
...
|
6 |
19.09.2006 06:53:28 |