Recent content by rvsebi

Sometimes "days" are negative numbers. It is days, just read again.

Hi, i made a form where i calculate difference between dates. .............. Dim tyears As Integer, tmonths As Integer, tdays As Integer tyears = Year(Me!txtdata1) - Year(Me!txtdata2) tmonths = Month(Me!txtdata1) - Month(Me!txtdata2) tdays = Day(Me!txtdata1) - Day(Me!txtdata2) If tmonths < 0...

I think i solved problem much easier then query code :). In Table1 column ModifyDate i put Default Value GETDATE(). Thank you for your time!

Access show me query on SQL view like that. On local client it work very well but i wanted to make it pass-trough. Anyway this is another discussion. Maybe because my bad english i couldnt make u understand what i want. So ... I have 2 tables (Table1 and Table 2) with same columns (a1,a2,a3)...

i already have this query on local, if i go on SQL view query look like this INSERT INTO Table1 (DateModify) SELECT Table2.*, Date() AS Expr1 FROM Table2 WHERE ....; if i modify for pass-trough query your code is enough?

Hi again, can u help me a little bit please. I have problems translate this code INSERT INTO Table1 SELECT Table2.* FROM Table2 into transact-sql because i want to update in the same time last column from Table1 (DateModify) with Date() and i dont know how. Both tabels have same columns...

Done. Thank you very much

:) i just saw the same and edited previous post

Thank you for help. I did like u said and now i get "Run-time error '3146':ODBC--call failed" on .Execute :confused: I think error is here: ''' strModSQL = strSQL & " Where aa.w1 = '" & [Forms]![Form1]![w1] & "'" ''' supose to be strOrigSQL. i will try again with this modify.

Hi, i want to make pass-trough quey in access with value from a textbox. Everything is ok except with part where i want to bring value from textbox. Update aa SET aa.x1 = ac.x1, aa.x2 = ac.x2, aa.x3 = ac.x3 from Table1 as aa INNER JOIN Table2 as ac ON aa.y1 = ac.y1 AND aa.z1 = ac.z1 WHERE...

I made a table with all link table names and solved problem with this : ... Dim x As Integer, y As Integer x = 1 y = DMax("ID", "TTableLink") Do Until x > y Dim rst As Recordset, sqlstmt As String Set dbs = CurrentDb sqlstmt = "Select * from [TTableLink] where [ID] = " & x & "" Set rst =...

Thank you for your time!

Thank you i will use that. I still need to figure out how to make that backup with all tables locals and in the same time keeping front end like it is.

That is manually and i want to do it on event like on open. For example 1. i will make a local table with two columns, BackupDate with datatype Date and Backup with Yes/No where No is default. 2. on open database i will check if that table have BackupDate with today date -if no i gonna add it...

Hi, I want to make a copy of access front end on close with all linked tables converted to local. Any ideea? Thank you in advance!