|
how to link text form field to other pages
How to link a text form that's in the body of a word document to appear on
subsequent pages so the user doesn't have to type the same info on each page....
|
2 |
28.09.2006 18:37:58 |
|
|
Assigning 1/0 to yes/no
Is there a way to assign a value of 1/0 for yes/no, respectively?...
|
7 |
28.09.2006 18:33:34 |
|
|
Moving record from a table to another one
Hi ,
I want to use this for archives...What is the easiest way to do this ?
Is the DELETE from the source and ADDNEW to the new table is the way to do
it ? It must have a easiest way.
Tks...
...
|
6 |
28.09.2006 18:31:34 |
|
|
Count Months in form
I have in my form text box 'MyDate' and text box 'Month after date'.
Quaterly i need count moths in my text box 'Month after date'.
For example:
next 1 quarter
If my current date between 3/31/2006-6/29/06 then count month
between 'MyDate' and 3/31/06
next 2 quarter
If my current date between 6/30/2006-9/29/06 then count month
between 'MyDate' and 6/30/06
next 3 quarter
...
|
4 |
28.09.2006 18:28:29 |
|
|
Form Question
I have a form that has two tabs on it. I pasted an arrow from word into the
form which I want to show on only the first tab. However, the arrow shows up
on both the tabs. Is there a way to draw an arrow in Access, I know you can
draw a line but can you make it an arrow. How would I get the arrow to show
up only on the tab I want it to be on. I am using Access 2003.
Thanks in advance for...
|
2 |
28.09.2006 18:11:01 |
|
|
highlight entry on click
I'm designing a database in which the data entry person is a modified worker
who is not familiar with computers at all.
On the entry form, is there a way to highlight the default value on click,
so if she uses mouse, she doesn't have to double click to highlight the
existing value or use keyboard to delete it?
Thanks,
...
|
2 |
28.09.2006 17:55:02 |
|
|
If-Then Help! Seems easy
This question is hard to explain but basically im getting a runtime
error#13 at the bottom where it says: "if strng then". Idk if thats
proper syntax or not but im trying to make it so that i can have a
search and a search criteria withuot doing ALL the different IF
combonations. This is the best way i could think of and it doesnt seem
to like the whole string being the criteria. Could anyone...
|
2 |
28.09.2006 17:50:42 |
|
|
Query - date format
I am trying to pull date within 1 year.
What format should i use in my query....
|
6 |
28.09.2006 17:39:02 |
|
|
Detect idle time on access database
Hi,
I have recently used the Microsoft that will detect idle time coding on
my Access database and it works fine as long as you do not add any data
or move from one form to another. As soon as you do that, when idling
code kicks, an error message from Microsoft "Microsoft has
encountered a problem and needs to close" comes up.
Do you have any idea how that can be fixed?
Thank you in advan...
|
1 |
28.09.2006 17:27:59 |
|
|
Combo box Value list to subform
Hello
How to get a subform to show details based on a combo box value list on the
main form?
Regards,...
|
3 |
28.09.2006 16:51:01 |
|
|
Export to Excel Hides Spreadsheet
All,
I am working an Access form which exports a recordset to an existing Excel
spreadsheet template, then saves the spreadsheet with a new file name. The
problem is when I open the new spreadsheet in Excel the workbook is hidden.
I have to select Window/Unhide in Excel to make the spreadsheet visible. How
is this happening?
Here is the code:
'Open the blank order sheet
...
|
1 |
28.09.2006 16:46:06 |
|
|
Re: Rotate object/Image
Since it has been a few days since the last post, I am reposting it
Thanks for the reply and sorry for responding so late.
Well... This is too much for me unless you care to explain.
This is beyond my knowlege.
I saw the Mirror functions and the Flip functions but it doesn't give me the
option to rotate.
MirrorX and Flip gives a 180 rotation but I can't set the degree.
I also found the Ro...
|
2 |
28.09.2006 16:21:21 |
|
|
Importing forms with same name
I have a form that i have modified and i need to import it into 46 other
databases. This form already exists with the same name as the new one and
when i import it, the name changes to rptCPRJCT1. This throws off all my code
because they are looking for rptCPRJCT.
Is there a way to have the imported form replace the existing one that has
the same name as opposed to adding a 1 to the end of...
|
3 |
28.09.2006 16:00:22 |
|
|
Display query selection in Form
I have created a form that displays the results of a query. I have used
the function "Between [Date1] and [Date2]" in the criteria section of
the query for Field:Date. I am trying to get the Form to display what
they chose for Date1 and Date2. I am not very accomplished in Access
so specifics would be appreciated. Thank you in advance for your help.
--
Andnor...
|
3 |
28.09.2006 15:19:06 |
|
|
Deletion requiring table?
i hope this doesnt sound like a dumb question, i jst need alittle guidance.
i have a form which can be deleted (according to the dates entered). if the
user decides to delete the record, is there a way i can store some
information from the record on another form BEFORE it's completley deleted...
i.e i need to know which employee deleted that record and why (as well as the
record_id etc) doe...
|
5 |
28.09.2006 14:39:02 |
|
|
Password Fields
I have created a form with a password field on it which once entered allows a
user to open other forms however, the password field, when the form is opened
allows the user to hit enter and the form will open (without entering a
password). Once a character is entered and erased or a password is
misspelled it will not allow access to the forms. Ive tried defaulting the
field to a non pass...
|
1 |
28.09.2006 14:39:01 |
|
|
Opening a form to display current record
Hello all,
I'm viewing a record on form A, I want to create a "Open Form B" button on
this form which would, upon opening form B, display the record that was being
viewed on form A.
Any easy way to accomplish this?
Thanks....
|
1 |
28.09.2006 14:38:03 |
|
|
LogError ... Error!
Hi there
im using Allen Browne's Creating an Audit Log however i keep getting a
compile error (in a module) saying that the term 'LogError' sub/function is
not defined....can some please Help!!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1
...
|
1 |
28.09.2006 14:25:03 |
|
|
ComboBox.RowSource Property: error '2176' The setting for this pro
Hello Everybody,
I have a question about this property. I am setting the value of this
property with the name of all the tables contained in the TableDef
Collection. That is, a list value is created:
......
Dim fields As String: fields = ""
Dim tables As Collection
Set tables = DAOUtils.ListTables(TSourceDb)
fields = MiscUtils.CreateListFields(tables)
Set table...
|
1 |
28.09.2006 14:17:02 |
|
|
Combo does not show new values
Hi. I've got a form, in the that form I have a combo box that is filled by
some data that exists in a table. I n that form I also have a button, and any
time I need a value in that combo I press the button and another form will
open, the previous form is not to be closed. In the form that just open I
insert the new value that does to the table that have that data that fill tha
combobox. ...
|
5 |
28.09.2006 14:09:11 |
|
|
Form Appearance
How form properties control their appearance has been confusing for me; none
of the sources I've read shed much light on it. Can anyone can recommend a
good reference?
In particular, I have a form that is maximized on opening. A command button
on the form opens a second form with related data, also maximized on open.
When I close the second form, the focus returns to the first form, ...
|
1 |
28.09.2006 14:04:02 |
|
|
If-Then-ElseIf Simple Question
This question is hard to explain so i will show you an example:
dim strng as string
Set find = CurrentDb.OpenRecordset("Name", dbOpenDynaset)
find.MoveFirst
If chkJob.value = -1 Then
If Len(strng) = 0 Then
strng = "find!title = " & cboJobtitle
Else
strng = strng & " AND find!title = " & cboJobtitle
End If
End If
If chkyears.value = -1 Then
If Len(str...
|
1 |
28.09.2006 14:02:24 |
|
|
If-Then-ElseIf Simple Question
This question is hard to explain so i will show you an example:
dim strng as string
Set find = CurrentDb.OpenRecordset("Name", dbOpenDynaset)
find.MoveFirst
If chkJob.value = -1 Then
If Len(strng) = 0 Then
strng = "find!title = " & cboJobtitle
Else
strng = strng & " AND find!title = " & cboJobtitle
End If
End If
If chkyears.value = -1 Then
If Len(str...
|
1 |
28.09.2006 14:01:01 |
|
|
If-Then-ElseIf Simple Question
This question is hard to explain so i will show you an example:
dim strng as string
Set find = CurrentDb.OpenRecordset("Name", dbOpenDynaset)
find.MoveFirst
If chkJob.value = -1 Then
If Len(strng) = 0 Then
strng = "find!title = " & cboJobtitle
Else
strng = strng & " AND find!title = " & cboJobtitle
End If
End If
If chkyears.value = -1 Then
If Len(str...
|
1 |
28.09.2006 13:54:50 |
|
|
Continuous form combo issue
I thought I had successfully done this before but apparently not!!
Hi Groupies
My main form has a continuous subform with two combo boxes. The first combo
is a category selector, the second shows the items in that category.....no
problem there.
The issue is that when I move to the next record in the subform and select a
value from the Category combo, it changes the value in the first ...
|
4 |
28.09.2006 13:44:42 |