Search results

I wish to set up a simple table that will contain: . Person's name . Person's email address . Date at which a form email should be sent to that person I want a program to check each record in the table periodically and send an email to those persons as the send date for that person...

Those who live alone, especially we older ones, who do not have regular contact with someone on a daily basis may want to have some form of automatic notification system in place to transmit a request for help in case they become incapacitated and are unable to reach or use a phone. It is with...

I have a report that summarizes the record content that is contained within a form (one report line per form record). If the user wishes to view a specific record on the form, he clicks on the report control that contains a numeric value that identifies the record on the form. I can get that...

I have a (split) Access database (& Win 7) running on a single office PC but the users now would like to "access" it from home PCs as required. Was wondering if MS Remote Desktop might provide a relatively easy way of providing that. I've been doing some searching but haven't come up with much...

I have a hyperlink control on a form which is linked to a jpeg image stored on the local HD. Whenever I click on the link, I get a Access Security Notice ("This location may be unsafe.") even though I have set the image's file folder to a Trusted Location. Is there any way this message can be...

I have successfully placed an Attachment control on a Form (to display images) and a nice thing about it is that clicking on the image brings up an icon that allows directly adding additional images (as well as selecting which image to display via forward and back arrows). The problem I am...

Am trying to display images on a form in a split database. I add the attachment field to the associated form's table and add the attachment control to the form but cannot get the image(s) to display on the form (the control remains blank). I can add the image(s) in table view (and display...

I have a reoccurring problem with Text Box events seemingly randomly disappearing i.e. the "[Event Procedure]" text disappears from the control's property sheet (for a given action) but the underlying VBA remains. As a result, the specified event does not happen. To restore, all I have to do...

I know how to make a text box entry "required" such that one cannot exit a record until a value is entered but cannot figure out how to make it required only if another field on the form has an entry. None of the form events seem to support that when focus moves to another record as far as I...

I'm getting no-where with this and am hoping someone can help. I have a subform in which I display a table in Datasheet View. The problem is, I cannot figure out how to place the columns in the order (i.e. from left to right) I want. For some reason, right-clicking on a column header in Form...

I have recently been experimenting with adding an Access database to a shared folder (in a network HomeGroup) and have it working on two networked PCs. Then tried the same with the database split but I get a path error on the PC joined to the HomeGroup (where the database resides) whenever the...

Hello all, have just tried experimenting with placing a Chart control within a form (Access 2010). Although the chart ultimately seems to work (based on my one simple example), I'm getting an Error 1907 (Could not register font.......) each time I launch the database or reload or edit the form...

Hello all (haven't been here for a while). I have recently added a subform to a form and wish to display the subform in Datasheet view. Whilst I can get the proper data and headings to display, I cannot figure out how to get the column widths to persist. I can adjust the column widths while...

Posted this on Mr Excel/Access forum a while ago with no response so hoping someone here can help. My Access 2010 developed database has a problem when a particular form is switched to Design View from Form View when running under Access 2013. I get an "MS Access has Stopped Working" error...

I have an embedded macro (in a form) that duplicates/appends the current record displayed by the form and I would like to add a bit of VBA code to the macro (to increment a text box value on the appended form). As I understand it, this can be done by the RunCode macro command in which a Function...

Can't figure out the syntax for specifying a null value for a text or combo box when filtering a table via a form. "Is Null" seems to work for query criteria but doesn't work for form controls. If one right-clicks on a form control displaying a null value, one of the choices is "Equals Blank"...

Tried a couple of questions on the MrExcel forum with no response so far so though I might post them here also. First is: The only way I can figure out how to launch the Query Wizard by a button click is to use a SendKeys macro. I have looked at other macro commands but there does not seem to...

I thought this would work but it doesn't - would appreciate any assistance. If one has text boxes or combo boxes on a form and wishes certain text to appear in a box when the box gets focus, how is this done? I have tried placing (for example) ="123" in the On Got Focus property of the box...

I have just discovered one can "lock" (if that's the correct term) a database, such that users cannot modify it, by changing the file extension .accdb to .accdr. This works well but, I cannot figure out how to let users still get access (so to speak) to the Query Wizard. The closest macro...

I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not...