Search results for query: *

Good Morning, I've been attempting to create a trigger that updates multi rows based upon the date criteria of what was entered into the the inserted table. Even after reviewing other examples on this site of triggers (some used the inserted and deleted tables joined together), I haven't been...

Good morning, I am attempting to filter a form on the open event using the DCount of the underlying query when it matches a certain criteria. I 've created a variable "Days" (integer) in the code that needs to equal a field in the query. I'm adding 1 to "Days" within a loop until a a...

Good morning, I have a stored procedure in Sql Server 2000 that accepts 2 input parameters. It is linked to an Access 97 DB as a pass through query, which is named qryCompanies. I am attempting to call this query from a button on a form where the user will input the parameters in 2 text...

Good morning, I'm attempting to create a 90 day bucket in SQL where it begins on the second day of the month and ends on the first day of the next month. So far I have the following code, which I transferred from Access and then adjusted for SQL Server, WHERE...

Good Morning, I have a subform that is linked to a combo box on the master form. I want to be able to add a new record to the subform before there is a corresponding entry in the linked combo box on the main form. I am receiving an error message when I enter the first character on the subform...

Hi, I'm trying to use dcount to see if the 2 fields combined are unique in a query. The user doesn't like the error message that is returned from SQL Server (Access frontend and SQL Server backend) using the unique index for the 2 fields. Both fields are char (text in Access) in Sql Server...

Hi, Is there a way to have a Money field always contain the decimal and 2 places for the cents? Such as 100.70 instead of 100.7, or 0.00 instead of 0. Might I need to change the data type? Thanks in advance for your help. Sydney

Hi, I'm trying to change the following Access query field Assessed: Sum(IIf([FeeType]="A",[FeeTotal],0))to a field in a SQl View. So far, I have the following sum(case Convert(money,[feeType]) when 'A' Then [FeeTotal] Else '0') End As Assessed but am getting an error by the ' and am not...

Hi, How would I go about exporting a report with a subreport (or 2 different queries) from Access to an Excel Template where all of the Access fields need to go into certain Excel cell fields? Making the template is no problem, but I am at a loss of how to write the exporting code. Thanks in...

Hi, I have a shortcut that is trying to open a database in Access 2000 runtime, but after the user puts in his name and password the database doesn't open, and only the Access program opens (He gets the shell of Access, with the gray background). I believe that I am improperly referencing...

Hi, I have a form and a subform that are linked on the primary key of the main form and foreign key in the subform. When I go into the properties of the form/subform and click on either the link child or master fields to change the linking I get a message saying Can't build a link between...

Hi, I'm trying to see if the count of closed records this month is equal to 0. I have the following code" If DCount("*", "qryMainForm", "Format([completeDate],'mmyyyy')= " & Format(Date(),'mmyyyy') = 0 Then msgbox "blah" exit sub End if But am getting compile error mesage: expected...

The following code changes the recordset of a form Dim strRecordSource as String strRecordSource = "Select * from qryvcqWIPCurrent WHERE StatusCode = " & Forms!frmFilterCriteria!cboStatus If Isnull(strRecordSource) then msgbox "blah" else Me.RecordSource = strRecordSource end if The...

Hi, How do I manually putin the path name to a linked table and not use the path that shows up in the linked table manager. For example, if the table linked manager has the path as X:Examples\Databases How would I change that path to \\Usspamserver\Examples\Databases. Which leads to the...

Hi, I'm using the smalldatetime data type. When I automatically add it to the field, using (getdate()) in the field's default value or inserting it by code, the time also is inserted. However, when the date is inserted manually (in another smalldatetime field) the time is not included. Is...

Hi, I'm using the NoData event On Error GoTo Err_Report_NoData MsgBox "There is no data for this report. Canceling report..." Cancel = -1 Exit_Report_NoData: Exit Sub Err_Report_NoData: MsgBox Err.Description Resume Exit_Report_NoData in my reports, which is working fine. But...

Hi, I'm trying to save a new record, SQL Server table in the backend and Access 97 frontend, by going to the previous record and then back to the present one. That part works, but when I'm on the first record I get the previous record error and the DB crashes. I put in the BOF part in to...

Hi, Happy new year to everybody. I have the following code Set MyDB = CurrentDb Set MyTable = MyDB.OpenRecordset("tblLoanSteps", , dbSeeChanges) MyTable.AddNew MyTable("litigationID") = Forms!frmLitigationEntry!txtLitigationID MyTable("ScheduleDate") =...

Hi, I have the following code in the after update event of a combo box Case "bka" Set MyDB = CurrentDb Set MyTable = MyDB.OpenRecordset("tblLoanSteps") MyTable.AddNew: MyTable("litigationID") = Forms!frmLitigationEntry!txtLitigationID MyTable("ScheduleDate") =...

Hi, I'm trying to add more than one record at a time to a table based upon the Case selected so far I have: Select Case cboLitType Case "bka" Set MyDB = CurrentDb Set MyTable = MyDB.OpenRecordset("tblLoanSteps") MyTable.AddNew: MyTable("litigationID") =...