|
Easy Drop Down Box Question
How do I ake a dropdown box populate values off of the "state" field in the
"contacts" table?
Ideally, I want each state to be listed once, assuming it is already listed
in a record in "contacts".
I plan on using this form field as a query criteria, so if possible, I also
want to make it so I can select all (or a combination?) of the states.
Thanks for the assist.
-Adam...
|
18 |
27.09.2006 16:40:02 |
|
|
Buttons enabled/disabled
Hello.
Is possible to enable/disable a button in a form, depending on the value of
a certain text field?
Thank you.
Acores...
|
5 |
27.09.2006 16:46:28 |
|
|
Limit characters in a text box
HI,
I have a text box on a form and I want to prevent the user from entering
more than 30 characters. Isn't there a way to prevent data entry after 30
characters are entered?
Thanks,
--
Phil...
|
5 |
27.09.2006 16:36:03 |
|
|
Use command button to populate subform Tab
Hi all,
I have a subform, called DATA, and on that subform is a bunch of tabs,
each with different fields on them. I have a tab called NUMBERS, with
fields that contain numbers as data type. What I need is a command
button to be clicked when a user is finished entering data, and any of
the feilds on tab that are not filled, for them to be filled with "NA".
Can this be done?
Thanks!
...
|
3 |
27.09.2006 16:26:15 |
|
|
Help opening an Excel file
Hello all
I need to open an excel file from my access form. Everything is working
fine, here is the code that I am using:
Dim MyObject As Object
Set MyObject = GetObject("C:\MIS Inventory.xls")
MyObject.Application.Visible = True
MyObject.Parent.Windows(1).Visible = True
The problem is, I want to open a file that is on the network, this is
the path:
\\Dc-tfh\mis\MIS Misc\Inventory\H...
|
8 |
27.09.2006 16:19:36 |
|
|
how do i clear values that are automatically entered to a form?
On my form I have a combo box that looks up values from a query. This data is
automatically entered onto the form.
How can I make the values so that they do not display anything?
Thanks
...
|
3 |
27.09.2006 16:16:02 |
|
|
date format
Can I format a time as hh:nn but have it display 2:00 for 2 pm rather than
14:00 without showing the AM or PM?
--
sam...
|
7 |
27.09.2006 16:15:02 |
|
|
FollowHyperlink has Question Mark in front
I'm trying to take information and open a browser to Google Maps. I got
it working almost perfectly fine, except for an error the screws things
up every now and then.
It outputs this link:
http://www.google.com/search?sourceid=navclient-ff&ie=UTF-8&rls=GGGL,GGGL:2006-29,GGGL:en&q=%3FTexas+Tech+University+Lubbock+TX
Notice the "%3"
This is the code I'm using:
Private Sub Search_Cli...
|
2 |
27.09.2006 15:58:38 |
|
|
Access ADP Truncating Data
I have an Access 2000 ADP which is a front-end to a SQL Server database. One
table I am using has a VARCHAR column of 8000 characters. Inside the code of
the Access ADP, where I assign a string variable to the SQL table's column,
the resulting value in the SQL table is truncated. It only retains the last
40 characters or so of the string (it is not just cutting off the end, but
rather...
|
1 |
27.09.2006 15:17:02 |
|
|
grabbing a rate field
I have a table that has a client id, delivery yard#(can be more than one of
the same #, deliv yd name,pickup yard#(can be more than one of the same #),
and type of
material(2choices). Based on that combination of what is in those three
fields there is a given RATE. On the form based on this table I would like
the rate to automatically fill based on the combination of the 3 fields
chos...
|
3 |
27.09.2006 15:14:02 |
|
|
layout of tables and query
I have 3 tables
CLIENTTABLE
clientid-PK
clientnumb
clientname
address
state
etc
TBLTANKRATES2
rateid
clientid-pk
pickupyd-pk
pickupydname
delivyd-pk
delivydname
typeofmat-pk
rate
TANKTICKETENTRY
clientid-pk
ticket-pk
servicedate
typeofmat
pickupdyd
delivyd
truck#
gross weight
comment
I need to grab the rate value from the tanksrate2 table where the
clientid,pic...
|
1 |
27.09.2006 15:13:01 |
|
|
Command button problem
I have 2 command buttons. The first views all data in a subform. The second
prompts for a user name to view data just for that particular user. They
are each using a different subform (data coming from same query), and the
code in the event is calling out the correct subform. My problem is if I
make a change to the second command button, the first one also changes (such
as changing reco...
|
6 |
27.09.2006 15:06:02 |
|
|
Rotate object/Image
I have been looking for this for a long time already and it seems nobody
does it.
I use Stephen Leban's code to display images and zoom in and out on them.
I have tried many ways including propretary third party controls but now
there has been changes and I cannot go around and install controls on other
machines.
Therefore I must use the Image Control.
Is there a way to rotate the image?...
|
5 |
27.09.2006 15:05:37 |
|
|
wrong data showing in form
Can someone help? I click on my Command button, which brings up a subform of
part numbers and pertinent information (which all comes from one query).
When I click on a part number, a form comes up (and should show) the info
for that part number in a form. But the info showing is the last info
entered into the table.....not the part number I'm clicking on. How do I
set it up so the info o...
|
2 |
27.09.2006 14:38:02 |
|
|
another date question
My backend is SQL server 2k and I'd like to display only the time portion of
a datetime field. Although I can set the format to whatever I want, when the
user wants to edit the time, they can see the entire field with the date and
seconds, etc. If I format the time in the control source, the time is no
longer editable. How can I display just the time and retain ability to edit?
Thanks!!...
|
1 |
27.09.2006 14:32:02 |
|
|
Adding a Tab Control
I want to add a tab control to a form that covers the whole form. When I do
this the background color of the tab control is white. I want to change it so
that the color is transparant so that whatever back color I use for the form
will show through. I can't seem to find a place in the properties to change
the color of the tab control or make it transparent. I have used a tab
control befo...
|
2 |
27.09.2006 14:28:02 |
|
|
How to export 2 decimals
I want to export a table that has numeric double fields to a fixed
format file. I need the output field right justified with decimal point
followed by 2 decimals (xxxxx.xx). I can right justify the field but
how do I get the 2 decimals?
Using Access 2K
tia
Jim...
|
3 |
27.09.2006 14:15:09 |
|
|
Loading different images
Need help people with some code
I have photos(gif files) for each person in a folder on c:\desktop
I have a table field with each persons name which match the gif files on
c:\desktop
so would like to match Mark with mark.gif when i load that display form
(individual profiles)
Obviously I use an image file on the 'individual profile' form but need the
code to find the correct gif file.
...
|
1 |
27.09.2006 12:01:03 |
|
|
Displaying Normalised Data
I have inherited a database with a main table that holds about 100 fields. I
know what you're thinking - "glorified spreadsheet" - and you're absolutely
right. I have never had to normalise something this big before, so I was
looking for some opinions.
For example, I have three fields in the main table:
[Title]
[Subtitle]
[TitleShort]
I figure this should be made into another tabl...
|
2 |
27.09.2006 11:43:52 |
|
|
How to 0pen multiple subforms from a main form using buttons
I have one main table that contains students and it links to 5 different
tables using one to many relationships. I can create a main form to select a
student and see their information and have it include one subform created as
a linked from one of the 5 tables and it works great. I'd like to be able to
have 5 buttons so that it can open different linked subforms from the main
form. I ...
|
4 |
27.09.2006 11:41:10 |
|
|
Re: Stephen Lebans Calendar; Repositioning
Hi all,
Stephen's "Calendar Control" is an awesome tool. I recommend it for anyone
who works with dates.
My question:
Can someone point me in the right direction to change the position the
calendar pops up in. My dates are at the bottom of the page, so the calendar
hangs off the edge under the task bar
Thanks,
Nick...
|
4 |
27.09.2006 11:40:02 |
|
|
De-select default value
I have this coding (which was given to me by MVP\ in this forum,
thank you very much) in a txtbox that has '-B/O' as it's default value
Private Sub TxtPoNo_AfterUpdate()
Const strAddText As String = "-B/O"
If Right(Me.txtPoNo.Value, Len(strAddText)) <> strAddText Then _
Me.txtPoNo.Value = Me.txtPoNo.Value & strAddText
End Sub
The problem is that when I tab into the control, t...
|
4 |
27.09.2006 10:25:39 |
|
|
Opening an Outlook email from Access
Hi Guys!
I have the following code:
Dim strEmail As String
If Not IsNull(Me.Email) Then
strEmail = Me.Email
If Left(strEmail, 7) <> "mailto:" Then
strEmail = "mailto: " & strEmail
End If
Application.FollowHyperlink strEmail
End If
Which opens an email when assigned to the relevant button or what not.
The problem I have...
|
1 |
27.09.2006 07:27:42 |
|
|
text box problem
Hi,
I've got a text box on my form that is used to input a time.
Format is 'Short time', Input mask is '00:00;0;_' and Default value is
'=Time()'.
The problem is when I clik the text box in order to change time, time turns
from short time (example) 17:15 to 17:15:00 and when I'm done with editing
text box wont' accept it (those seconds that appeared out of nowhere are
problem for input ...
|
3 |
27.09.2006 06:49:01 |
|
|
VB Error 2107 when setting the recordsource of a form ??
Hello everyone !
I have this weird problem with an Adress Form I cannot figure out.
The function of the form is to display a list of adress names in a listbox
(left part of the form) which will synchronise the field textboxes of the
selected record (right part of the form).
So when you go through the listbox on the left you see the fields change on
the right.
When the form opens:
...
|
2 |
27.09.2006 06:44:23 |