Search results

Hello all, I've created a small, simple DB to store/track my daily task(s). Each project can have one or more complaints. I will have to run some general tests for most of the cases before I run some specific tests according to each complaint(s) to confirm if the customer was right about their...

Hi all. Table 1 has list of devices with serial/model number and the date of assignment. Table 2 has a list of complaints. User can have a device assigned with at least one complaint or more brought to the shop for repairs/analysis. Table 3 lists the tests they need to run per complaint...

Hi there, I have a bounded form/sub-form setup with navigation buttons that I've created using the Macro methods available to navigate through the records. How do I disable my NEXT button when I am at last record or PREVIOUS button when I am at first record? Macro or VBA? Which one is easier...

Hi All, I hope you all are very well. I have a data entry form created by MS Access 2016. I want to have a combobox that lists different items based on selction of cmb_items (like a castcaded combobox in a countinues subform). I name it cmb_packages and it gets its values from T_packages...

Hi everybody. Please help me on following syntax error. I am using a string variable as RowSource of combo box: cmb_unit. As you can see in the attached image it has syntax error and I couldn't figure it out. Private Sub cmb_items_AfterUpdate() Dim sSource As String sSource = "SELECT...

Hello, I searched a lot and came up with a function that is not working the way I wanted it. I have a simple form with an input textbox (txt_input) and a button (btn_convert) that is meant to run my function and assign the outputs (decodedArray(5)) to my output textboxes (TextBox0 through...

Hello all, I have a simple form in Access 2016. Everything was working as it was supposed to until yesterday. When I changed the property of one of the controls (Unlocked to Locked) in my form and switched back to Form View all my controls were gone. I switched back to design view and everything...

Hi all I have a simple database with a simple table. Table t_projects has a column called serial and four more columns that are called assignDate, compDate (completion date), closeDate and concurrentPrjs . This table can have too many rows but I think it doesn't matter. I need to find the number...

Hi all I have a list of the projects I am working on. They usually assign me a project or multiple projects at any given time. I start working on my project and it takes a few days before I finish my task. Once I finish my task and submitted they have to review my report and close the project if...

Hi, I have a simple bounded form. There are three controls (A, B & F) in my form bonded to three fields of a table. A = Gas price $/litter B = Amount of gas, litter F = Total value of the gas F = A x B Assume user enters the gas price (A) in the first control and amount of gas in the second one...

Hi everyone. I have a parent/child form setup as seen in the attached image. My forms are bounded to related tables. Is there anyway of dynamically calculate the totals for each item and grand total in upper section that is invoice total as user enters the details of each item? I would like to...

Hi I have a master/child form as invoice and invoice_details respectively. I've created a nested combo box that resides inside the subform. This pair of combo boxes are taking their values from two tables. combo_item shows a list of all items and combo_units lists measuring unit of each item. In...

Hi everyone. I am about to start a simple project to save all data from my grocery shopping and/or Gas, Millage and car services in a 2016 MS Access Database. I know some VBA or none-VBA data manipulating in Access. What I am not sure how to do is here: A data entry form saves data in related...

Hello, I have a button to save my data. Before save procedure runs I have a Beep in my code as follows here but it doesn't create a Beep sound. Is there something that I've missed in my VBA code? I also tried to do the same with Macro Builder and got no beep sound. Private Sub btn_save_Click()...

Hi everybody. I have a database that I want to send it to my friends so that they can use it. I realized when I attempt to open it for the first time on another computer this warning appears. I know I can enable it easily by clicking on the button in the message bar but since my database opens...

Hello, I have a report based on a query. Query is in order based on a table. I need one of the fields in my report shows "Not Applicable" when a criteria is met. I used this code in expression builder but it didn't work: = iff("Home","NOT APPLICABLE", [place_detail]) I was trying to say if...

Hello Covid-19 fighters In my report I want to create a graphical representation showing a pointer that points to a multi-color bar according to one of the fields in my report for each record. I realized my report takes the value in the first record for pointer and uses the same value for all of...

Hi everybody. I have a Combobox and I want user to see "--SELECT ONE--" or something similar without adding this item into underlying table before clicking on it to see the rest of the items. Also I believe it makes sense to see all items in the list excluding "--SELECT ONE--" when user clicks...

Hi, Continue working on my project, close to the end I have a new issue with my report. Please help me on this. I have a larger table (Table A) and a smaller one (Table B) that has only 4 fields. Five values that are Foreign key to table A are stored in table B. The way I have my relationships...

Hi everybody, I have a case statement in my project that is not working and I can't see the issue. Anybody can help me please? When I call my function, any number that is assigned to riskRate (for example 1700). goes through case statement function and always executes "Case Else" clause only...