Search results
-
J
Question on no data reports and numeric fields
I have same problem and get #Name? ... suggestions welcome... -
J
Join Properties; DISTINCT to DISTINCT possible?
Hi, In the standard Join Properties box you have three option: 1 Only rows where joined fields both tables are equal 2 All records from table a and only those from table b where joined fields are equal and 3 the oppiosite of 2 I have two tables matched on user where the user might have... -
J
How do i increment a date field?
Private Sub Command70_Click() On Error GoTo Err_Command70_Click Dim CmbDate As Control Set CmbDate = Me.CmbDate DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar... -
J
How do i increment a date field?
thanks guys. we now get a record for today, then today + 1 repeated as many times as you press submit. ie - still cant get it to take the last created date and add one to that... -
J
How do i increment a date field?
But the bit i dont understand is : "set fldDate = me.WhateverYouCalledYourField" Is "WhateverYouCalledYourField" the fiels on the Form (CmbDate) or the field on the table ([TrackTime]![Date])? -
J
How do i increment a date field?
thanks .. just for the record, dont worry i wasn't trying to use "fieldname" - i was aware that was an example ... i always find that funny when you see people post: " but where do i find 'yourtablename' in my DB??!" :) anyway, i'll try your suggestions now.. -
J
How do i increment a date field?
Hi Dan, Thanks, i think thats exactly the solution i need to head for.. I have tried adding this code but i am having trouble getting it to accept the location of "fieldname". Do i need to declare the location first? Do i need to specify the date field on the form or on the table? thanks... -
J
How do i increment a date field?
he he - no worries. which bit of code; the Time Entry form? This is the bit of code that copies a record, which i would like to have increment: Private Sub Command70_Click() On Error GoTo Err_Command70_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem... -
J
How do i increment a date field?
i dont think so; that will just give me a figure output (number of days between two dates). i need to actually create records on the table all the same except the date incremented by one day eych time. as mentioned above this can be user driven (they click submit on the form 10 times for 10... -
J
How do i increment a date field?
I maintain a Time Tracking db for office workers. They log in and select the task, billing code, number of hours per task worked etc. I need a 1 click solution for the users to enter a weeks records at a time - eg for vacation, illness or a weeks training course. Currently they have to enter a... -
J
TimeSheet db: How to enter a weeks records with Date Incremented?
i just tried to convert it to 97, but it said i lack some key components and now wont let me open it (lucky i made the backup..) i am going home now, perhaps we can hook up Monday to see if you are able to save me.. ? cheers -
J
TimeSheet db: How to enter a weeks records with Date Incremented?
hi doran, its Access 2000... -
J
TimeSheet db: How to enter a weeks records with Date Incremented?
Hi Ok, guys; probably a simple one but its got me: I maintain a Time Tracking db for office workers. They log in and select the task, billing code, number of hours per task worked etc. I need a 1 click solution for the users to enter a weeks records at a time - eg for vacation, illness or a...