Search:

Type: Posts; User: Andy1723

Search: Search took 0.02 seconds.

  1. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    I've nearly got it i think! Its just saying I have an error at the end of the loop when I move to the next record.

    Do Until tblBooking.EOF
    If DatePart("m", tblBooking!Date) =...
  2. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    It doesn't display the right details, for example "Michael Jordan" didn't book "break dancing", but its printing him off a bill for break dancing...

    I need the tables to sort of synchronise?
  3. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    Do Until tblBooking.EOF And tblCustDetails.EOF
    If DatePart("m", tblBooking!Date) = currentMonth - 1 Then
    lblEvents.Caption = tblBooking!eventName
    If...
  4. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    Hmm i think i figured out what I'm doing wrong. I'm searching until i find the right date then it'll print that then the record that it is currently on in tblCustDetails rather than the record that...
  5. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    VB6, if i use anything I have to thoroughly understand what I'm doing though :D Is it pretty self explanatory?
  6. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    No, because one customer can make multiple bookings.

    Edit: But now the other labels are changing! But i still get the error message. hmm
  7. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    I also get a "error: no current record" but my database is heavily populated and there is no empty fields or anything?
  8. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    THank you for that it works really well but It still doesn't update the other labels! like i have a lblFirstName that isn't getting updated, I have set the relationships in access? This is really...
  9. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    mm i noticed that the only thing its displaying is from tblBooking, and its only displays one record from tblCustDetails.
  10. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    I have Labels for the customers contact details, and then one for the thing they are being billed for and one for the price. What I want is visual basic to cycle through tblBookings and find any...
  11. Replies
    19
    Views
    812

    Re: Printing Forms, databases.

    Yeah, thats the one that I'm left with on screen but all of the printed forms have the right event, lblEvent and tblBooking!eventName, but the rest of the labels have the wrong information, and i was...
  12. Replies
    19
    Views
    812

    Printing Forms, databases.

    Hello, I want to create a loop which will cycle through my database end pick out every record that has a date which is a month previous to the current one, I have succesfully got my program to get 1...
  13. Re: Use DTPicker to get Records from DB and display it

    The results its getting are all in the correct range of dates, I mean it will display dates up to with a day value 7 days after the day value of my dtp picker, but it will display them for all...
  14. Re: Use DTPicker to get Records from DB and display it

    Actually that is getting results.
  15. Re: Use DTPicker to get Records from DB and display it

    Dim startDate, endDate, fullDate, monthNumber, yearNumber As Integer
    Dim found As Boolean
    Dim fullSDate, fullEDate As String


    tblBooking.MoveFirst
    found = False

    startDate = DatePart("d",...
  16. Re: Use DTPicker to get Records from DB and display it

    woo i'm having the exact same problem.
  17. Replies
    15
    Views
    962

    Re: Listing Data between two Dates

    Because the interval should be a week between the dates i want to retrieve, I added this to your code

    startDate = DatePart("d", dtpStartDate)
    endDate = startDate + 7
    monthNumber =...
  18. Replies
    15
    Views
    962

    Re: Listing Data between two Dates

    That can't work because startDate and endDate is just the number for the day, not the full date!
  19. Replies
    15
    Views
    962

    Re: Listing Data between two Dates

    Hmmm, I decided to try using a counter, still doesn't work, but i think its a better idea.


    heres my code:
    For counter = startDate To endDate
    While Not found And Not tblBooking.EOF...
  20. Replies
    15
    Views
    962

    Re: Listing Data between two Dates

    I'd prefer to do it the way I posted above if it is do-able like that??

    I know its probably not the easiest way but my knowledge is really limited so it would be really hard for me to alter the...
  21. Replies
    15
    Views
    962

    Re: Listing Data between two Dates

    How do i find out??
  22. Replies
    15
    Views
    962

    Re: Listing Data between two Dates

    Access stores the data!

    Option Explicit
    Public dbfVillageHall As Database
    Public tblCustDetails, tblPrices, tblBooking As Recordset

    Sub Main()
    Set dbfVillageHall = OpenDatabase(App.Path...
  23. Replies
    15
    Views
    962

    Re: Printing Data between two Dates

    startDate = DatePart("d", dtpStartDate)
    endDate = DatePart("d", dtpEndDate)

    Do Until startDate = endDate
    While Not found And Not tblBooking.EOF
    If tblBooking!Date =...
  24. Replies
    15
    Views
    962

    Re: Printing Data between two Dates

    Access is not doing any of the work, just retrieving data from my visual basic programming. When I try using that I get an error saying "Expected Case".
  25. Replies
    15
    Views
    962

    Re: Printing Data between two Dates

    Hmm maybe if i used DatePart("d", dtpStartDate)

    startDate = DatePart("d", dtpStartDate)
    endDate = DatePart("d", dtpEndDate)

    Do until startDate = endDate

    then add 1 onto the startdate...
  26. Replies
    15
    Views
    962

    Listing Data between two Dates

    I need to print out data from a access database that is between two dates.

    For example, If i have entries in my database at
    2/5/06 Swimming
    3/5/06 Dancing
    7/6/06 Fighting
    2/7/08 Skipping
    ...
  27. Replies
    13
    Views
    8,273

    Re: Showing Leap Year VB6

    This is what my task specification says

    Give the Julian Date where the day and month are replaced by an integer the value of the number of days into the year....

    examples

    31/12/2003 ...
  28. Replies
    13
    Views
    8,273

    Re: Showing Leap Year VB6

    Thanks that codes great! but I have to output the Julian date in a "wrong" format, i.e

    31/12/2003 to julian is 2003/365

    01/03/1999 to julian is 1992/366
  29. Replies
    13
    Views
    8,273

    Re: Showing Leap Year VB6

    I'm not quite sure I understand these functions! :S

    What I want to do is get the data from this function

    Function isLeapYear(year As Integer)
    Dim year As Boolean
    If (year Mod 4 = 0 And...
  30. Replies
    13
    Views
    8,273

    Re: Showing Leap Year VB6

    http://img337.imageshack.us/img337/5402/formscreen8vc.th.jpg

    That is what my form looks like.

    Does the days of the month function take leap years into account?

    x
  31. Replies
    13
    Views
    8,273

    Re: Showing Leap Year VB6

    and how would i intergrate that into my code?

    I'm a totally newbie to Visual Basic, i'm trying to piece together how to get the hang of this.
  32. Replies
    13
    Views
    8,273

    Showing Leap Year VB6

    I need to show the Leap year in visual basic, as well as calculate the Julian Date. I've got stuck on getting the results from the funtion into the label (my output component) I was just wondering...
  33. Replies
    3
    Views
    401

    Arrays, Loops, Help!

    I'm having a really hard time doing a one-dimensional array.

    This is my task:
    Write a program in which a one dimension array of 6 integers is declared. Read a value entered by the user into each...
Results 1 to 33 of 33



Click Here to Expand Forum to Full Width