Search results

In the database I'm working on, the user has a daily log on a continuous form that encompasses some routine activities. For example at 6am every morning they report to work and at 4 4pm every evening they check out; at noon they eat lunch etc. I want to have a button that autopopulates the...

I needed a button to send information from the text fields in a form as the body of an email, and then attach the attachments that are in the attachment field "IssuePics." I have read hours of forums and found the code that turns the text fields into the body of the email, and I thought I found...

I have a bound continuous form that has a form filter on load that filters the control workerid that is set to "WorkerID = 2." I want to have a button that filters another control (StartTime) by today's date while still maintaining the initial filter. I thought the code would be me.filter...

I have a continuous form for scheduling that I want to be able to add to the outlook calendar so I created a button with the following code: (isappthere is a boolean function) Dim myReply myReply = MsgBox("Do you wish to add this appointment to your Outlook Calender", vbYesNo) If myReply =...

I have a button that opens up a form with a dlookup function that automatically fills out the fields in that form. I have attached a sample DB to save time explaining. SectorF contains a list of Stations, double clicking opens up the StationF which contains a list of buildings. Double...

Users are viewing a record on a form that gets it's data from a query. I want to make it so that if they edit that record from that form, a last updated field will timestamp the date/time that the record was edited. I added a lastupdated to the source table which of course adds it to the query...

Users are viewing a record on a form that gets it's data from a query. I want to make it so that if they edit that record from that form, a last updated field will timestamp the date/time that the record was edited. I added a lastupdated to the source table which of course adds it to the query...

I have a label inside an attachment box on a form that tells the person using the form how to attach a file. I want that label to disappear if an attachment is added. I entered this code in the form current event and it makes the label disappear even if there is an attachment. Is it in the...

I created a button that will generate a report in pdf format and I want the form to remain hidden but I want the outlook email to open up with the pdf report attached so that they can just enter whatever email they want to send it to and click send without even having to open up outlook. I...

Table 1 has FieldID1 and FieldID1Name Table 2 has FieldID2 FieldID1 Field ID2Name Table 3 has FieldID3 FieldID2 FieldID3Name Table 4 has FiledID4 FieldID3 FieldID4Name The form for table 4 contains a button that opens another form where the values for FieldID1 FieldID2 FieldID3 and...

So I only want certain buttons to show up after a record is saved. I entered the following code and the buttons stay on the screen even if it's new. If Me.NewRecord Then PrintWorkOrder.Visible = False WorkOrderComplete.Visible = False Command54.Visible = False...

I'm trying to have an unload function that makes sure the user wishes to leave the form before it automatically resets the information in case they accidentally hit the exit button. But every time they hit the button it resets the form BEFORE it displays the message. Here's the code I have in...

I'm trying to figure out how to stop my database from trying to load access in design mode before it goes to my startup menu. I borrowed macros from a database just to get this far but I don't know how to make access go straight to the main menu rather than load the design mode and then go to...

I'm trying to filter a continuous form with a filter using a checkbox where when you check the checkbox it applies the filter and when you uncheck it, the filter is taken off and all records are shown. But I can't get the check = false to take the filter off. Private Sub Check19_AfterUpdate()...

The last thing I want to do for the DB I'm making is create a report that shows me the products, quantity of each product, and cost of materials I used through the whole year. I attached the query view with the tables I'm using. To calculate the year, I figured I could sort the aggregate query...

I wanted to send a copy of a report in pdf format to an email address and I thought the code would be: DoCmd.SendObject acSendReport, "WorkOrderFinalR", acFormatPDF, "email@email.com", , , "New Work Order TEST", , False And it works, except it sends me all of the reports, not just the one from...

I created an aggregate query to feed a report that I want of all products i use in a year and a total price for all products. I used a sum function of the line totals in a text box to display the total expenses for all products, but it keeps giving me an #Error message. I attached the pictures...

Good day all! In the DB I'm building, I have a field in a form bound to a table where I want users to be able to attach a picture; however I can't use an attachment because the user who submits the form may delete or move the picture. So I thought about using an OLE object that saves the...

I'm creating a work order db where users can submit work orders for different problems. I would like to create a button where they can attach a photo of the problem if need be that will be bound to that particular work order record in the work order table. I have no idea where to start. Any...

I have a listbox with a doubleclick event that opens up a record. Then only way to delete that record is by opening it up from that listbox and then using the record delete function on the form. I don't want to create delete buttons so that if they decide to delete a record the deletion is...