Search results

  1. F

    Runtime error 3464 data type mismatch in criteria expression

    i have read other post about this error and tried adapting their fixes to fix my error without success. i have a form which the user enters a number in a text box in order to search for that number in a query. if the number is not found in the query I want a message box to pop up saying...
  2. F

    findfirst not working

    Hello fellow VBA users. i have a dilemma. I have a relational database that is SQL tables on the back end and Access 2016 on the front end. This is an equipment database that I have been tasked with updating functionality. This problem was not a problem until yesterday. i have a form that...
  3. F

    Need help with SQL statement in VBA

    I have a front end Access Form that is linked to a SQL Table. one the form when the user presses a button i want to ensure that the field named IncompleteDoc is not null but has a 1 in it. In SQL i would use the following query statement to accomplish this. update...
  4. F

    Image inserted into Report being reduced in size

    need help with using images in reports. i have a report that only display a image that was scanned and saved into a table. The image is saved as a JPEG. (i have tried BMP, PNG, TIFF). the margins of the report are set @ 8.5X11. the image margins are set at 8.4X10..9. I am using the size mode...
  5. F

    Please, need help combining TIFF files

    I am in need of some assistance. I have a VBA routine that will scan multiple documents into a folder as a TIFF. The problem is it scans each page as a single document. (e.g. page1.tiff, page 2.tiff, page 3.tiff, ETC). i need to combine these pages together into a single TIFF. I am trying to...
  6. F

    WIA scanning issues in VBA changing the default paper size

    I am working on a project which will eliminate several steps of the user to scan a document using a 3rd party software, manually naming the document using a predetermined naming convention, and placing it in a predermined folder. i have successfully used a VBA scanner code from an earlier...
  7. F

    the endless looping loop

    I have some VBA code in Access 2013 that i just can't figure out what I am doing wrong. I open two separate queries. I match data from one query with the other by using two fields, name field and a date field. when a match is made the place the date from the first query into the second query...
  8. F

    Access 2013 VBA Run-Time error 28 Out of Stack space

    I have created a database that takes one query that has a blank field in a predetermined field and finds a record in a second query that matches name and date of birth criteria. it pulls the value into the blank field that is supposed to be there. MR missing in query one....find record in query...
  9. F

    How to send a report using VBA via outlook 2010 issues

    I have a VBA module in my Access 2010 database that will send a report as a PDF via email to a predetermined email address. the only problem using the docmd.sendobject method is i keep getting a pop up that says "A program is trying to send an e-mail on your behalf. If this is unexpected, click...
  10. F

    filtering a split form to show only records that are not completed

    I need help please? my brain hurts. i am trying to create a button on a split form/datasheet. I have a field named completed that is a yes/no field. if the job is completed then the field is yes, .... i want to use a button on the form that will filter the data on the datasheet view to show...
  11. F

    Hello

    Hello to all, my name is Michael. i am a new registered member to this site, but have been using the wonderful post here to solve my problems i have encountered. I am new to using VBA in Access 2010. I have created my first complex database from scratch for my medical clinic. i am always...
Top Bottom