Search results for query: *

Hello, I have a simple If statement for the Details On Format. Please see example below: If Me.SegmentID>1 Then Me.Description.Visible=False Else Me.Description.Visible=True End If It worked just fine, until I added RecordCount field for additional validation. Now, the If statement always...

I am trying to execute the following code: Set rstQt = dbs.OpenRecordset("SELECT tmpWeeklyLF.State, tmpWeeklyLF.Year, tmpWeeklyLF.DP1, tmpWeeklyLF.Est1, tmpWeeklyLF.DP2, tmpWeeklyLF.Est2, tmpWeeklyLF.DP3, tmpWeeklyLF.Est3, tmpWeeklyLF.DP4, tmpWeeklyLF.Est4, tmpWeeklyLF.DP5, tmpWeeklyLF.Est5...

Hello, I need to get a Date for each Monday in the year. I have 2 variables Year and Week, so at the end what each record should have is: 2008 1 Jan-7 2008 2 Jan-14 Thank you.

Hello, I have a form that I am trying to set RecordSource based on a partial date selected from a table. I am using the following code to find records in the table: Set rst = dbs.OpenRecordset("SELECT tblStrawmanQ.StrawID, tblStrawmanQ.State, “ _ & “tblStrawmanQ.Media, tblStrawmanQ.DropDate...

Hello, I am using Access 2003 and I am not sure which library is missing, but when I create a basic select qry and use "Left" function, I get the following error "Undefined function 'Left' in expression. Right and Mid functions work just fine. Thank you.

Hello, I have two subreports that are formatted into columns, as soon as I put subreports on the primary report, columns jump all over the place. Does anyone know how to keep subreport column formatting on the main report in Access 2003. Thank you.

Hello, I cannot find an error in my code: If ctl.ItemsSelected.Count > 0 Then For Each varItm In ctl.ItemsSelected If lstn = "" Then lstn = Me.lstAcct.Column(2) & ";" Else lstn = lstn & ctl.Column(2) & ";" End If...

Hi, I have a simple code to open Excel Workbook: Private Sub cmdDataClean_Click() Dim dbs As Database Set dbs = CurrentDb Dim xlExcel As Object Set xlExcel = CreateObject("Excel.Application") Dim fnstr As String fnstr = "C:\" & Me.txtFileName xlExcel.Workbooks.Open (fnstr) End Sub The...

Hello, I am using ActiveX Calendar Control, it works fine first day. After that, every time I try to select a date, I get the attached error.

Hello, I used Access 97 for years, but now I have to switch to Access 2003. I am trying to delete any table that has the word "Error" in it's name. I was trying a very simple command: DoCmd.DeleteObject acTable, "*Errors*" However, Access 2003 doesn't see "*" as any character. I also tested %...

Hello, I cannot figure out the issue with my query: TRANSFORM Sum(tblProduction.ProdNbr) AS [The Value] SELECT tblProduction.Task, tblProduction.UserID, Sum(tblProduction.ProdNbr) AS Total FROM tblProduction WHERE (((tblProduction.PDate) Between [Forms]![frmReports]![txtFrom] And...

Hello, I have a database to record outputs of testing results, everything works fine, however when I copy and paste even one screen print into image box moving between records takes at least a minute. Any advice? Thank you.

Hello all, I am trying to automate a notification process to the manager that a record has been updated and ready for review. My problem is that the company is using Web Based email and Outlook or Outlook Express will not be configured on any of the workstations. Is there any other way to send...

Hello, I hope that someone can help me. I am faxing a batch of letters (Word 97 mail-merge document with recordset in Access 97); I am using Win 2000. I have found a file "w4ua0001.exe" on the Internet before and it helped me to fax the first batch. On the second batch, I got an error...

Hello, I wonder if I could get some help. I am faxing a word document using Procomm Plus. The problem is that I am sending a bath of faxes, the word document is a mail merge (gets data from an access table). I had no problem with a first file, but now I am getting an error: "ASPtime.dll...

Hi, I am importing a text file into Access 97 using TransferText. Everything works fine, but it only wants to import data into a single field. I think, the problem comes from the delimiter used: ~ . Does anyone knows how to identify the delimiter in the code and not a manual import? Thank you...

Hello, I have a problem sending faxes from MS Word 97 on Win NT (using Procomm Plus Fax Manager). I need to fax a Mail Merged document, each page should go to the fax merged into "FaxNumber" field. Thank you, lbigk

I need to cancel Open Report and Restore minimized form, if no data is available for the report. For some reason Docmd.CancelEvent doesn't want to be recognized and if I use Exit Sub, the code runs two times and still displays the report. Any advice? Thank you.