Search results

Thank you for your reply. The SQL statement which I have used to start with did work. This was as follows; StrSq1 = " SELECT Employees.NName, Employees.SSurname, WorkItems.IDcardNo, WorkItems.DDate, WorkItems.EntryTime, WorkItems.FinishTime, WorkItems.Roster" _ & " FROM Employees INNER JOIN...

Hi everyone, I am trying to write vba code to enter a form. A am using an SQL statement in vba to enter the form with it. I want to include a string variable in the WHERE clause of the SQL statement. The string variable is introduced in the DIM statement before coming up to the...

In fact I used the in built function named Dateserial as a criterion in the query and it has worked well. Many thanks for your suggestion. Louis;)

Many thanks for your reply. Do you think I can use this in built function as the criterion. If so instead of somedate I will insert Date() for today. Thanks again. Louis

I have written a user defined function that calculates the end of the current month. This I named EndOfThisMonth. It works well as a function. Now I would like to use it as date criteria to include in a query. The function is included as such EndOfThisMonth(). The field on which...

3:30 refers to three hours thirty minutes . 3.5 refers to 3.5 hours 12:00 refers to twelve hours while 12 refers to 12 hours. 3:30 will not be good to calculate pay, whilst 3.5 will be. The same goes for 12:00 and 12. I hope I have made myself clear. Your help is appreciated...

Dear Paul, In fact i got the formula Format(time_out - time_in,"Short Time") from one of your previous posts. It is working fine in the sense that it is giving me results such as 3:30, 12:00 etc. However I need to have a number such as 3.5 and 12 instead, so that I can use this to...

My problem has been met with others before but despite adequate searches I have not managed to solve it. I am creating query that calculates time interval so that this is used to calculate pay. Employees clock in at [time_in] and clock out at [time_out]. Sometimes time_out is on the next day...

Thanks When I click it I get a file called attachment.php which does not turn into an access database. I seem to get all the unexpected results :) In any case thanks. There used to be a button to thank people which I do not seem to find either. Louis

Hi Bob, Last week we had an encounter with regards to a form which would not load to add a new record as a FormAdd. I had posted you my db but received no reply. In any case I solved that problem myself. I am still interested in any comments you might have to make with regards to my db in...

I am trying to answer my own question. Since I last posted it I have figured out that I have to create a first query based on the table. The query has to create a field using nested iif functions to assign a number depending whether the invoice has expired by 0,30,60 or 120 days. It assigns...

One o the tables on my database is called InvDetails. It contains details of the invoices that the company receives from various suppliers. Its fields the the following: Supplierefno Invoiceref Describtion amount Dateissued Pay_Ref Trustee Invoicefileref paid The...

Hi.. Can someone please explain why after sending my database online this thread appears to have gone dead ? Does this happen often on this site ? What could be the reason ? Louis Buhagiar.

Thanks. Well done.

Hi Bob, Good Day, I have found out what the problem was with that form not opening to add new records only despite the setting. Hurrah. The problem was with the query attached to that form. I re-arranged the query and excluded its relationship with table "CompDetails" and the...

Hi Bob, Can you please confirm that you have received the files ? Louis Buhagiar

I managed to compress it. Here goes..

Forgive me for being your nuisance for the day. How do I zip the file? Louis

Good Morning. Many thanks for your assistance. I will try to post you the db with this post as you advised. I hope I can attach it well. The db is split and has the fe and the be sections. The command button I was talking about that introduces the form which is not behaving well...

I TRIED THAT AND IT WORKED FINE. tHANKS FOR YOUR ASSISTANCE