Search results

What key can open any lock? A Pikey!

Cheers guys, problem solved!

Just a quick one to ask is there some simple code for the following problem. In a query I want the criteria for a date field to display all the dates when the month in a text box on a form matches the month for the field the criteria is being entered into. All dates are in the format...

Thanks for the help. Although I don't understand how you use the code to match up the month and year once the fields are referenced.

Would that mean that I would have to type in the start and end date in manually to return that months data?

Hi I was wondering how easy it is to sum a field based on a certain month. To explain further, at the moment I have a form that does several calculations. One of which uses the sum function to calculate the total of a cost field in a different form. I would now like to change it so that...

I have tried that code on the 'OnGotFocus' event as well as a few other events and it doesn't seem to make a difference.

This may seem like a stupid question but where would I put this code because nothing is happening at the moment :o

Hi, In my database I have a form with client details on, then I have a subform where data is entered for specific jobs done for the clients. When I select a client from a dropdown list on the main form, the job details come up on the subform. I want the subform to default to a new record...

I have a column in a subform which displays the elapsed time in hours and minutes. I now want to be able to have a new column called cost, which multiplys the time by an hourly rate. Would I be right in suggesting that I need to convert the hours and minutes into decimal format before I can do...

You are right about the format I want, but rather than display the result I want to multiply the decimal by a [rate] field to find out different costs but it was the first part I was struggling with, thanks for your help.

Does anyone know any simple code for converting a certain time period to a decimal? In my form I have a field that displays the time a task took in short time (e.g. 2 hours is displayed as 02:00) and I want some code that can convert whatever value is put into that field into a decimal to then...

Hi, Im relatively new to access coding but I need to find a way of working out the [overall time] field automatically by subtracting the [time work ended] field by the [time work started] field which have a short time input mask. I'm having a bit of trouble working out the code for this, could...