Search results

Hello… love this platform, question I have a database setup to key in surveys which some questions are Yes/No. As of now I need to report results of 19 surveys. A report has been setup to count the Yes vs No questions - with a calculation showing % favorable, on 2 pages. Great! The issue I...

Hello, I am needing help with a request. I have a form that has a checkbox along with a date field. I am needing the date field to automatically populate with the days date, if the checkbox is marked. Do I put a formula in the after update of the checkbox property?

Hello... I have been tasked to create a database. On the form I am needing to filter out records by location and type employment to bring up a record. I have the location combo box, but stumped on getting another combo box, type employment, to filter the records. I don’t have a programming...

Hello... is there a way for multi users to be in a database at the same time? Receive the message box “can’t open exclusively” is there away to get in there, without receiving that message?

Frustrated.. I have a form with a combo box lookup, pulling from a table names. It not bringing up last names that have a ‘ such as O’Daniel. I am not a programmer but know how to work behind the scenes. Please advise. Can I put something in the properties of the combobox?

Love this website full of great information... I am trying to update an Excel spreadsheet through an Access Macro that is saved on a Shared Drive. As of now in the macro I have ImportExportSpresdsheet, but it doesn’t override the last spreadsheet. It’s creating a new tab on the spreadsheet, and...

I have a form that I am needing to add a message box it a certain item is chosen from a combo box, without using SQL. I have the form open in design view, in the property of the combo box field. Any help is very appreciated!!

I am needing to know if there is a way, you could bring up a scanned document in Access by Employee ID via link on a main form. The document would be saved on a shared drive. Any help/assistance is greatly appreciated

Creating a form, one field is a combo box, either available or not available. Need to have another field to automatically update to yes or no based on the combo box. I do not know SQL. Any guidance is very appreciated.

Two tables linked on employee number, one shows employee info the other employee picture. Employee information table is imported into the database, which is the main form. Pictures have been uploaded, this is the subform. As of now the sub form only shows the pic as bitmap image, when you click...

Hello...looking for some guidance... I have an Excel spreadsheet that is printed out like a coversheet. It's fed off a query that is export out, feeding different cells on the coversheet. Is there a way to import the excel coversheet into Access, having it feed off the same query.

Hello...needing to ask a question regarding sharing a database with multi users and the same time. Db is located on a shared file folder. Checked the client settings, it is marked as shared. But it will only allow one user in. Please advise

Hello...love this forum, very useful information. I am working on a MTQ and need to share the information with others, without having it linked into another database. Thought about the ImportExport command in a macro, but it tends to not refresh the data on a shared file folder. Please advise.

Created subforms, via multiple tabs, tracking various catergories on main form per employee. Department would like them to look more like spreadsheets to see all records for each catergory per tab, but have drop down boxes per column. Is this possible?

Hello....I am needing to know how to have a date field automatically populate with the day's date once a checkbox is checked. Please and Thank You!!

Hello. Having issues with a table with Phone Number field, which is programmed to include 0 at the beginning. I am needing to remove the leading zero through a update query, leaving 10 characters instead of 11. This field is a short text field in the table it does have a input mask of...

Hello...i have a form that needs to be programmed to fill a yes/no field automatically by a selection made from a combo box of another field. If nothing is chosen, then the yes/no field will remain empty. Would like to put the programming statement in the design view control source in the yes/no...

Hello, this is QueryStumped from KY. Avid Access user, love it. Not a programmer, but able to create and maintain databases, queries, reports, and macros. Recently stumped on a request, visited several websites/blogs. Need to parse name field. Comes in as LName,FName MI. I need Last Name and...