Search results for query: *

Hello, I needed to update some calculations in an legacy program; I did my updates in one procedure, but when trying to compile the code, another procedure (see code below) gave an error message saying 'Method or data member not found' for 'ListItem' in this part 'lstSELINV.ListItems.Count'...

Hello, I had installed multiple versions of MS Access (2000 and 2003) on my computer. After uninstalling 2000 version I am getting 'Error # 13' when trying to open any MS Access report from my VB6 program. Here is the code (show report): Private Sub Command19_Click() Dim rst As...

Hello, I have troubles to run/convert MS Access database 2000 in 2003 version; after opening in 2003 I am getting error massage "Visual Basic module contains a syntax error" I tried to fix some lines with errors like these: - Dim db As Database, td As TableDef, rs As Recordset (replaced with...

Hello, I tried to follow these instructions (see below) in order to backup SQL Express 2017 automatically in three steps (A - stored procedure, B - bat file, C - scheduled task) using T-SQL. Link The first step (Step A) went OK. The next step, B, is failing if run as .bat (sqlcmd -U...

Hello, I have a VB6 program which used to be run on XP and it still works there without any issues. It basically reads Excel data, writes them to MS Access and saves MS Access data into TXT file. We are moving from XP to Windows 10 and trouble started now - it starts OK, can connect to MS...

Hello, We are using a Delphi/Borland program which uses a database on SQL Express 2017 server and it works without any issues. We tried to move it to another computer so we installed the program, SQL Express 2017 and move (export/import) the database to the new computer. The program starts...

Hello, I have this query: SELECT [TIME_T].[TIME_F_EMP_NUM] AS EMP_ID, [TIME_T].[TIME_F_DIV_NUM] AS DIVISION, [EE_T].[EE_F_SUR] AS LAST_NAME, [EE_T].[EE_F_FIRST] AS FIRST_NAME, Sum([TIME_T].[TIME_F_AMOUNT]) AS EARNED, Sum([TIME_T].[TIME_F_AMOUNT])*0.04 AS VACPAY FROM TIME_T, EE_T WHERE...

Hi, I have two queries: VAC_TIME_BY_YEAR (calculates earned vacation pay) SELECT dbo_TIME_T.TIME_F_EMP_NUM AS EMP_ID, dbo_TIME_T.TIME_F_DIV_NUM AS DIVISION, dbo_EE_T.EE_F_SUR AS LAST_NAME, dbo_EE_T.EE_F_FIRST AS FIRST_NAME, Sum(dbo_TIME_T.TIME_F_AMOUNT) AS EARNED...

Hi, I am trying to check if a value (date) is in a array; this is my code: Dim SVIATKY() As Date Dim STD As Date Dim K, KLK As Integer 'adding value into array sSQL = "Select [SH] From [STATS];" Set rst4 = New ADODB.Recordset rst4.Open sSQL, objAccessConnection, adOpenKeyset...

Hello, Is there any way to modify this select query so it would be able to edit data? All three tables ([NAMES], [WHOURS], [PAYPER]) used in this query has a primary key defined. SELECT NAMES.FULL_NAME, WHOURS.WDATE, WHOURS.WTYPE, WHOURS.WHRS, WHOURS.PCODE, WHOURS.WRATE, WHOURS.HIP FROM...

Hello, I am adding one procedure populating a Datagrid into existing project; hereis the new, added code giving me an error message as above. Private Sub Command14_Click() Dim rst4 As ADODB.Recordset Dim sSQL4 As String If Combo1.Text = "Select Pay Period" Then MsgBox...

Hello, I am using this code: Write #TextFile, "D", " " & .Fields(2), " ", "ARCL", REF, MDT, .Fields(3), .Fields(4) which gives me the following output: "D"," 105"," ","ARCL","18/11/10","181110","FIRSTDATA DEPOSIT","2400.5" "D"," 315","...

Hello, I have this query: SELECT DISTINCTROW TIME.RCD_NUM, TIME.EMP_ID, TIME.PPERIOD, TIME.PRUN, TIME.TDATE, TIME.PC, TIME.RATE, TIME.HOURS, TIME.AMOUNT, TIME.JOB_ID, TIME.UPDATED, TIME.UPDATED_BY, TIME.LOG_DATE, TIME.ORIGINAL_REC_NUM FROM [TIME] WHERE (((TIME.EMP_ID)=376) AND...

I have this code: If (((STD - FD) >= 30) And D15 >= 15) Then 'EMPLOYED MORE THAN 30 DAYS, GETS EXTRA DAY If JOBID = 20 Then 'STAT HOLIDAY FOR COOKS/KITCHEN STAFF DR = 1 WTYPE = "S/T"...

Hi, I have a rounding problem problem with my report I tried a plain SUM function, Int((Sum([total])+0.005)*100)/100, Round(Sum([total]),2) but still not getting a proper result in some cases (like 3630.63+419.18+524.37+798.71 showes as 5372.88 instead of 5372.89) The input data are from an...

Hello, Does anybody have any knowledge or experience converting VB6 to Java using https://jump2java.com/ or similar product/service? Thank you.

Hi, We are still running Accpac Plus and no planning to upgrade for a while. We have custom made invoicing system (MS Access/Visual Basic) and manually entering printed invoices into Accpac AR like: - type 'Invoice' - customer no - document no (invoice no) - date - reference (invoice no) -...