Search results

I have posted the same question in an other forum also because of its "emergency".. I am using below code in my new Access 2007 db. Backend on a SQL. Exactly same code runs in my previous DB with the same backend. However, the wildcard search is not executed correctly in the new DB..but works...

Hi, i am using the below sending an email strBody = DLookup("PB_TEMPLATE_BODY", "PB_TEMPLATES", "ID_TEMPLATE=" & Me.ID_TEMPLATE) .HTMLBody = Replace(strBody, "<<InsertName>>", Me.txtFIRSTNAME) How do i insert multiple replace conditions? I need to insert at elast 10 more Thanks!

Hi all again, (i use Access 2007) how do i reference a gif image stored on my Cdrive image folder to be inserted in below code i use for my email template. The image is the Header of the email body.I use the exchange method. Dim strEmail, strBody As String Dim objOutlook As...

Hi all..i am trying to find a workable sollution to this for a very long time byt without success... My application is distributed to 15 users and i want the users to be able to email records directly from Access. My idea is that a set of queries will populate a “e-mail”-form and from there...

HI all, Not sure how this procedure is called in english, however, i will try my best to explain.. Field A: Text field that contains email addresses Example: a.a@google.com I want to update field B (text) with everything after the @ symbol in Field A, i.e google.com..how do i...

Hi all, I am using the below code to export the query result to excel. Private Sub Excelexport_Click() DoCmd.OutputTo acQuery, "AmountReportQuery", "MicrosoftExcel(*.xls)", "c:\MyReports\Amountreport.xls", True, "" The query includes two fields. “Amount” (Column A in the spreadsheet) and...

Hi I am trying to figure this out Form A. Button A. Text field A. Memo field A. (Plain text format) Text in Memo field A. “Hi all, we have just spotted locomotive <>..." By clicking on Button A i want to replace “<>” with the text in the text field A. Also..does anyone have any...

Hi all, sorry for bothering again.. I recieve a syntax error "sometimes" :) when i save the form that holds this filter )while developing) Private Sub Command80_Click() Me.Filter = "[Assigned] like '*" & "EU" & "*'" Me.FilterOn = True End Sub Why?..also..will this sub function once i...

Hi all, I am encountering this issue when wanting to save edits...this is the setup Unbounded Form A including two forms and one text-relay control. Bounded sub form “records due today”. Source Query Today. Related tables 1 and 2. The query includes date criteria. Data displayed in continuous...

Hi all, i would appriciate some advice in the following issue. Split Form A is based on a query. back end on SQL. I choose to make the split form editable..the user can edit in the "single form" part. There is code running in the "on current" event of the form in order to synchronise a...

Hi again, i am using below code to open a form with related record. However, the form opens but prompts for a new record.. why is it that? Access 2007 frontend / SQL 2008 backend. ID is the primary key Fruits is the form i want to open Dim stDocName As String Dim stLinkCriteria As String...

Hi all, I am using a popup form for entering new records. On the forms “on Load “ event I use the following code, DoCmd.GoToRecord , , acNewRec..but once the forms is open all controls are populated with “#Deleted”. Front end Access 2007, backend SQL 2008. Do i really need to create a command...

Hi all, Table 1 and 2 are related, primary keys are set and defined. However, when a create a form based on Table 1 and include a subform based on table 2, the subform is not visible..and i cannot create any record to this. Front end Access 2007, backend MS SQL 2008.. What am i doing wrong...

Hi All, I have an issue with GoTorecord,,,New, on a forms onload event.. Form A. Control 1 (Primary Key). Table 1. On the click event of command button “create new record” i open Form B, table 2 Table 1 and Table 2 have RI Control1/Table1 – Control/Table2 Form A remains open and visible...

Hi all, In a query i am referring to form A, were two unbounded controls represent first and last date Controls DateStart and DateEnd The criteria in the query field "Date" is Between [First Date] and [Last Date] How do i refer to control “DateStart”/[First Date] and “DateEnd”/[Last Date] in...

Hi, I have an aggregated query (query / query) in Access and when i run it with my tables Linked to an SQL it does not function. This is the string SELECT XcodeCaseQuery1.XID, XcodeCaseQuery1.Category, Sum(XcodeCaseQuery1.StatusOpen) AS SumOfStatusOpen, Sum(XcodeCaseQuery1.StatusReview) AS...

Hi all, I use an unbound textbox in my application menu to search the content of some forms on the “click event” of a dedicated button. I use the below code, the continuous form opens but displays no results....also..how do i centre the text in the textbox? I do not use this code in the forms...

Hi Table Signatures. Field names “Username” and “Signature” “Username” holds the system username (fOSUserName) “Signature” holds the alias related to the username Example: “Username” bertlarsson = “Signature” Bert How do i write the DLookUp function to match the current fOSUserName() with the...

Hi, How do i display the SQL login name in my Access 2007 front end.? Is there a function i can use as the control source for a text box? Thanks!

I use many tables as Row Source / type for Combo boxes. All these tables consists of an unique identifier (ID) and two additional fields of Text Type. What is to be considered the best practise, bounding column 1 when inserting a new record (a numeric value) and when displaying / editing...