Search results

SELECT mc.[Household Last Name], mc.[Household First Name], mc.[First Name], mc.[Last Name], mc.[Date of Birth], mc.[Home Phone], mc.[Fax Number], mc.[Cell Phone], mc.Address, mc.City, mc.State, mc.[Zip Code], mc.Email, mc.Youth, mc.Widow, mc.Widower, mc.[Church Member]...

access databases (OFFICE 365) stopped working on computers in the USA how to find out if there have been updates in the last 5-7 days?

SELECT W.ZID, W.ZTEXT_LIST FROM (SELECT tblDTO.[zID], MID(tblDTO.[ztext],1,30) AS ZTEXT_LIST,ZTEXT & "_1" AS ZTEXT_SORT FROM tblDTO UNION ALL SELECT tblDTO.[zID], "~~~" &MID(tblDTO.[ztext],31,30),ZTEXT & "_2" FROM tblDTO WHERE LEN(ZTEXT)>20 UNION ALL SELECT tblDTO.[zID], "~~~"...

slightly corrected, page-width alignment * * and mmm for debugging

I'm not sure that you will be satisfied with such a result , the alignment is left and wide

''add a line to the beginning of the module Option Explicit ''and temporarily comment out the line to see compilation errors . On Error Resume Next

Dim appword As object Dim doc As object

For i = 0 To Forms!frmCouncilgrouplistbox!ContactList.ListCount - 1 If Forms!frmCouncilgrouplistbox!ContactList.Selected(i) Then ''using a variable DogID Call FolderExistsCreate("C:\Dogs\" & DogID & "\Documents", True) '' the variable gets a value - the order of the lines...

Public testarray() msgbox Ubound(HLforInvoice,1) msgbox Ubound(HLforInvoice,2) end sub

s1="INSERT INTO TableContactNotes (ContactID, UserID, [Note]) s1=s1 & " Values(" & Me.ID.Value s1=s1 & ", " & TempVars("CurrentUserID").Value s1=s1 & ", '" & Me.TextNotes & "')" debug.print s1 CurrentDb.Execute s1 and/or there is a quotation mark/apostrophe in the comment text it is possible...

maybe the coupling of these fields is declared in the tables as unique, because the author did not post an example of a comment table and/or there is a quotation mark/apostrophe in the comment text

I would use a subordinate table to the fields - note ID - contact ID - who created the note - date and time - message and a continuous form for viewing/entering.. you can also enter it in the free fields on the contact form with further entry in the notes table

by the way, I tried to find a combination of characters (de) or (ed) - alas, it did not work. selects only (de) and (ed) , and in different fields

I haven 't seen such an approach to the search yet, it's very original, although not very - I don't know how to say how will you search 1 - intervals of dates, amounts 2- in fields with substitutions I would greatly simplify the code Function FrmFilter(param1) As String If Len("" & param1) =...

I would probably apply the form to 2 fields: a checkbox and a text, so as not to think further about what action was performed, and if you add a time field, then track the execution, and maybe time the operator's work I used it often, even before ACCESS

instead of buttons, you can use a continuous (ribbon) form or even a field with a listbox , they are easier to manage by setting up access rights and you do not need to recalculate something

names of tables and fields in English and 4-10 filled lines

lay out an example of the database and a realistic template I will correct my code for your data

SELECT ..... "810-815-820-870-873-874-875-877-890-910") AS S810, "910-...-945") AS S910, Iif(INSTR(S810,FC)>0 AND="Alumni",'450330', Iif(INSTR(S810,FC)>0 AND="REGION",'450530', Iif(INSTR(S810,FC)>0 AND="CLIENT",'450360', Iif(INSTR(S910,FC)>0 AND="Alumni",'450370',"000000") AS PARAM1, .... FROM...

quite a reasonable manager - prepares a specialist in advance who will help master the accounting program in the future - there are too many flaws in them these programs are made for a certain average company, do not take into account the specific product produced and working conditions they...