|
Filter By Form via Code
I have a form that has a tab control and therefore several text boxes, combo
boxes, etc. I want the user to be able to search or filter by anything on
the form. I have a search button that evokes the DoCmd.RunCommand
acCmdFilterByForm, but once they enter in their criteria on the form they are
having to go to the toolbar to actually apply it because I am not quite sure
how to write it ...
|
1 |
19.09.2006 13:37:01 |
|
|
2 small problems
Problem 1
When i enter my cbobox, I would like it to drop open, but I don't see
anything in the list of properties that will allow me to do this.
AutoExpand is already set to yes, and Locked is set to no. Can this be
done?
Problem 2
When I look at print preview, it shows only the top half of my form -
and sure enough, when I send it to the printer it prints only the top
half of my form....
|
17 |
19.09.2006 11:40:49 |
|
|
Runtime error 2501
Hi
I'm getting a runtime error when I click no when access asks me if I
want to update the records when clicking a button. The button is used
to set all the entries in a field to Null.
Can anyone help me?
Private Sub Command24_Click()
DoCmd.RunSQL "Update [Newsletter Database] Set Requirement = Null;"
End Sub
...
|
3 |
19.09.2006 08:19:02 |
|
|
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 |
|
|
import/export specification
How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
...
|
1 |
19.09.2006 03:22:28 |
|
|
ATTENTION EVERYONE!
I FARTED
...
|
1 |
19.09.2006 00:38:13 |
|
|
Function Key - F1 F2 etc
Does anyone know if it is possible to use a function key to open a form in
access?
Thanks in advance!
...
|
3 |
18.09.2006 22:18:09 |
|
|
I must be really bad at asking questions, none of them get answers
Hopefully I can ask this question so that someone understands my problem and
is properly motivated to help me.
I have a form that will include up to twelve records.
I am wanting to create buttons at the bottom of the form that only show up
when a new record is created.
When this button is clicked, it should go its corresponding record.
I also want the name of the button to reflect th...
|
11 |
18.09.2006 22:13:04 |
|
|
How to Delete a Found Record in a Form
Hi all,
I wanted to delete a record using the following:
Me.FieldToSearch.SetFocus
DoCmd.FindRecord Me.ThingToDelete
DoCmd.RunCommand acCmdDeleteRecord
But, while the "FindRecord" command does find the record, the next line
does not operate on the record that was found... It will either do
nothing, or it will delete whatever record happened to be selected
before the FindRecord...
|
2 |
18.09.2006 21:47:35 |
|
|
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...
|
1 |
18.09.2006 18:35:57 |
|
|
print from form
Is there a code to print from forms? I understand that forms are typically
used for data entry and reports are for printing. But I would like to know
if there is actually a code to be able to print from forms? Thanks....
|
2 |
18.09.2006 17:44:02 |
|
|
Bizarre error involving date function
Hello! I need help!
I have written an extensive db and a popup form involves the date function. I
wrote a VB routine that automatically puts the 1st of the present month into one
text box and the last day of the present month in a second. Here is the key
line:
MonthEnd = DatePart("m", BeginningDate) & "/" & LastDay & "/" & DatePart("yyyy",
Date)
(LastDay is derived from an algorithm wh...
|
48 |
18.09.2006 17:30:08 |
|
|
Man to Many Relationship
I have 3 tables
1. JobName
2. CabinetType
3. CabinetTypeInfo
I need to set up a form that would select the Job Name first, then the
Cabinet Type.
the CabinetTypeInfo table need to relate to the CabinetType table and also
to the JobnName table
The primary keys are
1 fkJobName
2.fkCabinetType
3.fkcabinetTypeInfo
The CabinetType table has a forgein ...
|
2 |
18.09.2006 17:25:26 |
|
|
Is there a way to do "save as" a new record in a form?
Other people may already have asked similar questions, but I found it's
painful to comb through other people's questions and answers. Plus when I did
the search, it came back with a list of results relate to my question, but
when I click on it, it doesn't give me the detail of the posted question and
answer. Instead, it went back to the "search" page.
Anyway, here is my question, is ther...
|
7 |
18.09.2006 16:32:02 |
|
|
Form coding/process question
I have a form that has three radio buttons for Specialty:
1)Cardiology
2)Pediatrics
3)General Surgery
Based on the Specialty that is selected the user can then pick from
additional radio buttons for the reports they would like to view. How do I
tell my form to only show the report for the selected Specialty when
displaying up the reports.
I am currently writing this sql as an Even...
|
2 |
18.09.2006 16:19:55 |
|
|
File not found vba6.dll
My code has been working for several years now. All of a sudden, after
reinstalling Office 2003 on my computer (cause of a disk problem, had to
reinstall windows 2000 server sp4 and Office 2003) whenever my application
executes code for instance in snippet below. I get error message Can not
find vb6a.dll and the app goes into debug mode. How can I correct this
problem. This occurs whethe...
|
1 |
18.09.2006 15:58:03 |
|
|
Block Text without Line Continuation
Can someone help me with what is (hopefully) a simple question? I have
searched and seem to be missing the answer to this question.
I have a block of HTML that I need to store in my code, then output to
a file.
How can I enter the HTML as a solid block? I would rather not have to
handle them as individual lines with the "& _" at the end of every
line.
Thanks!
Bill
...
|
4 |
18.09.2006 15:14:19 |
|
|
data entry: preventing certain decimals
The database I am developing contains working hours and the hours are always
rounded up or down to the nearest quarter.
What I need is a message which alerts the user when they enter anything
other than X.25hrs, X.5hrs, X.75hrs or X.00hrs (where X is any other number).
Based on the knowledge I have I guess I would use the "after update" event.
thanks in advance....
|
3 |
18.09.2006 15:03:03 |
|
|
Adding Hyperlinks Programmatically
Hi All,
I'm looking for a way to add hyperlinks programmatically.
Ideally, it would work as follows, but any user-friendly alternatives
would be most welcome....
The user clicks on a button which opens a "Windows Explorer" type
window. The user then browses to the url, directory, or file they wish
to add, selects it, and a hyperlink to the item is added to the
current record.
A...
|
3 |
18.09.2006 14:42:59 |
|
|
Refreshing data without closing form
I have a form with 2 tab controls. On Tab 1 if you enter the first 3 letters
of the name and the dropdown doesn't happen, you know it's a new name. So you
click Tab 2 and enter the Name details. When you return to Tab 1, the name's
still not in the dropdown list. I put in a button with the following code,
which works, but how could I do it WITHOUT having to press the button?...
|
3 |
18.09.2006 14:16:02 |
|
|
Not Nothing - coding practise
I always shudder when I see:
IF Not blah Is Nothing Then
.....
I would write it thus:
If blah Is Nothing
Then ' no action
Else 'things are going to change
.......
Comments?
...
|
23 |
18.09.2006 13:52:44 |
|
|
Seperating numbers and characters
using vb in access 2003 i return a value which is made up of numbers and a
letter.
for example "305L"
i need to seperate the numbers and letter
i can use the right function to return the character from the right hand
side but how do i return just the numbers? The numbers can consist of 3 or 4
digits.
any help would be appreciated....
|
3 |
18.09.2006 13:51:02 |
|
|
Combo Boxes in Sync
My form has two combo boxes on a form that is writing to a table. The first
is for the user to select the Director. The second selects from the Managers
reporting to the Director (selected in the first combo box). The second
combo box is based on a query which has WHERE criteria pointing to the first
combo box. It also has a macro place 'On Enter' which is RunCommand.Refresh.
This l...
|
3 |
18.09.2006 13:05:02 |
|
|
Pivot table form: export to Excel - but ...
I am using a pivot table form in Access 2003 to get report data into the
layout required, but the Access pivot table doesn’t do everything I want e.g.
conditional formatting, merging blocks of identical data etc.
I can however manually copy the pivot table into Excel where VBA does all
the formatting required to present the report, however have met one big
problem in automating the pr...
|
1 |
18.09.2006 12:12:02 |
|
|
control tip text for combo box items
Hi all,
How do I change the control tip text property for items in a drop down list
each time I mouse over a different item? Basically, I want to let the users
know will happen if they choose an option before they choose it. The comments
I want to use are stored in the second column of the combo box's underlying
query. This column is hidden intentionally at run time. It seems as though
...
|
3 |
18.09.2006 11:51:49 |