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