Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CharlieT302

    Requery dbEngine.workspace(0)

    Hi Everyone, First, I apologize upfront. I originally posted this question within another post that covered different but related topics. It occurred to me that this forum may be more appropriate for this question. Not trying to be repetitive. My question is this. I have a form that I use to...
  2. CharlieT302

    Linking to a Workgroup Information File

    Hello, This originally was one small piece of another post. I am afraid it got lost in the shuffle so I wanted to have a dedicated post for it. I am using Access 2013 but our programs are designed and saved in a 2003 format. I want to be able to link and display the contents of two tables in...
  3. CharlieT302

    Creating User Accounts

    Hello, I have a database that is written in a 2003 format in order to take advantage of user accounts. I need to set up a user form to allow for easier creation of user accounts and to assign them to groups. With this in mind, I have two questions: First, The initial code that specifies the...
  4. CharlieT302

    Using Replace function as Criteria for Dlookup

    Hello Everyone, I am trying to guard against a person entering a duplicate value in a form. I needs this to be done programmatically and not thru the table properties. I can use a simple Dlookup to search for a duplicate value. However, I want to also try to account for typos where an extra...
  5. CharlieT302

    Spell Checking Individual Text Boxes within a single record

    Hello Everyone, I have a form with several text boxes within it. Only two of which need to be checked for spelling errors. I am attaching code to a button on the form so that the user can check the spelling when desired. I have programmatically selected the record prior to running the spell...
  6. CharlieT302

    Dlookup Variable

    Hello Everyone, I used the following code below to avoid having to write out a complete Dlookup formula when I need to reference it. However, the SD code, which produces a date within a series of records, will not display anything at all. As a test, I used the complete formula in conjunction...
  7. CharlieT302

    Open Attachment Dialog Box

    Hi Folks, Does anyone know how to open the Attachment Dialog Box by using a command button, rather than double-clicking the Attachment control?
  8. CharlieT302

    Display a Web Image in a Report

    Hi Folks, THERE MUST BE A WAY TO DO THIS!! Our organization has images on the web (actually, SharePoint server). I have managed to display the images on a form using a Web Browser Control. However, I cannot figure out how to display a web image on a report. A Web Browser Control does not...
  9. CharlieT302

    Populating Combo Box with Files From Folders

    Hello, I would like to have my combo box display a list of files from a folder that resides on a SharePoint drive. I have done this with files residing in network folders without a problem, but apparently the combo box is not reading the SharePoint site in the same manner. Here is my current...
  10. CharlieT302

    Storing Image Paths to Images on SharePoint

    Hi Everyone, I have an Access dbase that we are moving to SharePoint. We are using a Front End on each workstation to connect to the SharePoint backend. The issue I am having is with Image paths. Currently, we are storing the drive and path to images in a table. Our forms and reports use...
  11. CharlieT302

    Multiple Users Accessing Remotely

    Hi Everyone, We have a database that we wish to place in the cloud so users can access it remotely. This, by itself, is not a problem. However, the database contains links to an image folder and a link to another database. The folder and external database would have to be move to the cloud...
  12. CharlieT302

    Using Concatenation formula to set the value of a form control

    Hello Everyone, I need to be able to set value of an unbound control using a concatenation formula. I have a calendar form with 42 unbound controls named as such: M0, M1, M2, M3, and so forth. Out of the first seven controls (M0 thru M6), one of them will begin with the number 1; as...
  13. CharlieT302

    Use Dlookup to set value of a related field

    Hi All, I have a database that tracks the most recent program to which a patient is assigned. The current programs assigned to all patients comes to us via a spreadsheet each month (it must be a spreadsheet. we have no say in this). We import the program names from the spreadsheet each...
  14. CharlieT302

    Looking for Windows Based Policy and Procedure Software

    Hi Everyone, Does anyone have any suggestions for a Policy and Procedure software for the Windows environment? This firm will be migrating to Windows 7, but still has quite a few desktops on Win XP. Thanks
  15. CharlieT302

    Combining Multiple Query Results Into One

    Hi Everyone, I have a table that lists Item #'s in separate fields (fyi: it has to stay this way). For Example: Date Item1 Item2 Item3 1/2/2012 502 201 705 1/3/2012 301 222 725 As you can see, each date contains three Items for a single date. I use a query...
  16. CharlieT302

    Directing Focus to another form field

    Hello Everyone, I have a main form with two subforms. Subform A Contains: Call_Day field: A field containing a numeric entry between 1 - 30 (days of month) Command Button: To direct the focus to Subform B Subform B has 30 fields; each named 1 - 30 in sequence (corresponding to days of a...
  17. CharlieT302

    Dlookup Syntax

    Hi, The formula below is designed to see if the value of a form field exists in a table. The Field in question (Care_ID) is a text field in the underlying table. The name of the form control that references it has the same name as the field and there are no other fields with a conflicting...
  18. CharlieT302

    Allow printing from a secondary router

    Hi All, I hope this is the correct forum for this question. I have two D-link wireless routers. We just attached the second to allow for wireless connections to the Internet from quest visitors (auditors, etc.). The first router connects all devices (printers, computers, scanners, etc.)...
  19. CharlieT302

    Conditional Formatting: Comparing fields on different records

    Hi All, I need to perform Excel-like conditional formatting. If a field value changes from the previous record, I need the field to display in a color. If the value is unchanged, no formatting is applied. Conditional formatting (Access 2007 and earlier) does not provide this feature. I...
  20. CharlieT302

    Bolding "Part" of a field

    Hi Folks, I have an interesting request. I have a drop-down (combo) box that displays identification numbers for projects. It was requested that we make bold only one part of the field so that, when the user opens the combo box, the bolded part of each value stands out. To add to the...

Part and Inventory Search

Back
Top