Search results

  1. L

    List items on a form erratically invisible.

    I have a large database with a front end and a back-end on a server. There are multiple users that use different front-ends on different computers. The problem is that one specific list on a form fails to show its items on some computers but behaves normally on other computers. The different...
  2. L

    defective number variable in an SQL statment.

    Hi All Access programmers, I have been trying to solve this problem with no success after a search on online sites. I have an SQL statement with two variables, that does not seem to get going. I know that one variable is punctuated well and is working but the other seems to stick for...
  3. L

    How do i fashion a report on this crosstab query ?

    I am trying to make a report on this crosstab query. PARAMETERS [Forms]![Dispensing History]![Combo5] Text ( 255 ), [Forms]![Dispensing History]![Text2] DateTime; TRANSFORM First(Query2.NurseID) AS FirstOfNurseID SELECT Query2.Description, Query2.Dose, Query2.Frequency FROM Query2 GROUP BY...
  4. L

    Switching on computer sound using vba

    I have compiled an access database for patients, that needs to have the computer sound on as a voice is sounded by one of the modules. The program will be operated by patients themselves, and it may happen that the computer sound or its volume may be switched off during execution of that...
  5. L

    #name?

    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...
  6. L

    Facial recognition software

    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...
  7. L

    Vanishing Nested IIf function.

    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...
  8. L

    Subreport not showing on main report.

    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...
  9. L

    Conditional formatting on continuous subform.

    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...
  10. L

    Making data in a field on a form appear if content is Not Null.

    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...
  11. L

    troublesome function with #Error

    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...
  12. L

    Finger print reader and access

    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...
  13. L

    Filter problem

    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")...
  14. L

    Naming a range to export data to an access table.

    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...
  15. L

    Inserting a string variable in SQL statement

    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...
  16. L

    dATE USER DEFINED FUNCTION TO WORK AS CRITERIA IN A QUERY

    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...
  17. L

    Time elapsed to decimal

    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...
  18. L

    Aged Analysis Query

    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...
  19. L

    Opeing a form to enter new data only.

    I have been having problems with opening a form to add new records only. I have gone through all possible solutions but somehow the problem persists. I want to add new records only and not view any of the existing records. I have set the form properties to Date Entry Yes, Allow...
  20. L

    Referencing a value from a Combo Box

    Can someone please remind me how to reference a value on a combobox in one form from an object on another form. I have put in =Forms![Company Name].Combo7 in the field object on the form and I have got the ID autonumber of the Company Name. So far so good. It worked. When I put in...
Top Bottom