Search results

  1. C

    Set Combo's displayed value to a control box in a form

    Hi, I have a Combo Box that has as it's Row Source only two choices: 1;"Spring Startup";2;"Winterize" The width of the column widths are 0; 1.5, so you will only see Startup or Winterize I have a Text Box called MonthNbr that has as it's control source: =IIf(DatePart("m",Date())<=7,1,2)...
  2. C

    Can't Get +Chr(13)+Chr(10) to work in a report, (Return plus line feed)

    I have a text box that has the following code in it. After a field, I want a "carriage return and a line feed" to put the next field on a new line. If I leave off the "&" before the +Chr(13)+Chr(10) when I run the report, that text box shows a #Type. If I leave remove the "&" before the...
  3. C

    Create Folder using field data

    Hi, I have some code that works, but I need to tweak it to create a folder that uses the data in a field as the folder name. Here is the code that works, (Note, ignore the MsgBox entries I've used for testing): Dim fs, cf, strFolder Dim DestPath As String Dim SrcFile As String...
  4. C

    Need help figuring out best way to allow customers to respond to an email and get in Access

    Hi, I built an Access application for a customer of mine that is doing a great job. My customers business has grown from about 600 customers to over 2,300. Twice a year he sends out an email to his customers reminding them that it's time for a service call. The email is specific to each with a...
  5. C

    How do you stop the event order?

    I have a Combo Box that its "Limit to List" is Yes. If the user attempts to enter something that isn't in the list, I produce a MsgBox that tells them that. For that same Combo Box there is an "On Change" event that runs a big macro. When I look at the Event Order, it is: KeyDown, KeyPress...
  6. C

    Use the same report with different query's

    Hi, I want to use the same report with different. If the user is on Form "A" and they click on a button it will use: Private Sub Command105_Click() Dim WhichQuery As String WhichQuery = "Invoice Query-3-Bulk-Reinvoice" DoCmd.OpenReport "Invoice Report-BulkTest", acViewPreview...
  7. C

    Go to the last record minus 5 records on a continuous form

    I have a continuous form and when it opens, I would like it to go to the last record, (or a new record), minus 5 records. I'm trying to make it easy for a user to add a new record yet when you use Go To New when a continuous form opens, you see at the top of the form a blank row to start...
  8. C

    Need to filter rows on a Continuous Form

    I have a continuous form. The form displays rows from a query. An important field is the WorkNbr, which is a number field. I need to find a way to display only one WorkNbr row if there is more than one WorkNbr in the Query. I can't use a Totals query because the user needs to input data into...
  9. C

    Change certain Excel row 1 cell values

    Hi, I'm writing VBA code to import a spreadsheet. Row 1 has the field names in an Access table. It works fine except there are 6 columns in row 1 where I need to change the name because they either have a period in the cell or the cell is a duplicate from an earlier column. A portion of the...
  10. C

    Insert contents of HTML file into Outlook body

    I have a HTML file, “Trip Report-Email.html”, that I would like to insert into the body of an Outlook email message. The html file, “Trip Report-Email.html” is generated by exporting an Access report to an html file. When the email gets sent, I want the email recipient to see in the body of...
  11. C

    Move sub-reports

    Hi, I have a report with a text box that expands and contracts based on the amount of data it displays. It's Can Grow and Can Shrink are set to Yes. Immediately below the text box in the design view is a sub-report. I would like it to closely follow/be immediately below the text box and move...
  12. C

    Requery Control on Continuous Form

    Hi, I have a Continuous form. On each row there are two fields important to this question. One if a Option Group and the other is a date field. At the bottom of the form is an unbound text box with the following control source: =DCount("*","[Count Work Completed]"). The DCount works...
  13. C

    Frame on subform won't update

    Hi, I have a form with a sub-form on it. The sub-form is not bound to the parent/main form. The sub-form only has one contol on it, a Frame with three option buttons. If the sub-form is opened by itself, I can pick any of the three option buttons. If I place the sub-form on a blank form, I...
  14. C

    Capture Word file location

    I am using Access 365. I have a form with a command button on it that opens a Word document and takes information from the form and places that information in the Word document using Bookmarks. It works fine. What I would like to do is when the user finishes editing the Word document and is...
  15. C

    DLookUp with criteria isn't working

    I have a query that has a DLookUp function in it with criteria but it's not producing the results I need. The DLookUp is- TEST:DLookUp("LaborRate","[Locations]","[Location Code]='" & [RepairLocation] & "' AND '" & [VendorReferenceNo] & "' Like [InvPrefix] & '*'") [RepairLocation] and...
  16. C

    Need to determine if SharePoint connection is down

    I was observing a user of the db I built and saw something I didn't consider. I'm using Office 365 for Business and the Access front-end connects to SharePoint lists. The user clicks on a command button which starts vba code to do several things and towards the end, runs an append query. The...
  17. C

    A better way than a bunch of If-Then DLookUp's

    Hi, I have some VBA code that runs when a form opens. The purpose of the code is to make visible or invisible 17 different Command buttons on the form. The reason for this has to giving certain users the ability to run certain reports and other users they can't. It takes a couple of seconds...
  18. C

    Combo box that doesn't display values already used

    My brain is fried and I'm drawing a blank. I have a single form that has a subform, which is continuous. I want a combo box, (on the continuous form), query's all of the values from a table/query. After the user selects the value, like maybe "Boots", I want the AutoNumber for "Boots" stored...
  19. C

    How to update/distribute Front-end Clients with Sharepoint

    I built an application for a client that had three remote sites. The Access front-end database runs on the local machines, (main location and three remote offices), and the data in the back-end is on a SharePoint list. Now, when I need to do updates on the clients front-ends, I'm wondering how...
  20. C

    Updates to front-end and impact with SharePoint tables

    Hi, I've developed a database and split it into a front-end and back-end databases. I then from the front-end exported the data to a SharePoint list. The reason for this is that there are three remote locations plus a main-office location for this application. It is my understanding that the...
Top Bottom