Search results

let me see about moving them to the header or footer. Thank you, I appreciate all the help.

The query shows 19 records, with 15 Yes/No questions shows a check for yes, Null for No - for all 15 questions. it doesn’t show any unique identifier such as an Emp ID or date when the survey was taken It adds correctly the Yes vs No when I created the report by using =Sum(iif( formula. It...

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

I was going to put =if ([checkbox]=True,Now(),Null)

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

They are using the same database, at different desktops. Might be going through a shortcut saved on their desktop.

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?

I noticed when I looked at the properties of the combobox, the AfterUpdate shows Embedded Macro, I know I didn’t put that macro in there...when I click on that it shows Where Condition == “[Name]=“&””&[Screen].[ActiveControl]&””.

Could it be something in the after update if the properties of the combo box. I see a Where Condition =“[Name]=“&””&[Screen].[ActiveControl]&”” the AfterUpdate shows Embedded Macro, when I click on that it shows Where Condition == “[Name]=“&””&[Screen].[ActiveControl]&””

Thanking for responding the only thing in the query is, pulling down the name field from the main table. It shows the O’ last names when I run the query. It shows in the combo box when you want to search by last name, but it won’t bring up the members info down below on the main form, to update...

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?

Sorry... I can read code, but don’t know how to write it or where to put it for it to work :{

It’s not linked. It’s just sitting out on the shared drive I have the command ImportExportSpreadsheet to Export information to the named Excel file. Just need it to refresh the information when needed via macro in access

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 do have one more question, how can I make this DB for multi users? It’s on a shared drive and under options, advanced it shows default open mode shared, edited record.

OMGness... you are genius!! It worked it looks great. Thank you for having patience with me especially not knowing the difference between SQL vs VBA. I REALLY appreciate all your help!! THANK YOU

I am thinking....If primary responsibility equals hotline then run the macro. Alerting them to pick a tier? if that is correct I don’t know how to write it on the macro. can I set warnings off before the if statement?

Ok the message box is coming up, very nice. I honestly think that is what they are wanting. I do see the IF in the macro on click option. What would I put there? Thank you for your patience

Just getting back to work. Let me check... thank you