|
KEEP FORM OPEN IF A FIELD IS BLANK
I WANT TO CREATE A MACRO OR VALIDATION OR MODULE THAT WOULD NOT ALLOW A FORM
TO CLOSE IF A CERTAIN DATA FIELD WAS LEFT BLANK. I CAN SET VALIDATION RULES
BUT I AM STUMPED ON HOW TO KEEP SOMEONE FROM ENTERING FURTHER INTO THE
DATABASE UNLESS THEY SIGN IN PROPERLY....
|
5 |
11/27/2008 7:44:00 AM |
|
|
Stringing Several Record Values Together (From The Same Field) And Transferring to A Textbox Control
Hi,
I have a subform which is among several controls displayed when a user
brings up a specific form. This subform is in datasheet view, and it
could display anywhere from 1 record to several records. For
example's sake, the first field is called 'TicketNumber'. There is an
option at the bottom to open another form as well. When the user
selects this option, another form is opened an...
|
2 |
11/27/2008 1:45:35 AM |
|
|
Calendar - Entering Information Pertaining to a Specific Date
Is there a way to have a calendar on my Form so that I could pick a specific
date and then add information specific to that date into other fields...i.e.,
I would like to be able to choose a date, such as November 25, and then for
that date enter information like Client Name, Number of Miles, and Mileage
Rate, and have this information saved into a table. Could this info also be
display...
|
2 |
11/27/2008 1:34:28 AM |
|
|
Forms or Reports
Either "I" lack of understanding of Access or the Access designers have a
lack of understanding of User erquirements. I need to know if I understand
the basics of Access, such as:
Original Data:- For my application, this is a Text File generated by a Real-
Time Software DataLogger connected to an industrial process.
Tables:- For my application, these tables are generated by reading the
...
|
6 |
11/27/2008 12:41:51 AM |
|
|
prevent maximize
My custom dialog opens from a toolbar button. The dialog has a twin
(same-sized) dialog that acts like Tab 2, meaning when the user clicks the
tab the other custom dialog opens on top of the other, and back again to Tab
1, so I can't set the PopUp or Modal property to Yes. I want the user to be
able to toggle back and forth.
How can I prevent the these smaller forms opening in max mode ...
|
2 |
11/26/2008 11:43:01 PM |
|
|
Update 3 tables w/ 1 Form
I'm new to Access, and am figuring my way around it. I've tried to update
multiple tables with one form, but haven't been able to do it. I've split
the tables in accordance with Normalization Forms, at least to the best of my
understanding. So, is there a way that more than one table can be updated and
accessed by a single form?...
|
3 |
11/26/2008 11:07:44 PM |
|
|
MoveSize not working as expected
I'm trying to open a form directly over the top of another form. I'm doing
this using the following code in the forms Load event:
If IsLoaded("frm_LD_Comments") Then
Set frm = Forms("frm_ld_Comments")
DoCmd.MoveSize frm.WindowLeft, frm.WindowTop, _
frm.WindowWidth, frm.WindowHeight
Set frm = Nothing
End If
What I was e...
|
7 |
11/26/2008 10:42:50 PM |
|
|
auto number format
Is there a way to make the auto number have 6 digits like 000001,
000002 ect... any help would be cool
Thanks in advance, Dan...
|
10 |
11/26/2008 7:55:49 PM |
|
|
"The field is too small..." error in form drop-down
There are 2 forms using the same select query to create a drop-down.
-The first form is small and wide, and works correctly with-out any issues
or errors.
-The second form is tall and narrow, but gives an error on anything
drop-down selection longer than 50 characters.
a) I reduced the table's text field from 100 down to 72 characters. Where
the longest string has 69 characters.
b) I ...
|
2 |
11/26/2008 7:53:35 PM |
|
|
Listbox - Change underlying field value.
Hello,
I have two listboxes for assignments. First listbox (Current) contains all
current assignments and the second listbox (New) holds recently assigned
items until staff "accepts" then by highlighting the listbox item and
clicking a button. The query criteria for the "New" listbox filters
assignments on a Yes/No field set to true. The "Current" listbox query
filters assignments ...
|
3 |
11/26/2008 6:57:03 PM |
|
|
Spelling isn't available now
Hi,
I have a form with 2 text boxes and have a button on it to perform
spell checking. My code for the button is below, but it doesn't run
and fails with the message 'Spelling' isn't available now.
Any ideas on where I have gone wrong (the standard spelling macro
fails as well, but i can run toolbar spell check in a field in a
table).
Thanks
Dim ctlSpell As Control
Dim frm As For...
|
2 |
11/26/2008 6:13:01 PM |
|
|
Copying functions from one form to another - ie Map button macro
I am using the Contact management database and I am trying to set up a new
form and want to use the map button they have on one of the standard forms
provided in a new form. The map button will display directions and a
satilight map to the address from the address field.
How do I copy this from one form to another? I think it is an imbedded macro
or visiual basic deal.
Can someone h...
|
2 |
11/26/2008 6:08:03 PM |
|
|
Form closes the other form while changing to DesignView
I have a form with control button wich opens other form. Somehow the latter
form "have learnt" to close the former while I change it to DesignView. Other
similar forms "behave themselves" - so, I guess, I accidentally changed
something in the rebellious form.
What property is responsible for such a misbehaviour?...
|
9 |
11/26/2008 5:25:00 PM |
|
|
Running A Public Function To Check The Time When A Form Action Is Taken
Hi,
I would like to be able to check the time when a specific action is
taken on my form before anything else happens. This is the public
function I am trying to use.
Public Function WhatsTheTime() As String
Select Case Time()
Case "> 7:00:00 AM" To "< 3:00:00 PM"
WhatsTheTime = "Day Shift"
Case ">3:00:00 PM" To "<11:00:00 PM"
WhatsTheTime = "Swi...
|
7 |
11/26/2008 4:56:55 PM |
|
|
Datasheet View in a Form
I have a subform that I need to present in a datasheet view. However, I want
to remove the sort arrows on each field heading. Can this be done, and if
so, how.
Thanks in advance for the help!...
|
3 |
11/26/2008 4:40:01 PM |
|
|
Write Conflict Dialog Box
Greeting and Happy Thanksgiving (2008) to all...
I have read many, but not all, the threads on WRITE CONFLICT dialog box
poping up. I have tried all the ideas presented, at least I think I have,
yet I can not get mine to stop poping up.
I have two forms: frmProjectInfo (tblProjectInfo) and frmContactInfo
(tblContactInfo)
frmProjectInfo does many things, including storing an Integer in t...
|
1 |
11/26/2008 4:32:34 PM |
|
|
Form and subform
Hi,
I will try to explain my question as clearly as I can.
I have a form which contains a subform inside. I have a combo box in the
main form that contains a list of customer's ID. When choosing the combo,
the subform populate the data with that ID. Says in the subform I display
ID, Name, Last name, country, city, state. These 6 columns stored in one
table.
Now in the subform, th...
|
1 |
11/26/2008 4:04:10 PM |
|
|
Save related record when opening separate form
I have a form where I enter address records. Its based on the table
"Addresses". It has a comand button which opens another form based on a
related table (occupancy). The problem that Im having is that after I enter a
record in the address form and click the comand button to open the other form
an error message comes up stating that I must first save the record in the
related (address) table....
|
3 |
11/26/2008 2:17:02 PM |
|
|
Weekday()
Hi Guys,
I have 2 fields Date and day of the week, what I want is to move the day of
the week automatically went I input the date. I know I need to use this
function Weekday([dReportDate]), but I don’t know where to used.
Any help will be appreciated
PS: I am new at access programming
...
|
5 |
11/26/2008 1:48:15 PM |
|
|
Total sum of cost
I need a total cost field to calculate the sum of a field and for it
to appear in my query as a field any help would be cool...
|
6 |
11/26/2008 1:38:58 PM |
|
|
Use Windows Themed Controls on Forms
Hi,
I have an Access 2003 app which I am developing on one pc (mine) and
continually testing on another (the client's.) Both are running WinXP.
Both machines are using the Windows XP theme, set in Display Properties.
Both have the Access option ticked for "Use Windows Themed Controls on
Forms"
The appearance on controls such as text boxes and command buttons is as I
would expect o...
|
1 |
11/26/2008 12:24:29 PM |
|
|
subform
Hello,
In the main form and a subform. When I select the record in the subform, I
want to display the same record in the main form, or vice versa. Can
someone point me in the right direction or send me an example?
Thanks very much,
Joel
...
|
2 |
11/26/2008 7:28:59 AM |
|
|
How to make automatically
Hai all,
Thanks for your support to me of my latest question, here I have another
question that need your help.
I have a table, name : tblworker, consist of two field : WorkerName & BadgeNo.
Then I make a form consist of two text box which link to both of tblworker
fields. When I type BadgeNo on the text box form, I want WorkerName also
automatically appear. How can I do that??
--
Messa...
|
3 |
11/26/2008 2:25:25 AM |
|
|
Removing the 'Deny' option when sending emails via Code
Hi,
I am using the docmd.sendobject method to automatically generate an
email using the User's outlook and then send it with an attachment. I
am also using docmd.setwarning False and docmd.setwarnings True before
and after I send the object, respectively. However, the user still is
asked to 'Allow' the code to send the email. Is there anyway around
this? The email is sent to some degree...
|
4 |
11/25/2008 10:31:43 PM |
|
|
Week number
Hello,
Is there a function in Access that do the same thing as 'Weeknum' in Excel?
I have a textbox that shows the current week number... so I'm thinking of
something like weeknum(date())..
Thanks
...
|
4 |
11/25/2008 10:19:17 PM |