Search results

  1. I

    Nest iif multiple condition to be converted to Switch or Select Case

    Hello, I'm using the following code and it's working, by any chance is it possible to have the same very code working using Switch or Select Case might be? using VBA function will be the best option. Thanks CategoryNat: IIf([NoBeneSign]=True And...
  2. I

    Navigation to DS on subform of navigation form

    good afternoon, While I'm trying to reference to a control on from of navigation sub form is show an error message that "Microsoft Access can n't find field referred to in your expression". Once you open the attached db open frmMain then selected Duplicated Red Report from the list on the right...
  3. I

    Duplicated Records

    Good afternoon, Please see attached db I'm trying to check for duplicated record of tblRed based on selected loc name, but apparently it is not working as I want to be, as it is returning all the records of the selected loc name as duplicated records, it seems that it is making the comparison...
  4. I

    Controls of main navigation form are not responding

    Hello, can you please take a look at the attached db, I have coded my control and are fully function very well in "frmStatesHome", later on I created a navigation form "frmHome" I dragged "frmStatesHome" to "frmHome", then cbo & txt that are suppose to filter the subform are not function. Thanks
  5. I

    Refresh subform in maiin Navigationform

    Hello please see attached db, I'm trying to refresh sub form of navigation form after it adds an new record. but I'm getting error message. Regards
  6. I

    UnMatch Query Multiple Records

    Hello There, I have two table tblRed & tblDistReg, please see attached db. I'm trying to write a query that return all the unmatch record in tblRed where the DateOfDist of the record in tblDistReg is null. in my attached db the qryUnmatch should return the records as an unmatched: RCNb...
  7. I

    Syntax Error Query - ('Single' "Double" Quotes)

    Hello, The following code is showing syntax error, as understand this should be because of the single double quotes, any support please. Thanks strDeleteRegData = "DELETE tblDistReg.*, RegisterID FROM tblDistReg " _ & "WHERE...
  8. I

    Syntax error INSERT INTO statement VBA

    I'm using the following code to import data from external access DB but is showing syntax error INSERT INTO statement. any suggestions please. I'm calling the below code using cmd click event. Thanks Private Sub ImportSelectedFile() Dim strImportedData As String strImportedData = "INSERT INTO...
  9. I

    Check for duplicates before running append query

    Hello, I have qryDistReg which it filters the data from tblDistReg, then I'm appending the filtered data to tblDistRegData. As am appending the data one monthly basis, I want to check the data of tblDistRegData before running the append query/code. I'm using the following code to check for the...
  10. I

    First Date of selected month

    Hello, I have the following function to return the first date of the selected month, which it's getting the value of the selected month from txtDateOfPlan. apparently it's returning the first date of the current monthly what ever the selection is. Your kind support please Regards Function...
  11. I

    Filter subform with cobmo box columns, based on textbox value

    Hello, I’m using the following code to filter subform in main form, my subform source object is based on query, and there are some columns of the subform has relationship with another table, as you see in the below code it’s related to district table, and I’m using lookup to display district...
  12. I

    Database Designing - ER

    Hello, Please your advice on the attached relationship,most of my transaction depends on AreaID, it's good bad? what is the way forward and what is best practice that I can follow? Regards
  13. I

    Update Table column with dates based on From - To Value plus filtered location

    Dears, The idea is that I'm trying to update all the records of the table based on From - To numbers, CmdUpdate on Click Event to update the table, please note that I need to filter for certain location before updating, and previous month data to be kept so where in another table for future...
  14. I

    Adanced Login Attendance

    Hello, I'm looking for advanced login attendance to my database, that records user login date/time, appreciate if a can get a data base sample. regards
  15. I

    CheckBox for Subform that allow user to select record

    Hello, The idea is that I want to add a check box to my datasheet which it's placed in a sub form, to allow user select only one or multiple records which it's help me a lot for validation, submission, deletion,& approving of the records. Regards
  16. I

    Check for Unmatched record

    I have two tables that I want to check is there any record in Table (A) but not in Table (B) the comparison column is number field, my problem is that the numbers are in serial in the first column while scattered into two columns From - To in table (B). I don't what to go for the solution of...
  17. I

    How to assign serial numbers From - To.

    Hello, Below Table (A) shows the primary information, I need to generate/assign integer number From - To starting form 1, and the result should look same as table (B) Table (A)--------------------------------------------------------- Name Qnt Sahara 3 Tarak 2 Waeel 1 Table...
  18. I

    Generate in between numbers

    I have ms-access table (A) as below, and I want a macro/VBA code that allow me to generate the in between serial number as shown in table (B). Regards Table (A) -------------------------------- ID Name Size From To 1 Sarah Umer 3 1 3 2 Tallia Noor 2 4 5...
Back
Top Bottom