User Profile

Collapse

Profile Sidebar

Collapse
Wayneyh
Wayneyh
Last Activity: Sep 30 '10, 12:55 PM
Joined: Mar 14 '08
Location: Falkirk
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Wayneyh
    replied to Can anyone explain these error messages?
    in PHP
    Thanks for all your help.
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Can anyone explain these error messages?
    in PHP
    Thanks i will try those.

    Is there a really basic shopping cart out there for beginners to learn from?

    regards
    See more | Go to post

    Leave a comment:


  • Wayneyh
    started a topic Can anyone explain these error messages?
    in PHP

    Can anyone explain these error messages?

    I am just starting to teach myself PHP and i have created a script from a book but i get these error messages.

    Notice: Use of undefined constant id - assumed 'id' in C:\wamp\www\pet sathome\seestor e.php on line 21

    Notice: Use of undefined constant cat_title - assumed 'cat_title' in C:\wamp\www\pet sathome\seestor e.php on line 22

    Notice: Use of undefined constant cat_desc - assumed 'cat_desc' in C:\wamp\www\pet sathome\seestor e.php...
    See more | Go to post

  • Wayneyh
    started a topic How do i PHP code a maximum order limit .
    in PHP

    How do i PHP code a maximum order limit .

    Hi all
    I am new to PHP. I am trying to create a small shop for our clients. The shop has to have a maximum order limit for each client. The maximum limit must be shown on screen with the amount ordered. When the amount ordered is equal to the maximum limit it should turn red and stop the client ordering any more but can still remove items orderd. I don't know where to start with this code so any help would be very much appreciated.
    ...
    See more | Go to post

  • How to change the content of a tables cell when iframe loads

    Is there a way to change the content of a tables cell in the index.html when another webpage loads into an iframe on the index.html?

    I think it needs to use the OnLoad but i have no idea how to put the code together.
    See more | Go to post

  • Wayneyh
    replied to Multiple invoice prints
    Thanks mshmyob

    I thought about doing it that way but was just trying to save a bit more time.

    The way you suggest is the better way i think.

    Regards

    Wayne
    See more | Go to post

    Leave a comment:


  • Wayneyh
    started a topic Multiple invoice prints

    Multiple invoice prints

    Hi all

    My problem is as follows. At present we can print multiple invoices by means of a Form with a from date textbox and a to date textbox. After inputting the dates required we click a button called btnSearch. How do i check a check box for each invoice to show that it has been printed. Below is the piece of code for the date range. Any ideas will be appreciated.

    Code:
    DoCmd.OpenReport "rptConfirmation",
    ...
    See more | Go to post

  • Wayneyh
    replied to Search Datasheet form
    Again, thankyou for all your help.

    Kindest Regards
    Wayne
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Search Datasheet form
    Hi NeoPa

    I works with the following code:

    Code:
    Private Sub btnSearch_Click()
    If IsNull(Forms![frmItems]![txtSearch]) Or Forms![frmItems]![txtSearch] = "" Then
        MsgBox "You Have Not Typed Anything To Search For"
    Else
        Forms!frmItems!frmItems_Sub.SetFocus
        DoCmd.GoToControl ("Item")
        DoCmd.FindRecord Me!txtSearch
    End If
    ...
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Search Datasheet form
    Thanks for all your help NeoPa. I will mess about and see if i can get it to work.

    Regards
    Wayne
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Search Datasheet form
    Hi NeoPa

    The btnSearch Is on the main form frmItems.
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Search Datasheet form
    Here is the last code i tried

    Code:
    Private Sub btnSearch_Click()
    
    If Me.txtSearch = "" Or IsNull(Me.txtSearch) Then
        MsgBox "You Must Enter Something To Search For !"
    ElseIf Forms!frmItems!frmItems_Sub!Item = Me.txtSearch Then
        DoCmd.FindRecord ("Forms!frmItems!frmItems_Sub!Item = Me.txtSearch")
    End If
    End Sub
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Search Datasheet form
    Yes i did try DoCmd.FindRecor d but i think my code was totally wrong.

    regards
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Search Datasheet form
    Hi NeoPa

    The Recordset contains
    ID - AutoNumber
    CompanyName - Textbox
    ItemCode - Textbox
    Item - Textbox
    QuantityInStock - Number
    txtDelivered - Textbox
    txtSale - Textbox

    Hope this helps as i am stuck. I tried a few things with the DoCmd.GotoRecor d but couldn't get it to work. Any ideas would be appreciated.
    See more | Go to post

    Leave a comment:


  • Wayneyh
    started a topic Search Datasheet form

    Search Datasheet form

    Hi everyone

    I have been asked to create a search form for our shop that searches a form in datasheet view.

    I have a Form called frmItems which has a subform called frmItems_Sub which has a textbox called Item in it which displays in datasheet view. frmItems has a button called btnSearch which opens a Form in popup view. When the user has entered the search criteria and clicks on the search button it should go to the...
    See more | Go to post

  • Wayneyh
    replied to Table search
    Thanks for your input

    Wayne
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Record Change
    Hi NeoPa

    Thanks for your advice, I will try them out and I apologise for not biding by the rules of the forum.

    Wayne
    See more | Go to post

    Leave a comment:


  • Wayneyh
    replied to Record Change
    Yes there is code behind it.

    When they Click save it changes a checkbox to true to and adds the date it was saved. This tells the user that the record needs to be re-printed.
    Code:
    Private Sub btnSave_Click()
    
        DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
        MsgBox "Customer Details for" & " " & Me.Company & " " & "have been saved
    ...
    See more | Go to post
    Last edited by NeoPa; Feb 13 '09, 02:57 PM. Reason: Please use the [CODE] tags provided

    Leave a comment:


  • Wayneyh
    replied to Record Change
    Thanks again missinglinq

    Much appreciated

    Wayne
    See more | Go to post

    Leave a comment:


  • Wayneyh
    started a topic Record Change

    Record Change

    Hi everyone

    When i open frmSales i have disabled the save button. What i want is if any field on the form is changed the save button is enabled. I can't use OnKey Press as the user might tab through the fields, so it needs to be code. I tried the forms On Data Change but it didn't work.

    Any ideas are appreciated.

    Regards

    Wayne
    See more | Go to post
No activity results to display
Show More
Working...