|
| How to determine the latest record on a form |
Hi all,
I have a form with some custom navigation buttons like goto next
record, previous record, most current record, etc. There is also a
button which creates a new record. Pressing this button adds a new
record and fills some textboxes on the form with data.
Here's the problem:
Users should use this "New record" button to add a new record, and not
the "Next record" button which renders a blank, new record where their
is no data in the textboxes. Is there any way to dis ...
|
| Read Entire Conversation |
|
| nesecito restablecer mi pc no lee los archivos ni programas que h |
nesecito restablecer mi pc no lee los archivos ni programas que h
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx? ...
|
| Read Entire Conversation |
|
| Data loss problem on custom ActiveX focus |
Hi,
I am wondering if anyone can help me, I have a custom ActiveX editing
control I wrote on a Access form, and all appears to be working fine,
however I have just noticed that if I edit text in one of the textbox
controls on the form and click on the ActiveX control, any changes made in
that textbox are canceled, if I click on another textbox first or the form's
background the data is not lost.
Does anyone know what might be causing this and how I might sort it so that
t ...
|
| Read Entire Conversation |
|
| Bookmarks in word |
Can anyone tell me how I can not get an error using bookmarks in a word
document if the field has no data
TIA
Les
|
| Read Entire Conversation |
|
| How prevent Advanced Filter Sort from self-clearing on Form? |
Hi,
I use many forms in Access 2000, and in many cases apply filters.
Dozens, perhaps hundreds of them work just fine, but in a few forms,
the filter criteria is cleared after each use. This never happens in
the other forms. The problem forms have two subforms.
That is, I enter the filter criteria as below*, apply the filter, save
the form, close the form, come back to the form later, and the filter
criteria is cleared.
I must reenter the filter field and criteria again t ...
|
| Read Entire Conversation |
|
| Format Italics |
Is there any way to use the format function to put something in italics? For
example, Format("abcd", ">") will return "ABCD". Is there a character to
insert instead of ">" that will return italics?
If not, I'm using a SendObject command to open an email, and the pre-defined
body of the message has a disclaimer at the end, which I would like to put
into italics. Is there any way to do that?
Thanks in advance
|
| Read Entire Conversation |
|
| screen update freezes |
Hi all,
In our application there are many processes that take more than 5 seconds to
complete (eg imports and exports). In these cases we present users with
status screens like showing text what is going on or a progressbar.
After 5-10 seconds these screens freeze while the program is still doing
it's work and sets the properties for the status screens (or at least it
tries to do that). When the process finishes the screen is at last updated
to the last status text action, b ...
|
| Read Entire Conversation |
|
| Ink in Access Forms |
Where can I find an example of using as ActiveX Ink control in a form to
capture handwriting and save it in a table as an image? I would like to
capture a signature, possibly in an Ink Picture control, and save it for
viewing in a form and report.
Thanks.
|
| Read Entire Conversation |
|
| check for duplicates upon cmd button click |
Typically this would be easy for me to do, but i have a situation that
is a bit confusing and would require some help:
I have a form that allows a user to enter data (document information
such as file name, unique file code, created by, etc) to be added to an
existing table. The purpose of this form is to enter info for a NEW
document (i.e. a new file code that doesnt' exist in the current db).
I also have a feature that stores versions of the same file (and thus,
repeated f ...
|
| Read Entire Conversation |
|
| Entering info in an object frame |
I have 3 fields that I would like my dispatcher to work with. EquipNum,
Description, and location (we have heavy equip that is being moved around all
the time which we are trying to track) all in a table called Master Equip
List. I would like to develope a form with three object frames (I believe
these are bound) that would allow the dispatcher to enter the equip number
and have the discription and current location automatically come up. The idea
would be once this info comes u ...
|
| Read Entire Conversation |
|
| Subforms |
Hi,
I'm hoping someone can shed some light on a particular problem I'm having
with a form. I have a database that has been functioning well for quite a
while. Now I need to use the same database and rearrange some aspects as to
how it works. Currently, there is a main form with company info, a subform
with quote heading info, and a subform in datasheet view that lists and
calculates all parts to be quoted. No problem - a list of parts with one
quoted amount.
Now I nee ...
|
| Read Entire Conversation |
|
| SQLRun - Silent update of field in another table? How? |
I have the following code in an after_update event and it works fine.
strSQL = "UPDATE PONumbers " & _
"SET PONumbers.Used = True " & _
"WHERE PONumbers.PONumber = " & Me.PRPONumber
If Not IsNull(Me.PRPONumber) Then
DoCmd.RunSQL strSQL
End If
However, when the Docmd command runs, the user is prompted with a Yes/no
MsgBox to update the table. Is there a way I can do this silently so the
user insn't prompted?
Thanks
|
| Read Entire Conversation |
|
| Hyperlinks in a ListBox control from SharePoint |
This should be simple but so far I can't find the trick. I have a
sharepoint document library that is linked to Access 2003 database. I
would like to populate a listbox or combo box with the names of the
documents as they are hyperlinks. This all works, very simple. The
problem is that the listbox seems to strip the hyperlink property to
where I can't follow the hyperlink when I click. If I do the exact
same query I get the list I want and it will follow the hyperlinks. I ...
|
| Read Entire Conversation |
|
| Search Box in form gives error |
Hello,
I am an Access beginner trying to create a form to search a database.
Users enter the client's last name, and then a second form called
"Contacts" will open with their information. I got that working easily
enough with the wizard, but I would like the users to be able to enter
just the first part of a client's name, instead of having to match it
exactly.
This is what I have so far, based on other posts to this forum.
stDocName = "Contacts"
stLinkCriteria = "[La ...
|
| Read Entire Conversation |
|
| Create a search-by-typing list |
Using Access 2003.
I have a subform consisting of an alphabetized list of names . I would like
to "search-by-typing" in the list. For example, to find "Cebula", I would
start typing "c-e-b-u-l-a" and it would move down the list, to that name. Can
this be done in Access? Thanks.
|
| Read Entire Conversation |
|
| Control Validation |
What is the best expression to use in the Validate property for a control to
test that some text (of unconstrained length) has been entered.
|
| Read Entire Conversation |
|
| Is it possible to add, remove, and rename a column. |
Is it possible to add, remove, and rename a column in a Table using a Form,
if yes them how?
For example, there is a Table by name tblSales, which carries Field1, Field2
and Filed 3, can there be a user Form which takes the input from user and
creates another column in table tblSales.
Thanks.
|
| Read Entire Conversation |
|
| Same Form Different Query |
I would like to take the Form I already have created that writes data to a
table based on a query copy the form and change a property in it so that now
I can use a different query with it. Now I end up with two forms to place in
my switchboard.
How do I change the property in the form copied to point to the second query?
Thanks... Joe...
|
| Read Entire Conversation |
|
| Save Records to different table |
Hi
I have this database, i am goign to make it as simple as i can.
I have created two tables( table 1, table 2) then query then two forms(
from1, form2), so when some one fill form (form1) he does not fill the whole
the form he just fill few feilds then press send but what i want to happen is
when he press send the record will move to different table which is table 2,
I have made another form which base on (table2) that have combo box that will
be list all the records had b ...
|
| Read Entire Conversation |
|
| Conditional entry in a form |
I have a yes/no tick box and a data entry field on a form next to each other
(aswell as other entry fields)
When the box yes/no box is ticked ie yes then I want the other entry field
to go a different colour, data not be allowed to be entered into and maybe if
posible skip that field in the tab order
how do I do this? The first 2 bits are the most critical
|
| Read Entire Conversation |
|
| hide empty fields in a report |
I just started using access two weeks ago and have created a dbase for my
travel agency.
Some bookings have 20 passengers some only have 1. I have 20 fields (for
passengers) in my table, but not all of them are filled for every booking.
How can I run a report that shows only the records that have passenger data
in them?
Really appreciate any advice.
P.S. Allen Browne...You rock! Thanks for add calendar button on your
website...Would have taken me another 12 months to figure that one out!
|
| Read Entire Conversation |
|
| Cannot modify existing Access forms, no error prompted |
WE are unable to modify existing access forms and save them. Though there is
no eorror prompted, but when we try and close the form, it prompts the usual
window asking if we want to save. We click "Yes", but it doesnt save, untill
we say "No" to save.
We are able to create new forms, but the problem is we cannot "Save as" as
well the existing form.
Any help will be greatly appreciated.
Thanks
|
| Read Entire Conversation |
|
| Identify or add a field to a remote table |
I have a FE/BE database setup. The front end could link to many different
backend databases with similar strutctures. The applications have been
deployed to customers and I continue to modify the front end. On occassion
I need to add fields to the backend files that they maintain.
At the main switchboard form, on open, I would like to verify that a field
(as an example: txtName) exists in the linked backend table. If it doesn't
exist, I would like the code to automatically a ...
|
| Read Entire Conversation |
|
| Combo Box Limit to List Problem |
Hi,
I am having trouble with a Combo Box that displays records on screen for
whatever value the user enters. I have to have the Limit to List property set
to Yes as the Bound Column (ID) is not visible on the drop down list.
We are using Touch Screens so when the user tabs onto the combo box, they
start typing their required serial number and if they see it they hit
enter.(record displays)
If they enter a serial number that is not on the list and hit enter, an
error appea ...
|
| Read Entire Conversation |
|
| how do I set a timestamp but I don't want it to update? |
i want to create a yes/no field for people to click on yes when they
check-in. I also want to create a field the shows the date and time they
checked in but I don't want the time to update. I want to be able to see
exactly what time they checked (even if I open the file up 3 days later I
don't want that time to update). Please help
|
| Read Entire Conversation |
|