Search results for query: *

I have successfully created a field that calculates the date seven years after data from another field. My problem now is getting the data that was calculated moved or copied to the proper field in my table. Example. Table "Year Field", "Year + 7 Field" Query "Year Field", "Year + 7 Calculated...

In order to print just the client and all pertaining data for that client I have created a print client data button. Which is... Private Sub cmdPrevRpt_Click() On Error GoTo Err_cmdPrevRpt_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I have a sub-form with a combo box to filter selections that works very well. When I created another form with the need for the exact same filter process I did a cut/paste and adjusted the names to agree to the new form. However, when I run the filter in the new form I get the following...

I have a long list of clients with their Data as a subform. What I am trying to do it to get only the Client with their Data to be the only thing that prints. What I have created in my form is a "Print Preview" button that brings up the Report. The code is... Private Sub cmdPrevRpt_Click()...

My computer has been upgraded to MS Office NT. This of course upgraded the Access Database Program which results in my inability to create hyperlinks quickly. What used to take a maximum of 4 clicks of the mouse now takes 14 - 15 clicks. This is due to a new hyperlink popup window that forces...

In trying to debug why I am unable to get my checkbox to register as true when the condition is met I created the following program Private Sub FileType_AfterUpdate() If IsNull([FileType]) Then MsgBox "File Type Is Null" Else MsgBox "File Type Is " & FileType End If...

I have a form for my clients and a subform for the Data that I am entering for that client. Since I am not entering Data for All the clients I have a Check Box in my form to mark the client as having data in the subform. I was thinking the following program would work... Private Sub...

I am in the process of hyperlinking scanned records to the client database I have. However, I have just found out that the first hyperlinks that I have made no longer work. In going back to hyperlink them they still have the same Drive\Directory\Sub-Directory\Sub-Directory\FileName as before...

I have two fields that I am working with. One field has the same data entered every time. Is there a way to make it record and save the same data automatically? The other field take the last four letters from another field "ExtA:Right(Link,4)", drops the last letter "ExtB:Left([ExtA],3)"and...

What would cause a Parameter Value Error Message to pop up. This happens in 2 of my tables, and the related queries as well as in one form where the sub-form does not show any data. What have I done wrong or need to redo? Thank you for your help RobotMush (Technical User) Self Taught

My Forms are no longer showing any data. It is supposed to show client record and the sub-records of that client, however, on working with my database the form now shows the client record and ALL the sub-records that are in the database. This made me think that I had messed up the linkage so I...

Is it possible to have one query in a one-to-many relationship with two other queries? Or do I need to merge my two child quiries into one? I would like to keep the queries seprate but if it is not possbile then how would I merge the two child queries? Thank you for your help RobotMush...

I have inherited 3 seperate records that have the same clients but different data. Is there a way to fix a hyper link field for a client in the main table to go to or bring up the equivalent client in the other table? Or would something else be easier to do? (Just to note:At this point I am...

I am working on a data base that records the name, addresses and other data for each individual entered. I can enter the data and it does show up the in the queries. However, it does not show up in the form made from those queries. Is there a switch that I need to check to make sure it is set...

I have created a =Recordset.RecordCount as the control source for a text table. It works very well when you click to the next page to show the number of records. However, when the form is first opened it shows the Number of Records as being 1. How can I get the text box to show the correct...

I have a form with a combo box to choose how you want the data to be displayed. I.E. if Certain Last Name is choosent the only those records with the Certain Last Name will be shown. This works very well. However, I am wanting to be able to show how many records there are of the Certain Last...

I have created the usual button for a form "First Record" "Previous Record" "Next Record" "Last Record" "Add Record" and "Delete Record" I have all the buttons but the Delete Record Button working. What I am wanting to do is to Have the current record that is displayed to be deleted,(The form...

I have created a report based on two queries. The tables these queries are based on are joined properly, and the report displays what I am needing. However, when I ask it to filter it does filter by my criteria. However, when I ask it not to filter, it does not revert back to the full report...

I am creating a Database with multiple tables that I have joined via one to many. My problem is that when entering Data I am needing to have the join points record the same data in the joined fields for each record. What I am getting is the following error. "Cannot add record(s; join key of...

I have in the past gotten a drop down list with two fields in it to be able to get the exact record I am wanting. However, in doing a cut past and changing the name to the new database I get a Run Tim Erro '3077': Syntax error (missing operator) in expression. The offending Program is as...