|
Help with displaying results in a form based on a Combo box select
I am trying to create a form in Access 2003 and am having issues. Here is
what I am trying to do. When I select a field in the Combo box I want the
results of a query to be displayed on the same form. (I am working on a state
license database)
In the form I have a Combo Box that has the name of each state (combo box's
row source type is Table/Query, row source States). I have built a qu...
|
1 |
12/1/2008 6:58:00 PM |
|
|
Find/replace in a Word document programmatically?
Hi everybody
I have an Access project with the following code in a form:
Public Sub saleAword()
Dim oWord As Object
Dim oWdoc As Object
On Error Resume Next
Set oWord = GetObject(, "Word.Application")
If Err.Number = 429 Then Set oWord = CreateObject("Word.Application")
On Error Goto 0
Set oWdoc = oWord.Documents.Add(CurrentProject.Path &
"\miDocWordOri...
|
1 |
12/1/2008 4:41:02 PM |
|
|
'Calculating' regularly....
Hi,
I've got the following code which I've cribbed together as a result of post
searching for similar problems/requirements etc..
However, I quite regularly get 'Calculating' problems when entering into a
record. Can anyone suggest any of the following (I've only included relevant
code) that could be causing this?
My thoughts are that it could be the reporting code on Form_Load (at th...
|
2 |
12/1/2008 3:36:06 PM |
|
|
Synchronize subform scrolling
I have a continuous subform that has many fields on it, so you have to scroll
horizontally to view all the data. I would like to "anchor" two key fields
(account numbers) on the left side, to produce an effect like "freeze panes"
in Excel (or like having a "form header" on the left side of the screen
instead of the top). My thought to solve this was to have two different
subforms based...
|
5 |
12/1/2008 3:07:02 PM |
|
|
Determining where keystroke input comes from
Hi,
Can anyone tell me if it is possible to determine which device is being used
when I have two input devices? I have an Access 2003 app being used on a
Windows XP pc with a magnetic key reader which sends a number of keystrokes
to the app when a key is tapped on it (the sort of thing barstaff use at the
till in pubs & clubs etc.)
Can anyone tell me if there is any way of differenti...
|
2 |
12/1/2008 2:02:04 PM |
|
|
How to avoid endless loop?
I am attempting to set focus to a field and then return focus back to the
field that initiated this process. My attempts have resulted in creating an
endless loop error. Any help is greatly appreciated.
Form design:
I have 4 fields in my main form.
Each field corresponds to a separate page in a tab control contained in a
subForm on the MainForm.
Each page of the tab control contains ...
|
3 |
12/1/2008 3:16:00 AM |
|
|
Access 2007 - Recordsource & Subform
Hi Everyone,
While converting our apps from Access 2003 to 2007, I've come across the
following issue. We've a main Form which contains a Subform. In Access
2007, when we update the main Form's recordsource value, the subform re-opens
(i.e. its on open event is executed) However, this doesn't happen in Access
2003. Does anyone has a workaround?
...
|
18 |
12/1/2008 1:04:56 AM |
|
|
How do I find certain record by specifying values in 3 fields?
...
|
2 |
12/1/2008 12:40:52 AM |
|
|
How To Create MenuCommand Bar by VBA
Hello
I m working in ACCESS 2000 ...i m trying for the first time creating
Commanbar Menu..
WHEN i'm executing tHE vba code below (from a Macro) :
Public Function CreerMenu()
'
======================================================================================
' Auteur : Starec - Philippe JOCHMANS -
http://starec.developpez.com
' Description : Création d'une b...
|
4 |
11/30/2008 7:21:13 PM |
|
|
Capturing User Initials
How do I capture the User Initials in Access 2000 and Access 2007?
...
|
2 |
11/30/2008 7:11:14 PM |
|
|
Access 2007 Pop up forms and the "sliver" effect
Okay, I've googled for this and only found one posting for this strange
behaviour in Access 2007 - and no solution.
I am running a 2003 db mode and when I occasionally make changes to various
forms -not even the popup forms!- and compile, make an mde, and re-open,
some of the popup forms open as a "sliver" about 1/4" by 1/2", and it is
really hard to even close them, let alone stretch th...
|
3 |
11/30/2008 5:42:00 PM |
|
|
how to make update to BE just one time via distributed FE
I have a database running in a BE/FE setup, ca. 30 users.
I'd like to run som action queries or SQL on the BE, but I don't have (easy)
access to the BE.
Thus I'd like to create functionality in the FE that will run the queries.
But the queries should only run one time and one time only.
How can I go about this? A table in the FE with the SQLs wont work as each
user has a FE and thus ever...
|
4 |
11/30/2008 8:40:07 AM |
|
|
Whats wrong with this code?
"Object Doesn't Support This Property Or Code"
I either need help fixing this code or if someone knows a more simple way to
create the same result it would be much appreciated.
What should happen is:
1. If Replist is null & Mgrlist is null then Questionbox = "Questions - All
Reps" and is the only txtbox visible.
2. If Replist is not null then Questionbox = "Questions - Per Rep".
Ques...
|
8 |
11/30/2008 6:35:31 AM |
|
|
Repost - Fill in value *Sandra Daigle List Box Edit
Hi Groupies
Sorry for the repost in less than 24 hours. I do realize that it is a
holiday
in the states and many MVP's are taking a very deserved rest.
I am way out of my element on this one and I can not progress any further
until it is solved.
Instead of items selected in the right list box being deleted when you
push the left facing arrow, I would like the underlying table to have
...
|
10 |
11/30/2008 1:02:51 AM |
|
|
Trying to call a procedure in a subform
I have been trying to figure out how to do this on my own but I am stumped.
When I use
DoCmd.RunCommand acCmdRecordsGoToNew
or
DoCmd.GoToRecord , , acNewRec
on the main form the subform does not seem to move to a new record. What is
the best way to do this? Thanks for the help!
...
|
3 |
11/29/2008 9:10:00 PM |
|
|
Form is not finding the data
I have a form that has a table as its source and is not filtered but shows
no data. I am able to put data into it, which is saved even thought Access
shows an error message that it is not saving the data.
I have tried deactiving all of the programming, which did not solve the
issue. I have turned allow filtering off. I have created copies of the
form and removed various controls; thi...
|
3 |
11/29/2008 7:45:48 PM |
|
|
Form Resize OnLoad
I have my frmMain form maximized on load. I need it to stay that way.
When I open any other forms, they all maximize too.
I added code like this to set the form's size but they all still load
maximized anyway.
InsideHeight = 7200 ' Five inches high
InsideWidth = 4320 ' Three inches wide
I tried to add DoCmd.Restore but this restores ALL my forms.
...
|
6 |
11/29/2008 5:54:49 PM |
|
|
sub or function not defined
What is wrong in the following code to give this error? The
"Exit_ValidateOdometer" line is highlighted blue.
Private Sub ValidateOdometer(Cancel As Integer)
On Error GoTo Err_ValidateOdometer
'verify that odometer entry is not less than last
Dim varPrevOdometer As Variant
Set varPrevOdometer = Me.Parent!PrevOdometer
If Me.Odometer < varPrevOdometer...
|
4 |
11/29/2008 3:38:01 PM |
|
|
How To Input Value into ActiveX Calender ?
Hi,
1. I am currently using Access 2000, developing Leave application.
2. What I tried to achieve is when user login to apply leave, they will see a
calender with names on dates that someone had taken leave (Group By
Department)
3. Is there anyway I can Achieve It ?
4. I am using ActiveX Calender Control 9.0 by the way.
5. In this way when anyone from the department log gin they a...
|
4 |
11/29/2008 3:28:21 AM |
|
|
Go to a Specific Form
I have created a table of records. When a record is clicked, I want the
specific form for that record to open. The command I have now, Open Form,
opens a new, blank form. Any thoughts on how to get the specific form to
open. This is driving me crazy!!!!
--
Debbie...
|
4 |
11/29/2008 12:46:00 AM |
|
|
Update field on main form when all fields on subform are complete
I have a "quote" form with a subform "product" which contains multiple
product line items. Each "product" quoted has a "completed date" field
because not all products are quoted at the same time. I want to update the
main form (quote) "quote date" field when all of the table (product)
"completed date"s have been entered. The "quote date" field must equal the
last "completed date" from...
|
3 |
11/29/2008 12:30:01 AM |
|
|
filtering a field defined as Yes/No
I have a field labeled FCSI_Closed that is defined as a Yes/No field that I
would like to filter on a continuous form based on an option group in the
header of the form. There will be multiple option groups to allow the user to
filter the form based on various criteria. I should be able to extrapolate
the remaining option groups based on the FCSI_Closed option group. The
following is the...
|
3 |
11/29/2008 12:20:50 AM |
|
|
DAO, Recordset, Edit, Updating, BeginTrans, CommitTrans, database
Hi All,
I Have the following code, basically the code is to set the ranking number
against a set of records in a table called 'tblRANK'. The table contains
around 50,000 records and the ranking is across each country, in that the
ranking starts agian at 1 each time there is a new country, the table is
already sort by COUNTRY Asc and AMOUNT dec so the table is in the corret
order and t...
|
4 |
11/28/2008 6:13:06 PM |
|
|
Cloning a record
This is a small TRIAL database!
I have the following code which is a snippet of Allen Brownes code.
Private Sub cmdDupe_Click()
'Purpose: Duplicate the main form record and related records in
the subform.
Dim strSql As String 'SQL statement.
Dim lngID As Long 'Primary key value of the new record.
'Save and edits first
If Me.Dirty Then
Me.Dirty ...
|
3 |
11/28/2008 4:26:00 PM |
|
|
using a variable for a textbox recordsource
Hi,
Access 2007
I have a form with a public variable called myPublicVariable. The form has
a textbox. I want to use that public variable as the controlsource for the
textbox. I believe it should work if the controlsource of the textbox is set
to "=[myPublicVariable]" but all I'm getting on the form is "#Name?".
The database was sent to us by someone else and it is working as ...
|
13 |
11/29/2008 12:11:15 AM |