|
Me again
Hi Barry
i was wrong i can't get the value from my form into the canlendar form
i have try
Private Sub slutdato_Click()
MsgBox (SlutDato)
DoCmd.OpenForm "kalender_slut", acNormal, OpenArgs:=SlutDato
End Sub
In the msgbox i get the right date but not in my kalender_slut form
Alvin
...
|
3 |
04.09.2006 16:37:02 |
|
|
Form/Subform - Navigation
I have a form with subform which details documents within a contract and data
elements within the documents. The form contains info. about the contract
and one or several documents associated with the contract based on
section_id. The form displays only one document at a time. The subform
contains data elements associated with a contracts documents based on
section_id.
Using the fo...
|
1 |
04.09.2006 16:34:02 |
|
|
Releasing Variables
I know noe that release a String Variable without closing a form the
synax is:
strA = ""
But how dou you clear the other types variables?
Like Date, Long, Integer etc...
Thanks
DS...
|
8 |
04.09.2006 16:09:54 |
|
|
cursor position in textbox
Hai,
In my device application, i have 9 picture box having title from 0
to 9. If you click on the picturebox the corresponding number will be
placed on the textbox.
Say for example, if u click "1" picture, the textbox text will be
"1". again if u click "2" picture then the text will be like "12".
But, my problem is, always the cursor will be near to 1 in the
text box.
...
|
2 |
04.09.2006 13:34:06 |
|
|
Text box events
i have a text box on a access 2003 form. the text box's control source is a
dlookup function.
When the dlookup value changes i want an event to be triggered by cant get
any events to trigger a simple message box. i assume its because im using a
dlookup function.
can anyone offer any advice please?...
|
3 |
04.09.2006 12:45:52 |
|
|
OnDel event: avoiding delete
Hi,
I've got a subform that's in datasheet view. User can delete rows simply
selecting a row and clicking on del key. How can I prevent deleting if
certain conditions exists.
Is it ok for me to use "OnDel" event, to check conditions and if they are
fullfiled to exit "OnDel" somehow, canceling deletion?
thanx
alek_mil...
|
3 |
04.09.2006 08:52:02 |
|
|
Access crashes when I remove filter on a sub form
Hi,
I have a form that contains a tabbed control, on this control is a number of
sub forms amoung other things. On one of the tabs I have two sub forms, one
shows the result of a query to find maiching records from an import, and the
other shows th main table, where the results will end up. The way I have
worked the system is for the user to filter the main table data on various
field...
|
3 |
04.09.2006 08:31:02 |
|
|
sending report to excell
Some one please help.... I need to send a report to excell after the user has
clicked the icon to open the report. I am currently doing this by calling
the same query to dump to excell as I am using on the report, This query is
slow is there any way to do this without calling the query twice?...
|
4 |
04.09.2006 06:50:30 |
|
|
Using recordset.recordcout
Hi!
I have in my form current event this:
lbl1.Caption = Me.Recordset.RecordCount
Its working allright but first after i have clixk to record number 2, when
the form is open i get the value 1 record ???
regards
alvin
...
|
4 |
04.09.2006 04:08:01 |
|
|
Assigned Values
I am new to this and my DB has deposits in which accounts need to have a
percentage added when entered into the form. I have about 7 accounts and some
have three percent and some have two percent. For instance account
KB0013=DEPOSIT + 3%. How would i set that up in the
forms if i have seven accounts and they dont have the same discount?
Thanks
...
|
2 |
04.09.2006 03:26:18 |
|
|
Swap queries to display diferent filtered records in subform
I am trying to use predefined queries as subform data and swap the assigned
query names for the subform data, This swap of queries will be based on
option group radio buttons to filter subform data using the correct query. I
tried other ways that did not work and I think this may be a viable way to
accomplish this task. So my question is how can I use various queries to
filter subform da...
|
3 |
04.09.2006 02:39:01 |
|
|
Parm reference in called subroutine
The code below opens the correct form, the msgbox shows the correct string
(Order Tee Shirts), but I get an error msg on the next line that :
Microsoft Access can’t find the form ‘strToForm' referred to….
How do I get the value for the string to be substituted correctly into the
assignment statement?
Call OpenNewForm("Order Tee Shirts", "Team Entries")
…
…
Public Sub Op...
|
4 |
04.09.2006 01:43:08 |
|
|
Acrobat 7 and Access 2003
Is there a way via VBA code, to specify 3 documents locations maybe via
a text box then have some code to have Acrobat launch in the background
and create one PDF from the 3 docs specified on the form? I picture
the form laid out with the follwoing fields...
txtFileOne
txtFileTwo
TxtFileThree
txtPDFName
txtSaveLocPDF
Any help would be appreciated...
THanks,
Dave
...
|
1 |
04.09.2006 01:24:46 |
|
|
Form from the Internet
Thanks for your time.
I created a form within a website with comments and suggestions for users
from the internet.
My problem is: I receive the email from my network, inside the walls, but
from the internet, users can’t even hit the confirmation page and I don’t
receive the email.
Ports 80, 443, 25 and 110 are open.
When I test the form from my network, I receive the e-mail from th...
|
1 |
04.09.2006 00:25:01 |
|
|
Opening an External Program with access vba
Hello i have to open an external program.but the problem is that i dont have
to open the executable itself. i have shape files and using arcview explorer
to view it. i m using the following command
Dim stAppName As String
stAppName = "C:\ESRI\ESRIDATA\visionpakistan.apr"
Call Shell(stAppName, 1)
but when i run this command an error occurs "invalid procedure call or
argume...
|
6 |
03.09.2006 23:58:12 |
|
|
Prevent Tab Key from executing before update event
I set up a form with the BeforeUpdate event to test for various field inputs.
When the user keys in a record and presses the tab key to move to the next
field, the event fires. The result is that it keeps telling him that he is
missing fields that he didn't get a chance to enter. Is there a way to
prevent the tab key from firing the before update event. This should only
happen after ...
|
3 |
03.09.2006 22:51:01 |
|
|
Error number: 2108 You must save the field before you .....
I received the following message:
Error number: 2108 You must save the field before you execute the
GotoControl action, the GoToConrol method or the SetFocus method.
The form contains a combo box, HRNum, with the Limit to list property set to
No.
There is a sub HRNum_BeforeUpdate which contains the following code to test
for a missing HR Number. I know that the Set Focus is causing t...
|
3 |
03.09.2006 22:45:01 |
|
|
Updating from a form
Hi
I have a form inside another form, in this form i have several dates listed
down with startdate and enddate as two fields. Its working allright, now i
have done it so when i click on a date then i open another form where i have
a Calendar, and when i click on a date in this calendar i should change the
date in my form, but i can only change the first date, if i click on maybe
number ...
|
10 |
03.09.2006 21:42:01 |
|
|
Retain string for further use
I have a form which compiles an sql query when entering data into a form - a
public function "RunFilter()". It creates a string "strw". I want to use
this string for another event "after update" event on a option box in the
same form.
if the string length is > 0 then I want to it to run the public function
"RunFilter()"
How do i do this?
Craig
...
|
2 |
03.09.2006 19:54:37 |
|
|
Select Case
If two cases have the same code can you do this?
Select Case Me.TxtTest
Case 1 and Case 2
MsgBox "1 and 2"
Case 3
MsgBox "3"
Case 4
MsgBox "4"
Case Else
MsgBox "No Msg"
End Select
If not how doy you cut down on repeating code if you have this situation?
Thanks
DS...
|
8 |
03.09.2006 19:52:13 |
|
|
Parameter change using Query
I have a subform frmqerTeeTimes , based on a query qerTee Times. The subform
is linked to the main form "frmCompetitionMasterData" by the field "fldDate".
The data displayed in the subform is a range of times given by the selection
criteria (Between#07:30# and #16:00#)for the field "fldTeeTimes".
Question
Can I attach a query to the on current event of the subform that will change
the se...
|
1 |
03.09.2006 19:18:01 |
|
|
build sql where clause from pasted text box entries..
Hi,
I'm trying to build a parameterized sql from data pasted into a text box.
The data can be from 50 to over 300 record keys, which they will want to
export to excel.
what would be best route, or another if not possible..
thansks!
...
|
2 |
03.09.2006 18:32:42 |
|
|
Filter Options
I have a form with a subform. In the form, I have a select query as follows:
SELECT tblOrders.OrderID, tblOrders.CustomerId, tblCustomers.CompanyName
FROM tblCustomers INNER JOIN tblOrders ON tblCustomers.CustomerID =
tblOrders.CustomerId
ORDER BY tblOrders.OrderID;
In the subform (SubfrmOrderLines) with the following query:
SELECT tblPictures.Style, tblPictures.FilePath, tblPictures....
|
5 |
03.09.2006 17:17:01 |
|
|
Record source problem
Hi
I Saved As... a form to another name and change the new forms data source.
The problem is that the new form does not show any data with the new data
source. I have tried compact & repair and decompiling but no luck.
Eventually I had to put in the form load event the command
DoCmd.RunCommand (acCmdRemoveFilterSort) to make the form show any data. Why
would the form have a filter...
|
4 |
03.09.2006 16:13:48 |
|
|
A way to get to a particular switchboard page
Hi I am after a way to load a particular switchboard page from my main
switchboard.
I already have 8 buttons (limit) and have now started putting the few
additional ones down the far left edge that I need on all switchboard pages.
These are mainly opening forms or compacting database which is fine but I
need one to go to my 3rd switchboard page and can't find a way to do it. I
have tried t...
|
4 |
03.09.2006 15:52:57 |