Search results

Hello, Compact on close is asking for a password all of a sudden When I enter the password, it doesn't accept it Opened the DB exclusive and entered password, says its invalid When I open the DB normally and enter the password, it accepts and opens. Would appreciate any suggestions on how to...

Hello, I have a form with a macro that updates certain fields on it when I press a button. I want to make a related update to another table in the same macro. How do I do that? Thanks

Hi, Don't know how this happened but during a brief period (3 months last year) these duplicate primary key values got created with legitimate field values. 140 records with 70 duplicate primary key values. The table in question has a primary key and 2 foreign keys. Two questions: 1. How...

Hello, I've built a CRM using Access 2010 I store a hyperlink (from gmail) to retain the email exchanges with clients Now I have Access 2016 on a new machine I can still get to an email via the hyperlink using Access 2010 but Access 2016 truncates the hyperlink (the lowest level) thereby...

Hello, I'm not a VBA guy and am limited to using access macros. So I'm requesting guidance with the following (if its possible): The user is on form 1 I need to invoke form 2 invisible to the user after he clicks a button Fill in certain default values on form 2 and save it Thanks,

I can never seem to get this right so if someone can kindly direct be to a resource, I would really appreciate it. What I'm trying to do is: 1. Have a list of cities and a list of communities within each city. 2. When entering a contact, I want to choose a city from the City table and be...

Hello, I'm concatenating the values of two fields (one is text and the other number) into another field (text). I have the receiving field set up as calculated. The formula I'm using is "IIf([unit]="",[House Number],[Unit] & "-" & [House Number])". The error I get is "the expression could...

Hi, This may sound as a dumb question but I need to have Access 2010 running as a live process where actions are taken (e.g. email sent) when events occur (e.g. date reached). The application I have in mind is a simple Customer Relationship Management (CRM) application which is perpetually...

I have a table called FAMILY which is at the top of the relationship chain. When I add a new FAMILY via the form associated with it, I need to determine that the family doesn't already exist. Which control can I use (and how) on say the NAME field, that would list for me all the names that match...

I have a form with a table and 2 list boxes. The table is a child to the 2 tables the listboxes pertain to. Selecting a value in the listboxes populates the selected fields in the table on the form. It all works as expected EXCEPT After the record is added to the table and the next blank one...

Fairly new Access user; finally figured out my data model - a simple one; created all the tables (5) and relationships; cleansed and imported my data from excel and it looks pretty good; I can't for the life of me figure out how to develop a custom form (unlike a typical Access form with...

I'm in Toronto, Canada; run a small business; fairly new to Access; enjoy woodworking; cheers