twinnyfo - Works perfectly! Thank you, and I might have some more questions coming your way as I work through this project. You guys rock!
NeoPa - You've been at this for a long while... you helped me a few years ago on a project in the Netherlands. Thank you!
jdusn1978
Last Activity: Dec 5 '18, 08:55 PM
Joined: Feb 24 '16
Location:
-
Twinnyfo, thank you for replying. It's whiskey:30 here in Germany; I'll take a noob crack at this in the a.m. and report back. I very much appreciate all of you. Merry [your views]mas.Leave a comment:
-
jdusn1978 started a topic Query: Convert text to date, display records older than 60 days from Date()in AccessQuery: Convert text to date, display records older than 60 days from Date()
Goal: Convert text to date in a query and show only dates that are older than 60 days from Date()
I’ve searched the site and nothing quite matches what I’m looking for, at least in a way I can comprehend. I can read VBA and SQL at the about the level of a very skilled orangutan.
I’m automating an Excel process using Access. I import Excel files (using DoCmd.TransferS pread…etc) and want to utilize a column... -
NeoPa,
Your answer not only fixed this problem for me, but also led to answering a bunch of other problems I was having. I now have a better understanding of these above issues.
Thank you for your time Sir!
And thanks to all of you for doing what you do here. Much appreciated!Leave a comment:
-
Exclude carriage returns from expression if they are not needed?
Hello,
Note: Can not use code on my system. Disabled Mode will not be enabled for me.
My query pulls data that requires carriage returns if there’s data, and no carriage return if there is none. How do I write a concatenating expression with carriage returns, but skip the carriage return if no data precedes the carriage return expression. I’m asking in order to eliminate white space in the query return due to a... -
Phil/NeopPa,
NeoPA, I think you’re right. You saying carriage returns made me think, the original data I’m trying to pull in is created using concatenating strings from other sources that include Chr(13) & Chr(10).
I’m really out of my depth there and probably wrote those poorly as well. And, I’m not leaving info out on purpose, just not sure how to correctly speak the lingo. BTW, this project...Leave a comment:
-
Phil,
Thank you for the reply; however, both ways you suggested is still giving me the blank space any time the proceeding column expression is blank.
The memos are created via an IIf query. If I change the IIf query to Else False instead of Else being Null, all those empty lines are turned to 0's.
Does this mean something? It seems like it is not TRIMMING because it's actually empty, it just appears to be....Leave a comment:
-
Ignore blank columns and line space in query return?
Memos Query - sort of looks like:
Expr1: MainTable.ID (the link between tables)
Expr2: Table2.Memo
Expr3: Table3.Memo
Expr4: Table4.Memo
Expr5. [Table2.Memo] + [Table3.Memo] + [Table4.Memo]
I've tried writing Expr5 as IIf, Is Not Null, IsNull etc and nothing works to remove blank space in Expr5 column
Example of how it looks now if Expr2 is blank:
Top of the textbox... -
Phil,
The point of this database is that users on my left have questions and the people who can get the answer are on my right and need to receive the questions. I’m in the middle to facilitate this transaction and creating a database to help me make it happen easier. I don’t want to have to do everything myself, its 475 different combinations. This is just one part of what I’m working on and it looks like this.
Combobox...Leave a comment:
-
jdusn1978 started a topic Macros, VBA, etc disabled. How to call 1 of 19 subforms from a main form combo box?in AccessMacros, VBA, etc disabled. How to call 1 of 19 subforms from a main form combo box?
What is the best way for the main form combo box to bring up the correct sub-form of the 19 available?
The main form has a combo box called [cboCategory] which has the options of selecting Category 1-19. When creating a new record, the data entry user selects, let’s say, Category 3 from the combo box. I’d like the sub-form for Category 3 to appear in order for the user to finish the data entry. I’ve thought about a filtered... -
Just found out I cannot use this. My network has macros and functions disabled :( Going to have to ask some new questions.Leave a comment:
-
Thank you and I'm looking forward to trying this tomorrow. I think you did understand. CboboxID was just a fake name I used an an example for a combo box that has 19 selections to chose from in the drop down on a form. Chkbox1 through 6c all represent an option that I need to verbalize in a report that gets forwarded.
Say the user selected cboboxID option 4 from the drop down. The 4 is theprimary ID for category "Water pipe fittings"....Leave a comment:
-
Convert large IIF Expression into a Function.
Convert large IIF Expression into a Function.
cboboxID has options 1 through 19. There are 25 chkboxes. The text behind the 25 checkboxes would change slightly depending on the cboboxID selected.
The point of the function would be to return text to fill a memo field/textbox in my database by translating the combination of the selections made from the cboboxID, the 25xcheckboxes and 1x freetextfield into text that gets... -
jforbes,
Thank you for the answer and I've looked into implementing your instructions; however, I am not at a level to full comprehend how to do this. Would you mind, if you have the time, pointing me in the right direction or walking me through how to create this function.
Than you in advance!Leave a comment:
-
How to: Combobox text inserted as part of a texbox standard message.
I have a textbox on a form with a standard message that has a few blanks in it. I want to be able to fill in the blanks based on text from combobox selections.
ComboboxItem select options are: TrainingBook 1, TrainingBook 2, TrainingBook 3.
ComboboxLocatio ns select options are: Northern Region, Southern Region, Eastern Region, Western Region.
The standard text looks like: Thank you for ordering _________... -
Yep, I was over-complicating your reply. Got it to work in a query, not the actual Memo Field in the table. There I get error 3344 "does not recognize [1LoctionType].....". So I am thinking of using it in an Append Query to the memo field. Or to a textbox that can be manipulated further and saved to the memo field upon update. Any suggestions?
And the next step is to learn how to format these sentence returns with certain...Leave a comment:
-
Thank you. I'm at work and utilizing your answer; however, I get "Some standard Blurb" in the textbox on a practice report I created no matter whether Column1 is checked or not.
Here's my set up:
tbl_CategoryAir fields
Fields: Datatype: Description(tex t I need)
1LocationType Y/N Determine location & type of AF
1aConfirmLocati on Y/N -Confirm location via gecoords...Leave a comment:
-
How do I set a checkbox to equal a text value?
Question: How do I get the Y/N checkbox fields to display a set sentence of text in a report? Or better yet, into another field such as a memo field?
Super noob here. On a scale of 1-10 being how much I'll understand your response, I'll probably be between 2-6 depending on how complicated your answer is. With 6 meaning I will probably still have trouble understanding answer even if very basic. But I'll appreciate your time and answer...
No activity results to display
Leave a comment: