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...

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...

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.)...

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”...

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...

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...

I’m pretty well versed using Access97 and its Make Table Query function to make NEW tables from an existing Table data in the same database, but I’m having a real problem creating a NEW table using a Make Table Query from another table in Access 2003 database! I drop the fields I want to use in...

I’m pretty well versed using Access97 and its Make Table Query function to make NEW tables from an existing Table data in the same database, but I’m having a real problem creating a NEW table using a Make Table Query from another table in Access 2003 database! I drop the fields I want to use in...

I’m presently using Const XorToggle = 4144959 and it’s too dark according to the end users. Is there a chart showing all the color numbers I can use?

Example sentence: REPLACE ROD BEARINGS I’ve tried this: >C<??????????????????????? and I get this: Replace rod bearings What I need is this: Replace Rod Bearings Can this be accomplished using an input mask in a table? And if so can someone help me in writing it? I've looked everywhere!

Example of sentence: REPLACE ROD BEARINGS I’ve tried this: >C<??????????????????????? and I get this: Replace rod bearings What I need is this: Replace Rod Bearings Can this be accomplished using an input mask in a table? And if so can someone help me in writing it? I've looked everywhere!

Can someone help or guide me in writing a nested (multi) IIF query statement that will return one of the following 3 results (Complete, Expired or Open) answers when its run? I’ve looked in the Access 2003 help files and can’t figure it out. The field names are: F10_IIF_Answer (formatted as...

Can someone help or guide me in writing a nested (multi) IIF query statement that will return one of the following 3 results (Complete, Expired or Open) answers when its run? I’ve looked in the Access 2003 help files and can’t figure it out. The field names are: F10_IIF_Answer (formatted as...

A friend of mine sent be the following code that works with a form only after the user clicks the start button, stops when they click the stop button and resets to 0 when they click the rest button. ............................................. Option Compare Database Option Explicit Dim...

Is it possible to have a forms Caption text blink? And if yes can I also change its color to like RED or something else? I’m running Access 8.0 (Office 97 Pro). Example of Caption text: Me.Caption = _ CurrentUser() & "-" & "Started: " & "" _ & Format$(Now(), "h:nn:ss AMPM...

I have a module that runs an import of data that takes about 30.0 minutes to run. During that time there is a message box open on the users screen running a progress meter showing them the progress and the time they started. After this import has been completed this message box closes and...

I receive a data text file weekly that contains thousands of part numbers with a " – "character between either the 2nd character position (example: 2W-2605) or in the 3rd character position (example: 114-5447 ) that I need to remove before I can use them in my Access 8.0 (Office 97 Pro program)...

I have an MS Access 8.0 (Office97) program that has a form called FO-008 that I need to replace on several users computers in different locations without me being there doing it manually. I’m trying to perform the replacement by using an external MS Access program that contains the replacement...