Search results

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

Greetings, I’ve a login form that users have to input username/password to access the DB. However, here is some scenarios that I’d like to enhance the code to avoid the following error: 1. If an invalid username is entered, I get the following error: Run-time error ‘3021’ No current...

Colin, Many thanks for the solution you provided! Regards,

ridders, that’s correct the second column is the AnalystName and both first and last names are stored in this field. So Column(4) now should look like as follows, correct? Email: Left([AnalystName],InStr([AnalystName], " ")) & "." & LCase([AnalystfirstName] & "." & [AnalystLastName] &...

ridders, I’m not sure if I followed your instruction correctly but following is what I have: Expr1: Column(4) Criteria: Email: [AlalystID]]" & "@CompanyName.com" When I attempted to run the query, I get the following error: The expression you entered contains invalid syntax. You may have...

ridders, thanks for the reply post. The row source of cboAnalyst has the following: AnalystID AnalystName Password (criteria: like “ad”) Status:(criteria: like “A”) However, the e-mail address is not stored in a table. Is it possible to modify the code you provided such that if analyst1 is...

I’ve the following combo & text fields: 1. cboAnalyst (dropdown) analyst1 analyst2 analyst3 2.txtAnalystEmail (text field to enter e-mail address) Depending on the selection made in cboAanlyst dropdown, I would like the txtAnalystEmail to auto populate the analyst’s e-mail address. e.g...