Search results

Hi! I created a form that has a button and 4 option buttons.I use the following code to export the data to an excel file: Dim xlapp As Object Set xlapp = CreateObject("excel.Application") On Error Resume Next If IsNull(Me.Frame22.Value) Then MsgBox ("You must select a filter!"), vbOKOnly...

Hi there, I have a table [maintable] that holds print records, with the following fields : id,userlogon,printername,pagecount,color(yes/no),duplex(yes/no),timestamp and papersize. I want to create a query that will show the following: Sum of pagecount where papersize like 'a4' and between 2...

Hi, i have a form that users will use to add new records (customers). there is a field named VAT_Registration_no first of all i want some code to check for duplicates in that field only,before entering the next field.If the record exists i want to show a msgbox and set focus to the...

Hello.I want to create a search form for a database.The database is simple.It has three tables (employees,departments and company).the fields of the employees table are:first name,last name,internal phone,department and floor. I want to use this db to search for internal phones but i dont know...

Hi,i made this form to calculate cost per page of a printer.I just want your opinions and any ideas for improvement :) i also have a problem.Why i need to press the button twice to apply the vat?pressing it once changes the value in the table but doesnt show in the form.i have to press it twice...