Search results

Hi all So in the screenshot below is a form users use to add new company information. The organization I'm with is a local community college and they monitor which companies work with the college. Certain companies or agencies if you will, will accept students from certain programs. E.g...

Hi all I have a split form where the top half displays some agency information and the bottom half is a datasheet that contains records with more details. I have a form button for users to add new records and when I went to fill one out, I hit save, then close on the form but whenever I try to...

Hi everyone So I'm working on an access database and I've saved two copies. One is read-only, the other is the copy I've been working on. They're both on the same drive, just in separate folders. I know this should be split, but for the time being I just copied this database for my supervisor...

Hi all So previously I had a form with a combo box that when the user selected an item, a report would open displaying all the records that carried that field item (in this case, agencies that use a particular program code). It worked nicely, however now I need to allow the user to make...

Hi everyone Just out of curiosity, is it possible to change the text in the prompt message? I have a form where users fill things out and I set this particular field as required. If the user forgets to add a value, they are prompted with the message "You must enter a value in the...

Hey guys, I have this query that nicely associates and displays information between two tables (tblAgencyInformationNew and tblProgramCodes). I turned this into a report and now working on a form where a user can select an item via dropdown. At first the user can click on a button and the...

Hi all I have a form with various fields and a number of default values (e.g. 'N/A', '000-000-000', etc) How do I make it where once clicked in the box, those defaults automatically disappear rather than highlighting them and deleting?

Hi everyone So awhile back I was splitting up date fields in Excel. In the beginning there was two date fields. The first was called"AAStartDate" and had either blanks or a date entered. The second"AAEndDate" had either a date or the word ongoing entered. I added a third table called...

Hi guys Just need a little bit of clarification. So presently I have this database that I split up and just to be clear, I know that when you split a database, Access adds "_be" meaning back end but is this where developers work or users interact with? Because when I open up _be.accdb all I see...

Hi everyone, So before working on access, I had an excel file and did some clean up. A couple phone number fields were entered in a bunch of different ways but I made it where all the numbers are are stored as XXX-XXX-XXXX and put 000-000-0000 in any cells that were empty. When the user goes to...

Hi everyone Just out of curiosity, is it possible to program a button to display record count (e.g. 1 of 5)? I know this can be done on the form, but maybe just to save a user an extra step, would this be feasible? I should mention though that this form displays information for different...

Hi everyone So here's my dilemma. I have a datasheet in split form view that displays agency information (agency name, subsidiary, address, city, etc). I have a button for adding new agencies and form opens up with various fields for the user to fill out then hit save. When I look to see the...

Hi everyone Below is a screenshot of a column called "Codes" on a report and as you can see, some of them are separated by commas. Is there a way for me to display these point by point (code by code) on a report? E.g. 0008 '1077 '1165 Any thoughts or suggestions are welcomed and...

Hi everyone So I'm back from a brief hiatus and upon opening access, I noticed something very odd. I have a datasheet in split-form view and it's data is based off a query which extracts a number of columns from the main table and one of the date fields called InsuranceExpiryDate is displaying...

Hello everyone, I have a datasheet in split-form view and a search bar that filters based on whatever the user types in and I'm happy to say works very well. I have attached the SQL of the query this datasheet uses. So as you can see from the screenshot whatever the user types in is based on...

Hi everyone So I have this datasheet with two expiry date fields (affiliation agreement and insurance expiry) which are totally independent of each other as well as a column with yes/no values. I was told I need to make a report criteria based on these three things. Thus the user needs to...

Hi everyone, I know this is similar to a post I've created before however things are slightly different now. Basically I have a form in splitform view and all i have right now is a search bar that filters based on what the user types in. However I would like to add a combo box with 2 column...

Hello everyone I have a datasheet in split form view. I've added some functionality to it by including a search bar that filters the datasheet based on whatever the user types in. As well as two combo boxes that filter the datasheet based on whatever the user selects. Everything works fine and...

Hi everyone So I have a datasheet in split form view. One of the columns is called "WSIB Employer Declaration Complete?" and is has values yes or no. I'd like to add a combo box where the user can select either yes, no or all and based on their selection retrieves either, the records where WSIB...

Hi everyone So I have a datasheet in split form view with 6 columns visible and I have a search box that filters as you type based on data that's in all 6 columns (e.g. user types in "smith" and the query looks if this is present in at least one column and gives me back records where this is...