Search:

Type: Posts; User: osemollie

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    892

    Re: Calendar booking system

    Guys, I really need your help on getting a hyperlinked calender on my website. What do I need to do?
  2. Replies
    5
    Views
    892

    Re: Calendar booking system

    any suggestions friends?
  3. Replies
    5
    Views
    892

    Re: Calendar booking system

    I am using Ms-Access 2007 as my database and want to use ASP as my programming language. I also have ASP.NET but am still learning the basics.

    Thanks.
  4. Replies
    5
    Views
    892

    Calendar booking system

    Dear members, am a newbie web programmer and a client of mine has approached me to design an online booking page for their bouncing castle hire business. When a client want to make an online booking,...
  5. Replies
    4
    Views
    582

    Re: SQL Code error

    In the combobox events. Because, if I select a movie with an apostrophe and then clcik on select, that is when i get an error described above.

    How do i replace a Single apostrophe with double...
  6. Replies
    4
    Views
    582

    SQL Code error

    I have the following code :
    Private Sub cmdAddItems_Click()
    Screen.MousePointer = 11
    '#### If the lvwCheckOut has already 3 items, do not add the next item
    If...
  7. Replies
    11
    Views
    768

    Re: Error in code

    Thanks si. I actually have traced where the problem was. As you rightly put i needed two controls to define start/end date. But when you look at my code above, I made a mistake and used the same...
  8. Replies
    11
    Views
    768

    Re: Error in code

    Am actually trying to limit my search to a given period. Like in this case let us say I want all movies that were bought between July 1, 2006 and September 10, 2006. All these information is stored...
  9. Replies
    11
    Views
    768

    Re: Error in code

    This is what I get:
    SELECT movieInfo.title, MediaType.StrKey, genre.genre, movieInfo.movie_year, country.country, language1.language1, movie_inventory.PurchaseDate, audienceRating.rating FROM...
  10. Replies
    11
    Views
    768

    Re: Error in code

    My apologies for not giving all the info. I have tried the above but came up with no results at all yet i chose dates that fall within the scope.

    My complete code is:rivate Sub cmdSearch_Click()
    ...
  11. Replies
    11
    Views
    768

    [RESOLVED] Error in code

    Am trying to search my database using dates. Where am i going wrong? My code is If chkPurchased.Enabled Then sWhere = sWhere & sKeyWord & "PurchaseDate >= & "#" & dtpPurchaseAfter.Value & "#" AND...
  12. Replies
    7
    Views
    973

    Re: Generating Reports

    This is just a form for an application and NOT meant for the web. I cannot afford buying crystal reports and that is why i opted for the VB data report. Do I have any other option or should I live...
  13. Replies
    7
    Views
    973

    Re: Generating Reports

    Am using Access as the back-end and VB6 as the front-end. I need to inegrate the reports into VB6.

    Thanks
  14. Replies
    7
    Views
    973

    Re: Generating Reports

    Any ideas?
  15. Replies
    7
    Views
    973

    Generating Reports

    I was searching on the internet and found reports that are displayed inside/as part of the form. See attachment. Since am working on almost a similar thing, I got thinking, how can I make my reports...
  16. Re: Resize Form controls to Fit different Screen Resolutions Automatically

    No, it highlights the next line and so on ...
  17. Re: Resize Form controls to Fit different Screen Resolutions Automatically

    Set CtrlPos(Num).Contrl = Ctrl
  18. Replies
    8
    Views
    4,770

    Re: Form Restore-And Other Resolution Issues

    I have done lotsa search here and came up with what I have above. unfortunately, I get an error and that is why am seeking your help
  19. Re: Resize Form controls to Fit different Screen Resolutions Automatically

    Keithuk, no offense meant. I just wanted to inform the forum members that my code had raised an error.

    The error is first encountered below:

    For Each Ctrl In Me.Controls
    ...
  20. Replies
    8
    Views
    4,770

    Re: Form Restore-And Other Resolution Issues

    Any suggestions?
  21. Replies
    8
    Views
    4,770

    Re: Form Restore-And Other Resolution Issues

    Sub ReloadPos()
    ReDim CtrlPos(Me.Controls.Count)
    Dim Ctrl As Control
    Dim Num As Long


    For Each Ctrl In Me.Controls
    Set CtrlPos(Num).Contrl = Ctrl
    ...
  22. Re: Resize Form controls to Fit different Screen Resolutions Automatically

    Private Type ControlPlaces
    Contrl As Control
    Left As Single
    Top As Single
    Width As Single
    Height As Single
    End Type
    Dim CtrlPos() As ControlPlaces

    Private Sub Form_Load()
  23. Resize Form controls to Fit different Screen Resolutions Automatically

    Guys, I have designed my application on a machine with a 800 x 600 resolution. However, when I try running it on a machine with a 1024 x 768 specifications, I end up with a lot of empty space and doe...
  24. Replies
    7
    Views
    949

    Re: user-generated reports

    You are right, I need user updatable reports. Eg assuming company XYZ buys my application, when it comes to generating reports, they should be able to customise the reports so that when printed, the...
  25. Replies
    0
    Views
    575

    DataReport inside MDI form

    I have seen a certain application where the DataReport is displayed inside/within the MDI form. How can I do that?
  26. Replies
    4
    Views
    597

    Re: Coding date differences

    Yes but am not sure of how to call the function in a WHERE clause. Mind sharing?
  27. Replies
    5
    Views
    628

    Re: MDI child forms display

    You were right, it works perfectly now.

    Thanks all
  28. Replies
    4
    Views
    597

    Coding date differences

    I wish to display in a ListView control, movies that were loaned out in the course of this month. The challenge am facing is, on this form there is only one control (the ListView control) and it is...
  29. Replies
    5
    Views
    628

    Re: MDI child forms display

    Thanks Gavio, however, this centers the form at the bottom of the screen. Part of the form is infact part of the form is partly hidden and need to scroll to see it whole. It is centered from Left to...
  30. Replies
    5
    Views
    628

    [RESOLVED] MDI child forms display

    Maybe this has been answered somewhere but I have not spotted it.

    I have my MDI child forms and I wish to display them in the centre of the screen everytime i need to show them. How can I ensure...
  31. Replies
    15
    Views
    959

    Re: How Can I Code This?

    How should I connect the UPDATE code to the rest of the code? Currently If I try to code as in the example above, The Update statement is highlighted in red indicating an error.

    Thanks
  32. Replies
    7
    Views
    949

    Re: user-generated reports

    I have managed to create reports using the DataReport control. But the challenge is, assuming that my users want to add their business names/logos in the reports as title headers/footers, how can I...
  33. Replies
    15
    Views
    959

    Re: How Can I Code This?

    Any ideas people?
  34. Replies
    15
    Views
    959

    Re: How Can I Code This?

    I have tried Private Sub Form_Load()

    Set stuNewMovie = New CNewMovie

    Set cnAddMovie = New ADODB.Connection
    cnAddMovie.Provider = "Microsoft.Jet.OLEDB.4.0"
    cnAddMovie.Open App.Path &...
  35. Replies
    15
    Views
    959

    Re: How Can I Code This?

    Sorry, am trying to understand, why are we using the UPDATE statement here?

    And is the following CODE right? Am totally confused here:WHERE Trans.UserId UPDATE TransDetails.ItemReturnDate =...
  36. Replies
    15
    Views
    959

    Re: How Can I Code This?

    I am a bit lost here, please help me.
    ....WHERE TransDetails.ItemDueDate =????(TransDetails.ItemDueDate) AND TransDetails.ItemReturnDate = ?????(TransDetails.ItemReturnDate)
  37. Replies
    15
    Views
    959

    Re: How Can I Code This?

    I don't have the where clause because I didn't know how what to realte the WHERE clause to. On this form, the only control available is the ListViewControl that displays the results.
  38. Replies
    15
    Views
    959

    Re: How Can I Code This?

    This is what I have inside a form_load event and populates a ListView control."SELECT movieInfo.title, MediaType.StrKey, (users.FirstName +' '+ users.LastName) AS Name, trans1.TransDate,...
  39. Replies
    15
    Views
    959

    How Can I Code This?

    I have the following tables:

    - Users (userId, names, address)
    - MovieInfo (movieId, title, genre etc)
    - Transactions (transactId, userId,transactionDate)
    - TransactionType(TransactionTypeID,...
  40. Replies
    41
    Views
    2,094

    Re: Generating HTML page from VB

    Can I combine 2 recordsets in 1? Eg, when setting my movie Details i use one query but in the same HTML, i need to associate the movieId from movieInfo table, with the actors from actor table which...
Results 1 to 40 of 491
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width