Search results

Hello, I have a report that needs to be emailed to specific email addresses for each record as the table is updated. I have 2 tables, one called tblAuditInfo and one called tblSupplier. I have an input form called frmAuditDataEntry. I also have a report called Receiving Audit. My goal is to...

Hello, I have 2 issues that I need assistance with. First, I want to have the text box clear out if the incorrect info is input to it. I have tried Me.Location = "" and Me.Location = Null after the message box, neither of which seem to work. I also have the below code and need it to stop when...

Hello, I have a report that I need to be able to adjust the qty of the copies printed using a textbox on my form. I have the below code that works flawlessly for a set amount of copies. sometimes I will need to print 1 copy and sometimes I will need to print 2,3,4,5 etc. the text box on my form...

Hello, I am working on a simple database to do a physical inventory in a warehouse. I have a table with 3 fields, PartNumber, PackageID, and Location. I have a form where the user will scan the data from each package linked to those fields on the table. The barcode data that they will be...

Hello I have a form that I created to enter some data and them have a report print out when you click a button. I have the following code in the button. Private Sub Command20_Click() Const MESSAGETEXT = "No current record." Dim strCriteria As String strCriteria = "ID = " & Me.ID If Not...

Hello, I am trying to get a total amount in the footer of my report. I have a calculated field called txtGCTotal that has the following expression: =IIf([NotEligible]=False,50,0)+(Nz([SumOfPointAmt])*2). I have tried adding a text box in the footer with the expression =Sum([txtGCTotal]) but it...

Hello, I need to build a form that includes data from a query but need it to do a calculation when it opens. Fields I need to have calculate are SumOfPointAmt, and NotEligible. NotEligible is a yes/no field. What I need to do is have the form look at NotEligible and if the value is No, return a...

Hello, I need to create a tab control with a search box where the user will put in a portion employee name or ID number and will return with a list of possible employees. once the correct employee is selected, I want the subforms on the tab control to carry the employee information to add new...

Hello, I have created a database to track a safety incentive program. within the database I have several table to track different things. I have set up a form to search the Active Employees table, and when you select their ID, it stores a Temporary Variable and puts it into a specified...

Hello, I have used Access in the past but it has been several years and I didn't keep up on my skills. I have been tasked with creating a database that will have multiple uses such as tracking Employee "points" for an incentive program, as well as tracking near miss information. I will most...