Search results

Hopefully I can explain this correctly.... I have a form that shows a current record. When a check box is clicked to true it marks the current record as a historical record, opens another form (acFormAdd) and the user adds a new record. On the second forms close event, I tried a few options to...

Hi all, I'm trying to pull a query/view from an employee table with all active employees and employees who have terminated within the past 30 days. I've tried entering in the TermDate criteria field 'is null' or 'date() - 30'. I'm also posting this message on the SQL message board since I am...

Can anyone tell me how to determine the state of Lotus Notes. In my Access database, I have a button to generate Lotus Notes e-mail. When the user clicks the button, I would like to determine if the Lotus Notes application is open (and not timed out due to security settings) and if not...

It's been a while since I've posted to the board and I'm happy to be back. I always know where to go when I'm stuck! My problem is common ... how can tables be locked down or hidden? I've searched the board on the subject and there have been many suggestions (Tools, Start-up and etc.) but I...

On June 24 I posted a request and Colin Essex replied to my post by suggesting a way to add an entry to a combo box if not already in the source table. I really like the simplicity of this method, however, I'm getting a run time error that I can't figure out how to fix. Here is my code...

I need to generate a file number which will consist of the date, formatted as yymmdd and a running number of records for the date, for example, 02062501, 02062502, etc. I tried using: Count(DLookup(field, "qry", Date())), on the form's before insert event, but it didn't work. Any ideas...

Can someone tell me how a form referenced that is not the form that has the focus? I have a form (first form) with a combo box object where the user selects data to enter from the selection list. The double-click event of the combo box object on the form opens another form (second form)...

I have a form on which I added a button to delete a record by running a delete query. Instead of the pre-defined message boxes (you are about to run a query... and you are about to delete 1 record...) I would like to supress those messages and show a message only if deleting the record violates...

I'm trying to count the number of words and lines in a text box but I'm having no luck. Any ideas? Thanks!

Hello...once again I find myself turning to my favorite web site for access help. This is probably simple, but taking me way too much time to figure out. I have a table that has a name field that includes the entire name (lname, fname, mi). The table I want to import this data into has a...

I'm working on an inventory list that seems to have duplicate values in the SNs because a dash (-) was entered in the string on some records, not on others. What function do I use to remove the dash in a query to view duplicates? Most records in question are in the format of 00-0000, but some...

I'm not sure if this is an appropriate title for this request, but I have a table with a text field ([ID]) as the primary key in which I'm storing a number code. The code is 4 spaces and begins with a letter and three digits following the letter (D004, for example). On a form, I would like to...

I'm also posting this in the Forms forum, so please don't waste your time reading it twice! I have a form to enter employee information using a Tab Control with two tabs. The first tab includes the employee's personal information, the second tab includes the employee's work location...

I'm also posting this in the VBA forum, so please don't waste your time reading it twice! I have a form to enter employee information using a Tab Control with two tabs. The first tab includes the employee's personal information, the second tab includes the employee's work location information...

Hopefully this is not too trivial to post on this board, but it's making me crazy! I have a termination date field in my table and and a field on a form that is visible only if the employee is terminated (date filled in). My expression is as follows: If Me![TermDate] <> Null Then...

If I have a text field that holds 5 numbers (12345) is there a function in Access 97 or a way to reverse the order of the data (54321)? Thanks!

Hi again, still having problems...I'm not even sure how to describe this one. I have a form with a subform, in which the subform is longer than the screen. The subform default view is "single form". As the user tabs through the subform, it will not move up when it reaches the end, the user...

I have a form where the user enters a preassigned number. I want VBA to automatically assign a value to the primary key field that consists of the number entered by the user + 20 at the end. Example: user enters 12345 in txtNum field, VBA assigns 1234520 in txtNumID field. I have written the...

I'm working on a project in which I have to import a text file into a table. I'm importing the text using the following code in the button's on click event: DoCmd.TransferText acImportDelim, "TEXT", "tblExisting", "c:\textfile.txt", True, "" This appends the records to the table. My question...