spleewars
Last Activity: Jun 1 '12, 06:39 PM
Joined: May 20 '11
Location:
-
Thanks for your input rabbit. After spending hours trying to find the answer to the question, i finally found out that it was all fault of a statement in a query. Set a workaround on a new query and fixed the problem. Thanks all! -
tried as well for trial purposes. didn't worked either. however the code number is composed of numeric and text so single quote is to be usedLeave a comment:
-
And a quick question: how many records are in Overdue and Open? Is there a huge amount of records in closed wo?Leave a comment:
-
You need to give a better understanding of what is wo.now. apart, does this problem appear out of nowhere?Leave a comment:
-
Double click to open record performs no action
I've been struggling several time with this problem and apparently its driving me a little crazy: i have this code
I cannot understand why on other forms this code works flawlessly and sometimes...Code:Private Sub CodeNumber_DblClick(Cancel As Integer) DoCmd.OpenForm "Products", , , _ "[products.codenumber]=" & "'" & Me.CodeNumber & "'" End Sub -
Hi Rabbit, thanks for your input. Actually there might be a little misunderstandin g but the 'log' form (http://imageshack.us/photo/my-images/198/23473788.jpg/) is a simple select query, just to show record details of the payment.
Form "Report" and subform "bank" are related to each other with RECORDID as autonumber in Report form.
Never used an update query so far - will be very happy if you can help...Leave a comment:
-
Hi thanks for your reply smiley coder :)
To make myself a little more clear, my real scenario, in "Status" i got 3 options as a combo box (instead of option1, option 2, option3):
- waiting
- paid
- archive
Going to my previous example, when the user inputed data in 28-Feb-2012, he set the "status" as PAID (or can even set it as waiting). When the customer returns On 23-Mar-2012,...Leave a comment:
-
Commiting changes in past records
Got a complicated challenge (better define my last challenge) but don’t have a clue where to start: I’ll try to be accurate as possible. Apologies I might be asking for a lot of coding but this has been bothering my for a lot of weeks trying to do it myself the ‘simple’ way but failed all over every time. This is all about automatic changes in particular field of a past payment.
Got form “Report” and subform “Bank”. The purpose of... -
followed your advice and done :) thanks againLeave a comment:
-
hi Rabbit once again :)
i cannot understand how can i use the DATEDIFF in this situation. I mean how is it possible to find the elapsed time from a start date to an end date using the latter function?Leave a comment:
-
Trigger time in queries
i believe trigger time in queries is possible but i need some suggestion. let say i set a new record with today's date. passing the table through the query, what parameters are to be used on "date" to make the record visible in 3 months time?
Clara -
Big thanks rabbit :) all i wanted was to be enlightened in this case! :)Leave a comment:
-
How do I Sum Time Values
The scenario is based on 2 data fields: "IN" and "OUT": both are time fields and the main function is to serve as a punch clock. In order to work out calculations and get the total time, both were passed into a query and set out the formula:
datediff ("n",[in],[out])
So to convert the raw time of the latter formula, i set a new one to divide the amount of 'datediff' into hours and minutes:...
No activity results to display
Leave a comment: