Search results for query: *

Hi all, I have a form with a list of contact names. I would like to add a button next to each contact name to open another form that contains Only details of the that contact. Name Button John Lerch Button Ali...

Hi all, When I open any of my databases I get the following message: Opening C:\FileName This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or canceal the operation? Canceal Open Does anyone know how to paypass this...

Hi everyone, My boss wants me to go around the office and check our staff pc's for programs/software that should not be there like (firewalls, music file etc..). Anyone have an idea what programs/softwares to look for that my harm the computers? I have no idea where to start. Thanks in advance

Hi Everyone, Does anyone know a program to help me export data from excel to Microsoft Access? The data in excel is not in row/Column format. Thanks in advance dean

Hi, is there a way to map/ export random excel data to an access table? Thanks in advance. dean

Hi All, I have a column Named AttendingProv like this AttendingProv N.S.U.H. @SYOSSET JEWISH UNIVERSITY HOSP N.S.U.H. @GLEN COVE N.S.U.H. @PLAINVIEW DALE UNIV HOSPITAL I would like to convert the column (AttendingProv) to small cap, but I have a delima.. I did the following...

I a table like this: ProvID Type Office 1 Rad-H Office1 1 Rad-A Office2 2 Rad-H Office1 2 Active Office2 3 Active Office1 3 Rad-H Office2 4 Active Office1 4 Active...

Hi All, I took over an existing database. From time to time a message shows up, I close it and I am back to using the database. It's annoying. If anyone knows the answer please help. This the error message that shows up: Compile error: Invalid or unqualified reference And the code that comes...

Hi all, I have the following table: Name ID Office Address Kim 123 Off1 125 Dekalb Kim 123 Off1 17 New York Ave John 234 Off2 12 Cram St John 234 Off3 1 Walter St John 234 off1 4 Broom Ave Paul 345 Off2 2 Bellmore Ave Paul 234 Off2 132...

Hi All, I am trying to run the following (update) pass through Query and I am getting the following error: ODBC-call failed [Microsoft-ODBC SQL Server Driver][SQL Server]line1:incorrect syntax near '('.(#170) The code: UPDATE (([LINK TABLE SUB FORM] INNER JOIN dbo_CLAIM_MASTERS_VS ON [LINK...

Hi All, I have the following table that I would like to export to Excel: Town Name Bellmore John Freeport Paul Bellmore Ismail Merrick Bob Merrick Alan Freeport Mike Merrick...

Hi All, It tried bracket, Parentth...etc nothing works. I get the same error message: Incorrect syntax near the keyword 'THEN'. can anyone help? Here is the complete code: USE MIS SELECT CLAIM_HMASTERS_VS.CLAIMNO, CLAIM_DIAGS_VS.DIAG, CLAIM_DIAGS_VS.DIAGDESC, PROV_MASTERS_HCVW.LASTNAME AS...

Hi, I am getting the following error on this sql code: Server: Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'Like'. Server: Msg 170, Level 15, State 1, Line 6 Line 6: Incorrect syntax near 'CLAIM_HMASTERS_VS'. It works if I don't incluce this line...

Hi, I am new to SQL server programming. the following code works without a problem: USE MIS select PROV_MASTERS_HCVW.PROVID AS [SITE NAME],(PROV_MASTERS_HCVW.LASTNAME +','+ PROV_MASTERS_HCVW.FIRSTNAME)AS FULLNAME, PROV_MASTERS_HCVW.BIRTHDATE, PROV_MASTERS_HCVW.CLASS...

Hi, Does anyone know a Good SQL server book that covers: Programming,backups, restoring, Replication etc... I looked in the internet but it was overwhelming, too many books to choose from. Thanks in advance Dean

Hi everyone, I need help on a condition macro. I am trying to use a Macro (Condition macro) to do the following: If (append query) is null (No Date) then message.... else run (append query) I hope this is clear. thanks in advance.

Hi, I used the following code to make a report go to the last page when it opens: Private Sub Report_Open(Cancel As Integer) Dim I As Integer DoCmd.OpenReport "rptEndOfDayReport", acViewPreview I = Reports!rptEndOfDayReport.Pages SendKeys "{F5}{Delete}" SendKeys I & "{ENTER}" End Sub but I am...

Hi, I need help on the following: I have an input form with a combo box and a text box. I would like the text box to allow only 8 Numbers if combo box is equal to Liberty, if combo box is equal to LNT then allow 11 characters ( these 11 characters will alwyas start with HN Like this...

Hi, Can anyone help me on how to do the following: I have a report grouped by Hospital name (total report 20 Pages). Let say Page 1 for HopitalX, page 2 and 3 for HopspitalY Page 4 for HospitalZ and pages 5 to 20 for HospitalT I would like a query or table to list page numbers based on the...

Hi, I do not know if this is possible since I have never done it before. I have combo box that contains one field (this field contains: MemberId and MemberName like this: 12456898794, John, Smith AB145789658, Karl, Bone TA234587954, Anita, Sullf 54789897897, Paul, Tob What I would like to do...