Search results

Greetings, I'm supporting an a 2016 access db that was designed by someone else. The requirement is for me to add a new drop down field with in a tab in the form. The name of the tab is pgeFinancial and the drop down field I attempted to create is called disposition with items like guilty...

Hi, I tried =[ComboboxName].[Column](#) but it wasn’t doing anything. After watching the video link provided by Uncle Gizmo ‘Get Info From a Combo-box” http://www.niftyaccess.com/combo-box/, I changed the column count and the column width of my combo box, and it’s working nicely. Thanks a...

Greetings, I’d like to auto populate a textbox (txtDAUEmail) based on selection made in a combo box (cboDAUNM): If John Doe1 is selected from the combo box, then the textbox should auto fill the analyst’s e-mail address. e.g. John.Doe1@emiladdress.com I changed the row source of the combo...

Hi, After reading the 'Query Join Types' link provided in this forum, I revised my query to get the expected result. Following is what I did: 1. deleted the default join 2. dragged SUSPSTAT from left table to the ID field in the right table 3. edited the join property and selected the...

Colin, Thank you. I can ask for permission from my supervisor and try to put something together for you to take a look. Is there instruction and/or sample db to show how to post a sample db? Regards,

I changed it to list box and nothing showing for row source. And, row Source Type: Table/Query. TIA Regards,

Unless I'm looking in the wrong place, attached is what I see while in table design view. I also included datatsheet view for tblSUSPSTAT. TIA Regards,

tblSUSPENSION Field Name: SUSPSTAT Data Type: Number Value: 1,2 tbsSUSPSTAT Field Name: STATUS Data Type: Short Text Value: open, closed Someone else designed the DB (no documentation). How can I check to see if this is the case? TIA Regards,

Colin, In the attached screenshot: 1. When the default (1st) option is selected, the query run fine & I was able to access SQL view. 2. When I selected the 2nd or the 3rd options, the query didn't run & I was unable to access the SQL view. Instead, I got the error. Please let me know if the...

Collin, thanks for the useful link. Actually, I’ve only the two tables I’ll try your suggestions and post back if I get stuck. Regards,

Thank you everyone for your input. TheDBguy, you are correct in that few cases were empty (status = blank). This explains why I get fewer records every time I added a new table to the join. Also, I tried changing the join to the 2nd and 3rd option, but got the following error: “The SQL...

Greetings, Given my tables tblSuspension and tblSuspStat I tried to create a query to show open and close suspension cases. SUSPSTAT in tblSUSPENSION is a numeric data type (1 & 2) whereas STATUS in tbl SUSPSTAT is a text data type (close & open). It was requested to display the text value...

CJ_London, Thanks for your solution. It worked nicely! Regards,

Greetings, I am trying to find out how many CODE that start with 772 exist for a given day. In my query I used CODE Like “772*” which gives me part of what I want. What I’m looking for is the number of CODEs per a given Date. Please see the attached sample and let me know if you have...

Thanks DOC, I thought I included the renaming part in my previous post Please let me know if I miss any steps. Also, the INSERT INTO query is to populate the data to the copied (structure only) archived table, and the DELETE query is to remove old data from the original table, correct? TIA...

Thank you everyone for your input to my question. Colin, I was informed the method you outlined, and upsizing to SQL was discussed before I got here. But, it was decided to go with archiving instead for now and look into replacing ms access DB with another more robust case management DB...

Greetings, A former employee developed a case tracking (ms access 2016 db) that is getting bigger in size. The management inquire about archiving those cases (along with attachments) that were 'closed' prior to 2016 onto a removable HD and delete them from the DB. Moving forward, do the same...

Hi, Many thanks, it’s working as planned now... Regards,

Thanks Colin, I do not get the error now. But, is it possible to enhance the syntax just a bit? Please see my comments along w/ screenshot summary of my test result in the attached document. TIA,

Thank you both for the reply post along with very helpful links. ridders: I tried your modified code w/ error trapping and tested the login form and I got: Compiler error: Sub or Function not defined (screenshot attached) The error occurs even if the username is valid etc. and the only way...