Search:
Type: Posts; User: Andy1723
Search:
Search took 0.02 seconds.
-
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) =...
-
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?
-
Do Until tblBooking.EOF And tblCustDetails.EOF
If DatePart("m", tblBooking!Date) = currentMonth - 1 Then
lblEvents.Caption = tblBooking!eventName
If...
-
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...
-
VB6, if i use anything I have to thoroughly understand what I'm doing though :D Is it pretty self explanatory?
-
No, because one customer can make multiple bookings.
Edit: But now the other labels are changing! But i still get the error message. hmm
-
I also get a "error: no current record" but my database is heavily populated and there is no empty fields or anything?
-
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...
-
mm i noticed that the only thing its displaying is from tblBooking, and its only displays one record from tblCustDetails.
-
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...
-
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...
-
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...
-
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...
-
Actually that is getting results.
-
Dim startDate, endDate, fullDate, monthNumber, yearNumber As Integer
Dim found As Boolean
Dim fullSDate, fullEDate As String
tblBooking.MoveFirst
found = False
startDate = DatePart("d",...
-
woo i'm having the exact same problem.
-
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 =...
-
That can't work because startDate and endDate is just the number for the day, not the full date!
-
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...
-
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...
-
-
Access stores the data!
Option Explicit
Public dbfVillageHall As Database
Public tblCustDetails, tblPrices, tblBooking As Recordset
Sub Main()
Set dbfVillageHall = OpenDatabase(App.Path...
-
startDate = DatePart("d", dtpStartDate)
endDate = DatePart("d", dtpEndDate)
Do Until startDate = endDate
While Not found And Not tblBooking.EOF
If tblBooking!Date =...
-
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".
-
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...
-
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
...
-
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 ...
-
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
-
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...
-
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
-
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.
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|