Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mikeba1
  • Content: Threads
  • Order by date
  1. mikeba1

    calendar control and after update event

    HI guys ver 2010 I have a form with a date field with the calendar control. The after update event simply uses msg to show the value in the date field. If I select a date from the calendar the msg shows nothing , although the field on the form is correct If I enter the date everything works...
  2. mikeba1

    days in the week

    Does anyone have a routine to calculate the number of Thursdays(or any other day) between two dates. thanks
  3. mikeba1

    update query

    update problem access 10 running as 2007 mdb attached sql view of update query UPDATE DiveRecords SET DiveRecords.Patient1Name = [Forms]![updatechangesdives]![nametouse] WHERE (((DiveRecords.Patient1Name)=[Forms]![updatechangesdives]![orgname])); I am trying to change the field I am...
  4. mikeba1

    simple query

    I am trying to create a simple select query with data on a form, all ok apart from a date field which is on the form but does not display on the query ??? beaten !!! SELECT [Forms]![frmCreateDayApptsSTARTA]![Therapist] AS Expr1, [Forms]![frmCreateDayApptsSTARTA]![dayinweek] AS Expr3...
  5. mikeba1

    drop down list

    Hi people I am new to php, attempting to take an access db to the web ??? I seem to be unable to create a drop down list that has two columns 'membershipid,surname'. The first column is what I need to pass to the next procedure. I apologise if I am being stupid but I don't seem to find any...
    • mikeba1
    • Thread
    • Replies: 4
    • Forum: PHP
  6. mikeba1

    blanks in field names

    possibly moving access to sql and php first attempt to list table with blanks in field names ok on select but what about the echo !! <html> <head><title>MySQL Table List</title></head><body> <?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "members"; // Create...
    • mikeba1
    • Thread
    • Replies: 2
    • Forum: PHP
  7. mikeba1

    dlookup

    I am pulling my hair out !! The following code gives error 2001 cancelled previous operation 'MsgBox ("email therapist booking") Dim therem therem = DLookup("[E-mail]", "[therapists]", "therapist= " & Forms![zoom]!ther) If therem > "" Then ' Call emailaddtherapist(therem, noteb, notea) End If...
  8. mikeba1

    transfer database acimport

    I am trying to transfer (copy) a table from one mdb to the current db. Here is the code DoCmd.TransferDatabase acImport, "Microsoft Access", "c:\newmembers\centremembersdata.mdb", acTable, "members", "copymembers" no errors no transfer!!!! any ideas thanks
  9. mikeba1

    query error&gt;?

    I have developed a small access database in 2003. Runs fine in that environment. Moved it to a 2007/2010 environment and get the following error when running a report. query1.patient (enter parameter value) there is no query1 any ideas? thanks in advance
  10. mikeba1

    dlookup

    Having a problem with above. I am developing a diary system that arranges appointments. I need to identify if a particular set of dates have a bank holiday within them. I tried the attached code but it works fine on the second date which is a bank holiday, but fails on the next date which is...
  11. mikeba1

    Run time error 3464

    I'm going crazy. The following gives me the error Dim bh As Date bh = DLookup("[bhdate]", "bankholidays", "[bhdate] = '" & [NextDateFrom] & "' ") info table bankholidays bhdate Date/Time (key) bhname Text [NextDateFrom] is a date field on the current form
  12. mikeba1

    uk bank holidays

    I am writing an application that involves the calendar. Does anyone have, or know where to get the uk bank holidays for say the next 10 years. Thanks in advance
  13. mikeba1

    odd query error

    I get the following message 'Cannot ope database 'query6'. It may not be a database that your application recognizes or it may be corrupt The query is an update query and one of the columns updates to date(), if i remove this update it works. Thanks
  14. mikeba1

    zoom box

    I seem to have lost my zoom box function. Office xp I think I had a crash and it went away |???
  15. mikeba1

    vb editor

    Can anyone point me in the direction of only displaying the forms code that i am changing and not all the other code, which displays as a cascade. I am sure it never used to be like this?
  16. mikeba1

    ERROR 3061

    I get the error 3061 when I run the following CurrentDb.Execute "qryremovepurchaseinvoicesplplinks" However when I run it as DoCmd.OpenQuery "qryremovepurchaseinvoicesplplinks" I get no errors. The query is as follows UPDATE PurchaseInvoices SET PurchaseInvoices.PLIPmtShedNo = Null...
  17. mikeba1

    vba debug

    Access 2003 When I get a debug error in vba code, when selecting close debug window, it jumps completely out of access. I have other databases that do not do this. Is there some sort of setting?? Thanks
  18. mikeba1

    type mismatch

    I get run time error 3464 when the following code is executed on click event of a combo box with a query as its source. ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[activityclassid] = '" & Me![Combo9] & "'" If Not rs.EOF...
  19. mikeba1

    continuos subform

    I have a main form with a tabular subform. With the on current event on the subform I am trying , dependent upon a field within the sub form, to change the colour, however the colour only changes to the first record and the remaining records show that colour,and not the colour they should be...
  20. mikeba1

    query output to excel

    I have a query that exports to excel, where one of the fields is a currency rate, I have specified the field properties as format 'fixed' with 4 decimal places. Fine when you just run the query without exporting it. When exporting only shows 2 dp? Any ideas.

Part and Inventory Search

Back
Top