Search results

DELETE FROM tblUnivPort, tblUnivFunc WHERE tblUnivPort.Univ= tblUnivFunc.Univ AND tblUnivFunc.Proc="PORTCHAR";

Not sure if i am wording it right. In a query i have calculated field that is using Date(). Instead of Date() I want to use a value in a table that only has 1 record. How can i reference that table ?

its probably easy I have a report that's based on a query. Changed a query to add an additional srting. Query now looks they way i want to. However report still looks the same like before ! any advise ?

i usually use TransferSpreadsheet does anyone know where i put the tab, if excel has several tabs ? DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes

Hi I have an insert statement on a form sSql = "Insert Into ChangeHistory VALUES ('" & Group_Contact.Value & "', '" & ID.Value & "','" & ctrl.Name & "','" & ctrl.OldValue & "','" & Value & "', '" & User & "','" & Now & "')" CurrentDb.Execute sSql What should for it to accept value...

Hi all I have several databases that use the same code wor exporting query's results to excel template (at the end of the message) For some reason when i try to recycle it once again I get error message Run-time error '-2147467259 (80004005) Method 'CopyFromRecordset' of object 'Range'...

Hi All I've created a database where a query who'se result is loaded on a form uses following function -- DateDiff('d',Date(),[Target Date])-(DateDiff('ww',Date(),[Target Date])*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between Date() and [Target Date]) I've notice that 2...

I see forms have even After Update IS there a way for me to see which field was updated and what was is the new and the old value ?

Is it possible for AutoNumber ID not to skip deleted IDs ? for instance if I deleted item with id # 5, I want the next record to have Id # 5

Hey all I have data in the table. (various IDs - in example below just 1) Each ID has date and status. I need to pull each ID only ones for MAX date If there are 2 like that (with different statuses) i need the one with lowest importance. Any advise ? Status LogID Date ID Date Importance...

when i open DB (using Shift + Enter) I only see FILE, WINDOW, HELP for any Query design - just grid view with FILe, WINDOW, HELP again where are TOOLS and all other choices ? How can i get them back ?

What would be a better way to do below query -- UPDATE (tblAFFIRMATION_REC_TOOL LEFT JOIN tbl_TZero_Spns ON tblAFFIRMATION_REC_TOOL.CptySPN = tbl_TZero_Spns.SPN) INNER JOIN Entity ON tblAFFIRMATION_REC_TOOL.ReferenceEntity = Entity.ReferenceEntity SET tblAFFIRMATION_REC_TOOL.[Scope Reason]...

in one table id is a text, in other its a number. what 's the best solution ? If needed, i can have a query of a table rhere the value is numeric, and convert it to text. something like VAL(ID) but the other way around

Why is this happening ?

Hey All Any suggestions how to do a query with where clause ' wher right 7 charecters are numeric' ?

Hi I am opening excel spreadsheet from access. At some point I populate cetrain cells with words this seems to be working fine c.Offset(, 35).Value = "cusip" Now I would like to put a condition, if that cell is not empty, put it int next cell. What I created below, doesn't work. Any...

does anyone know what's Simplest way to send an email from Access using Lotus Notes (no attachment required)

sorry for OffTopic. does anyone knows if its possible to put more then 3 conditional formatting conditions in Excel ?

ex columns Name Day1 Day2 Day3 Day4 Day5 Day6 Jackie s s Jackie v v Jackie p p I would like to be combined into Jackie s s p v v p all in one row.

hey group How can i have something like this loop to run from ccess application which is already currently opn and where work is done ? With objActiveWkb.Worksheets("Reconciliation Sheet") For ii = 5 To 200 If Range(ii, 9) = "NO" Then Range(ii + 1, 9).Interior.ColorIndex = "yellow"...