Search results

I set up a delete button on a form, that has five linked subforms. Here is the code I used: Private Sub btnContinueDelete_Click() On Error GoTo Err_btnContinueDelete_Click Dim strPathPassword As String Dim db As DAO.Database Dim strQryDetails As String Dim strQryNotes As...

I have created a command button to email each technician the details of their jobs for the next day. It gives the scheduled time, client's name, address, and contact numbers, and the scope of work required, all in the body of the email. Everything is working perfectly, and as they say, if it...

This one has been a real head-scratcher for me. I keep getting and error message saying "Object required". I have been over and over this a hundred times but can't see the error. Any help would be appreciated. Private Sub btnEMailTechnician_Click() On Error GoTo...

I was just wondering if anyone has tried (and found a way to make it work) storing the BE tables on a cloud drive. I tried it with one of my databases, however, my OneDrive seems to have a permanent "read-only" attribute. When you open the database (the FE is on my hard drive), it opens as...

I posted this earlier but got no response. Can anyone help point me in the right direction please? I used to save pictures related to a job as an attachment in an attachment field. My database grew in size dramatically, so I set up a bound subform on my main Orders form to save each picture as...

I read a reply to a thread by Doc Man about this. I set up a subform to enter the file path for stored documents relating to a job on the main form (as opposed to an attachments field). Should the field be set up as a hyperlink, and what code would you use to open the file to view it? The files...

I posted this about a year ago, and was getting query problems. I played with it and solved the query problem, and then was getting an error message saying "Too few parameters. Expected 1". So again I played with it. As near as I could figure it, Access was having a problem with the Form, so I...

I have built a database for my service business, in which I enter all the service orders as they come in. They come in sometimes up to two months in advance of the actual date of service. When I open the form, is there a way I can open it up to today's service date, or in lieu of no scheduled...

I'm trying to put multiple records of data from a subform in a single e-mail, and my Outlook calendar. I have a contracting business, and on my Orders form (which details a single client), I have a sub-form that lists all the items to be done at that client's home (a different record for each...

Can anyone shed some light on this? I have created an automated e-mail quote for a client database. I have created several strings that make up the body text for the e-mail (some with info drawn from the database fields). Is it possible to have certain strings underlined and bold face? How would...

I have set up 3 combo boxes on a form. They are based on a value list, not a table or query. I have set the limit to list property to Yes, and put the following code into the OnNotInList Event: Private Sub AgtType_NotInList(NewData As String, Response As Integer) Dim ctl As Control ' Return...

I run a small trucking company. I have a table for orders (Deliveries). I know that grouping on a form (like on a report) is not possible, however, is it possible to use a tab control on a form, with 7 tabs, one for each day of the wek, and to populate each page based on the week selected on the...

Hi all. I just joined the forum today. I am a self-taught Access / VBA user for about 10 years now, and have been reading this forum lately for help on some issues. Thought I would sign up in case I need to ask any questions. I am from Toronto, Canada.