Search results for query: *

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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.)...

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...

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...