Search results

I have a subform on a form. The form is unbound and has several controls on it including a listbox, other than the subform. On double clicking the listbox a new record is added on the subform using vba. I have programmed the event procedure to be able to focus on the new record in the subform...

I have created a payroll system for a company employing around 100 employees. To login each employee enters an employee number and his password. The snag is that employees can exchange these details to clock in or clock out for each other. Has anyone used some type of facial recognition...

Hello, I am having a very strange difficulty with inserting a nested IIf function in a query field. This IIf function contains two user defined functions inside. It runs as follows. Vacation:IIf(IsNull([EntryTime] AND...

The subreport has data and prints when placed in the page header section of the main report. It is linked well as it prints well when placed as above. However when placed here it does not include all the records when there are many. Any other possibilities. Thanks. Louis Buhagiar.

Hello access programmers. I have a main report with one subreport. The main report contains details of a payment being made to a supplier. There is the total amount being paid, and the cheque number being transferred. There is also a field called payref which is made invisible. This is...

I have a continuous subform on a form. I have applied conditional formatting with expression is.. so that the formatting on one object (field on the subform) depends on whether there is anything in another field on the same subform named "Remarks". My problem is that I this is not working...

I have studied the ControlTipText property in access, and it appears to satisfy my needs very well. I did not know of this useful function. Many thanks for your expertise. PS The ControlTipText property in access however is a bit fickle. On the mousemove event you have to tease the field...

I have a subform with continuous records. One of the fields in the recordset of the subform is a field named "Remarks". This field does not need to be visible on the continuous subform as it is rare that this field will have any entries. I plan to apply conditional formatting on another field...

For the sake of completeness I tried as well the method suggested by Paul. The method appeared quite neat. However it did not work. The same error continued to glare in the fields where FinishTime was null. It appears to be that in a user defined function the first line has a prime...

Many thanks to both Minty and pBaldy. With your help I have finally managed to solve this problem as follows using the IIF function. I included the user defined function within the IIf statement as follows and it is now working fine. The following statement was included within the query that...

I am trying to include the user defined function as part of the argument of an IIF function within a query. It is not working either and I am still getting the #Error. No luck yet. Louis Buhagiar

Many thanks. I have changed the data type of the EntryTime and FinishTime to Variant as you have suggested. Now the code stops and shows Runtime error 94 'Invalid use of Null'. Before the code used to run well and I used to get #Error only in those records where there was no EntryTime or...

Many thanks for your reply. It looks promising but I have never used this type of code in a User defined function. My code starts something like this and continues as the module is quite long. Essentially the code is trying to calculate working hours depending on worker category and their...

Hello access programmers. I have this very useful user defined function with the following beginning; Public Function PbHolhrs(EntryTime As Date, FinishTime As Date, Roster As String, JobTitle As String, TypeofEmployment As String, meta As Date, Btala As String, GhadaBtala As String) As...

I have just finished putting together an access database as a payroll. It is working fine and it will now save the company a lot of man hours in calculations. When the employee clocks in or out there is a form and the employee has to key in a unique employee number and a password, which of...

Many thanks for your prompt answer. I removed the double quotation marks on each side of the OR and then started to get errors with extra (). So I removed these from either side of the OR clause and the filter is now working well. However I now hope that the two parts of the string on each side...

I am working to filter a form using vba as follows. filtru = ("[IDcardNo] = """ & numrukarta & """ And meta =Date()") The above filter works perfectly well. filtru = ("[IDcardNo] = """ & numrukarta & """ And meta =Date()-1 and [Roster] ='N' and [Finishtime] IS Null")...

Many thanks. The problem is not naming the range as this seems to be working well. The problem is to introduce the name of the range "ghazla" so that the DoCmd.TransferSpreadsheet command works. I would like to introduce the name of the range into the command in my code shown originally, so...

Many thanks for your helpful answers. I must admit I am not an expert with access vba although I am managing ok with a lot of research. I got my code from the web and copied it into my program. If I were to change the DoCmd. line to the format indicated by you I will encounter difficulties...

I am trying to write code in an excel worksheet to try to export excel data to a table in access. The range in which the data is situated in excel varies. So the range address varies with the data. After a lot of searching I wrote the following code which works for a range which is fixed. The...