Search results for query: *

I need some help. I would like to have a “Command Button” placed on an open form that when clicked will apply a filter that will only show underlying records that have a “Null” value in the [CompDate] field. Then when it is clicked, again it will remove the filter showing all the records in...

GingerR, I was reading your response to mrbboy today that wants to place a command button on the subform so that when it's clicked, all the fields on the subform are locked. You replied Yes, you can loop thru all controls and set their LOCKED property to TRUE.. I have a similar need, but...

CaptianD: I’m using a very simple program login password code for all administrators assigned to handle Technical Assistance Requests to keep things simple (View code below), and for filtering/viewing request records later if necessary. Option Compare Database Option Explicit Sub NoEntry()...

To: TheAceMan1, CaptianD & MajP: I think MajP is the closest to what I trying to accomplish. Let me try to simplify what I’m asking help on again since maybe I didn’t do such a good job and I’m confusing you all: This is a Technical Assistance Request database program. All its users are...

TheAceMan1 First thanks for your quick response. I’ve not had a chance to try what you suggested yet, but I will this week when I get home from work. Can you look at my response to CaptianD today and let me know if what you suggested will work ok from what I responded to him. At this point...

CaptianD First thanks for your quick response. To answer some of your questions: 1. You need to provide more information on what you have and what you have tried. I have not tried anything yet since I just don’t know where to start. 2. What I get from your post I assume you have a form...

How can I disallow/allow editing of fields in a “single” record of a many records database? Situation: I’ve designed a database in MS Access 2003 that has many records, and each individual record “number” has many data entry fields. I want to be able to“disable (not allow)” users from...

Thanks MVP & Dhookom, your suggestions worked!

Is there an Input Mask that I can use in my Table that will capitalize the first letter of each word in a company name or persons name with-out the user having to do this them selves during data entry (e.g., The Work Company Inc., Mc Gregory Inc. Michael Eisner, Tom Mc Crackle, etc.)...

Duane: Thank you for the quick response! You’re correct, the code did work after I tried it again and found out that my test table did not contain data and that seams to be why the code did not return the expected response. After I added some data it working just fine! The SQL view(s) I...

I’ve installed a Module below and named it fOSCompName that PHV (MIS) suggested and it works just fine by calling it from within my Query Field with GPCN: GetPCName(). Public Function getPCname() As String getPCname = Environ("ComputerName") End Function I’ve also installed 2 other Modules...

Is there a way to capture the users computer name when they are adding a record to a shared split database with a query so I can save it in a table record? I’m using MS Access 2003.

I have a split MS Access 2003 database (front-end & back-end) program that work just fine with mutable users adding or up-dating record information that has the record locking turned on. Users have complained to me that the only way they know another employee is updating the same record is when...

I have database program that has several “Tables” that have Referential Integrity relationships invoked to maintain data integrity. This data then populates the program “Form” fields via a “Combo Boxes”. The user selects the data they want to populate the field with from one of the “Combo Box”...

Remou: Thanks what you suggested worked!

I’m working on an MS Access2003 database form where I have a “TEXT” filed named “CatCPIReqNos”. This field can contain data or not depending on the users input. I have another field “unbound" named "Text391" that I have the following IIF statement (1) in that returns its IIF statement if field...

Bob Stubbs & Michael Red Thanks for your help on my printing question. I’ve tried all the recommendations and the end users are pleased!

DHOOKOM I found and solved the problem! I went to the following menu: <Tools> <Options> <Tables/Queries> and unchecked the OutPut All Fields box in the Query Design area. Thanks for your help anaway!

DHOOKOM I found and solved the problem! I went to the following menu: <Tools> <Options> <Tables/Queries> and unchecked the OutPut All Fields box in the Query Design area. Thanks for your help anaway!

I’ve just converted a number of Access97 databases to Access2003 databases and a strange thing happed when I try to us filter-by-form function in a SubForm (that is not linked to their main forms, there independent of each other). When I apply the toggle filter command or the apply filter/sort...