Search results

Hi All, I currently have a small database which contains part return information. I have had help from others on this forum and have been able to create a cascading filter form. This form takes the users inputs and creates a custom report. Currently, it will create a report with three...

Hi All, I currently have a small database which contains part return information. I have had help from others on this forum and have been able to create a cascading filter form. This form takes the users inputs and creates a custom report. Currently, it will create a report with three fields...

Hi All, I am currently trying to make a form which will generate a report for the users. Currently the form has 3 combo boxes where users select which fields they want displayed from the table in the report. They also have sorting options next to them (Asc or Desc). I am now trying to put in a...

Hi All, I have been struggling with MS Access for a while now. I am trying to create a form with multiple combo boxes where users can select fields from my main database and click a button to generate a report based on their selections. I think I am supposed to create a generic report with...

Hi All, I have been struggling with MS Access for a while now. I am trying to create a form with multiple combo boxes where users can select fields from my main database and click a button to generate a report based on their selections. I think I am supposed to create a generic report with...

Hi All, I have a small database and have just begun to create some reports. I have a table called EVAP Database. I want to create a form where users can select 3-6 fields (from combo boxes) and then can click a generate button to open a report with those selected fields as the report. I messed...

Hi All, I currently have a small database where users input information on return parts. I have added a section to add data from testing and have made it so it greys out certain boxes when the part type is selected using conditional formatting. However conditional formatting will only allow...

Hi All, I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3...

Hi All, I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3...

Hi, I recently just created a search form where users may enter 3 types of criteria, with results showing below in a list box. When a user double clicks the result it brings them to the whole record. For some odd reason when I close out of the database and reopen the search form, My cursor will...

Hi, I currently have a database which contains various information for part returns. Among this information is contained a parts tracking number, VIN Number, and Date Code. I want to have a small dialogue box (Form) where a user can enter a tracking number, (or a date code or VIN if tracking...

Hi all, I currently have a database where new records can be entered in a "New Part" Form and Records can be viewed(but not altered) in a "Part Search" Form. The forms are the same except one is allowed to edit. I have also created another form where I am trying to search the "Part Search" Form...

Hi, I currently have a database where users input new parts into a database using a part form. When they put in the part type, a tracking number is automatically generated. I would like a folder to be created for each part where we can store pictures and a report. How would i have it create a...

Hi, I currently have a database where it automatically opens a window when you launch the database and asks you whether you would like to enter a new part or search for a part. I have the search part button going to a form where it shows the records but you cant delete them, and you search for...

Hi, I am new to access and have struggled to get to where I am. I am currently creating a form to inout new return parts into a database. I am trying to automatically generate a tracking number (##-AA-####-####). I have gotten myself to generate the ##-AA-#### in a list box and almost was able...