|
Hiding a combo box with Option Selection
I am looking for help with some programming. I have an option box on the form
with 2 selections (Canada (-1)and United States (0)). So when either of then
are selected I need a combo box and lable to hide and another to appear. If
Canada is selected I need the label Province to show (State to hide) combo
box with Provinces to show (combo with States to hide) And vice versa if
United States is...
|
4 |
13.09.2006 19:04:32 |
|
|
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 |
|
|
Error: You can't go to specified record
From my Proposal Form, I open another form for creating a new record,
specifying the proposal number on the first form. I have the proposal number
field locked on the second form, but when trying to add the record, I get the
above message. Any reason?...
|
1 |
13.09.2006 18:24:01 |
|
|
Add Note Button on already opened form
I'm adding an "add note" button to a form I've created (or maybe it will have
to go on another form.....). Anywho, I've got a form and it has this add
note button, and I click it and the add note form comes up. However, I need
two things to happen, maybe even three:
1. The "add note" form appears behind both the already opened form AND the
switchboard. I can't think of a case where I...
|
5 |
13.09.2006 17:20:04 |
|
|
Run Report using ListBox selection
Hi All,
I have a form called "frm pick team member" and a list box on it called
"picklist".
I want to be able to run a query from this form, after the person has
clicked the info they want.
Currently i have it set up as follows:
the user opend the frm, clicks on one of the list box options, which then
activates a macro to open the query. the query criteria has the following in
t...
|
3 |
13.09.2006 15:18:01 |
|
|
Form With Calendar Control - HELP
I have a calendar control on my form that is not bound to any field in a
table. I just need it to display todays date and see future dates (and later
possibly use it to populate a field with a date). For now i just need it to
show todays date. However, when the form is open it always shows the same
date back in june.
How can i get it to display todays date??
Thank you...
|
1 |
13.09.2006 15:16:02 |
|
|
Duplicate key error on data entry with subforms
Hi,
I have a main form which contains course information.
I also have two subforms which contain the equipment for that course
and any breaks the course has.
These are linked in a one to many relationship with the main form.
When i fill in information for the course, and then move to the subform
and enter something there everything seems to happen ok.
When i then try and select anot...
|
3 |
13.09.2006 13:35:50 |
|
|
List Box Questio
I have the following code behind the form's "On Open" event:
Sub Form_Open(Cancel As Integer)
On Error GoTo ErrHandler
Dim App As Object
Dim CurProject As Object
Dim CollReports As Object
Dim objRpt As Object
Dim strRptName As String, strReportList As String, i As Integer
If SysCmd(acSysCmdAccessVer) < 9 Then
i = 0
Set CurProject = CurrentDb
Set CollReports = CurProje...
|
2 |
13.09.2006 13:33:51 |
|
|
Code to make Combo act like arrow has been pressed on Enter proper
Folks, thanks for the help in advance. This is an easy one. I want to have
the Combo Box look like the drop down arrow has been pressed just as soon as
the object has focus.
...
|
2 |
13.09.2006 13:28:32 |
|
|
Emailing from a form - upper limit for "To" field lenght?
MS Access 2K, Windows XP
====================
Hi,
I'd like to send an email to people selected from a form using a list. I've
figured it out how to send email using SendObject.
My question has to do with the limit on the number of email addresses that
can be included, or more specifically, limit on the number of characters in
the "To" field.
What's the limit on this? We have mor...
|
4 |
13.09.2006 13:09:01 |
|
|
Saving data
I have a form that lists summary records. the user will double-click on one
of those records to open the details for that record.
The user then makes changes to the details, and clicks a button to return to
the summary list.
The problem is that the changes just made by the user do not show up on the
summary list.
The order of events for that command button are:
close the summary...
|
2 |
13.09.2006 12:46:06 |
|
|
Error Exporting To Excel
I get the following error message when exporting a forms record source to an
excel fle.
"There are too many rows to output, based upon the limitation specified by
the output format."
What is an output formatand how do limits get put in it?
The user is selecting "File/Export" when the form is up.
Access 2000
Jack
...
|
2 |
13.09.2006 12:42:00 |
|
|
VB and Access
If you use Visual Basic as the Front End and Access as the Back End do
you still need to install Access on the machine that the final program
will be run on? If so is it a "Runtime" version or a full version and
is i version specific?
Thanks
DS...
|
10 |
13.09.2006 12:40:53 |
|
|
Can access finish a script after close
I am trying to make a file update sort of thing for when I make changes
to the user-side MDB
I have it checking byte size vs the master copy on a server. My desire
is to have it copy it, close the one its in, and rename the copy to be
the original. Obviously the problem is that the renaming cant be done
after access is closed... Is there any way anyone can think to automate
this process?
...
|
4 |
13.09.2006 12:34:02 |
|
|
How to read and write binary file using VBA in MS Access 2000
Dear all
I am required to read binary file, then replace some word in the file.
Finally, output the edited file into binary format, which is same
format as the original file using VBA in MS Access.
I am a newbie using vba. Could you give me some sample code on read
binary file, replace word in the file and output binary file with exact
same format with the original file?
Cheers
Bon
...
|
1 |
13.09.2006 12:06:35 |
|
|
Refreshing a pivot chart
I have a form, frmCoils. in it, when a user selects a CoilID a query,
qryChartData is filled with values from a table linked by CoilID.
qryChartData is the basis of 2 pivot charts, fmctVIW and fmctRFB.
the pivot charts are displayed on the frmCoils. Is there a way to get the
pivot charts to redraw themselves when a new CoilID is formed.
I have a vb event that activates when the comb...
|
2 |
13.09.2006 11:51:02 |
|
|
sort order in subform
In a subform, I have 2 fields: RoomNumber and ItemNumber.
It is in datasheet view and the Record Source is the table "Item".
In the Order By property, I have: Item.RoomNumber, Item.ItemNumber
It does not retain that sort order as ascending. Users can highlight and
sort on their own, but it does not hold the order that it was sorted in when
users go back into the database.
Any ideas wh...
|
4 |
13.09.2006 06:07:02 |
|
|
update rows in dbase4-how to
hello.
i want to update some rows in dbase4 file which is location in 'c:\final
directory'. the name of dbase4 file is 'data_final.dbf'.
well i tried to link this file to ms access but cant, as the length of
filename.
however the data_final.dbf contains sum of the data based in ms access tables.
i am trying to do this in vba. can anyone tel me how to link to / make a
connection to dbase ...
|
7 |
13.09.2006 05:42:01 |
|
|
Delete button
Hi,
i am creating an inventory system. I have a problem in my delete item form.
I hope when i click the delete item button ( which means that item doesn't
exist anymore in the office ) ,the details about that item doesn't appear in
the form anymore. But my bos, wanted me to save the records in other tables
so it would be easier for later use. Right now i don't know how to duplicate
the reco...
|
1 |
13.09.2006 04:48:17 |
|
|
Fiscal Year and Quarter
This fantastic expression was posted by Duane Hookom. I have no idea how it
works but it displays the fiscal year and quarter for FY starting on October
1.
=Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0)
It displays the first quarter for FY 2007 as Q1 2007.
However I would like to display this as 2007 Q1. I couldn't get this to
work.
JohnC
...
|
3 |
13.09.2006 03:49:24 |
|
|
Form stays open in Print Preview
My parameters were passing to my report in print preview, but when I pressed
the print buttom the #Name? error showed up on the printed report. So I
removed the close form from my macro and now the form floats over my print
preview screen. Is there something that I can do in my macro to git rid of
the form, but be able to read the parameters from it?
...
|
5 |
13.09.2006 02:35:02 |
|
|
Opening a Word doc using a command button on a form.
Hi all:
Can anyone please tell me what code is needed to open a particular MS Word
document? For example say the path to the file is: C:\Folder\FileName.doc.
What code do I need to open the document?
The background is...I have a form that the user selects a value from a combo
box that populates the criteria in a query. The query provides the records
to be used in a mail merge in MS ...
|
3 |
13.09.2006 01:53:43 |
|
|
HTML in Code
Hi All,
on the double click command for my PRONUMBER fld I want to execute HTML and
launch a website.
How would I set this link up in code?
http://www.myyellow.com/dynamic/services/servlet_
?CONTROLLER=com.yell.ec.inter.yfsgentracking.http.controller.
TrackPro&PRONumber=[PRONUMBER]
--
Matt Campbell
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
http://www....
|
1 |
13.09.2006 01:33:21 |
|
|
Return to code after opening a from
I have Form-A with CmdButton-B to execute code. In that code I need to Open
Form-X on line 12 of the code. Is there a way to return to Line 13 of the
code after closing Form-X?
steve...
|
2 |
13.09.2006 01:26:01 |
|
|
data entry methods
My db has 2 tables, CoName and CoLocation. It is just a simple little
app that will help save me loads of time and typing/writing.
I have some data that I will put in the tables to get started, but
what I want to be able to do is to add data to the tables as I use the
app. I thought to use combo boxes to populate my form, and if the
data I need is not in the table, I would like to add it t...
|
9 |
13.09.2006 00:02:53 |