Search results
-
A
Need a new page for each record
Thanx Arnelgp... I'm a new kid on the block & just learning the rules. I didn't know about closing a thread. Actually, I used your code & it not only solved my problem but showed syntax that mirrored the 'Case - Endcase' logic that I was familiar in a previous programming life. It was a huge... -
A
Need a new page for each record
Yep! All good.. Works in Print preview Thanx -
A
Need a new page for each record
Testing a simple report for a new page for each record. 'Force new page' is set to 'before section' in both Prefix and Detail headers? What else do i need to do? Thanx Al I -
A
Solved Problem creating greeting for a letter(access report)
Hey Larry That was my first idea but the board of the Friends of the Library didn't go for it. This looks like the end of this discussion. My problem is more than solved. Code supplied here worked without a hiccup AND i have had several suggestions that will lead me to explore other Access... -
A
Solved Problem creating greeting for a letter(access report)
I understand & agree .., is a UDF in Access sql or vba or either? & I'm not sure where to place the code?? Thanx -
A
Solved Problem creating greeting for a letter(access report)
That sounds like very good advice...Thanx -
A
Solved Problem creating greeting for a letter(access report)
The Database is new but is based on the structure & options inherint to a previous MUCH older app. -
A
Solved Problem creating greeting for a letter(access report)
Hello Access Friends I have a simple membership applicaion. I have imported legacy data, and all is working well. Now I'm working on output,letters(from Access report) to members. My problem arises with the creation of the greeting in the correspondence. The membership record can hold the name... -
A
Posting Problem
Hello Access Friends I wrote a longish post for the query forum. I wrote it in google docs and it contains a snippet of a sheets spread sheet. When i tried to post it i received this message: What did I do wrong? How do i contact and Administrator? Thanx Al -
A
Solved I suspect this super simple query is giving me what i asked for not what I wanted
This worked perfetly, Thanx & Vs + .... Hmmmm Now... Where can I look / go to understand this stuff? Can you suggest a reference or tutorial? Again Thanx -
A
Solved I suspect this super simple query is giving me what i asked for not what I wanted
Hello Access Friends I want to concatenate three fields in my table into a new field. When the first field in empty I do not get field2 + field3 Yeilds: I hoped to see the last+first without the prefix The sql looks like this: SELECT Demo.PREFIX, Demo.FNAME, Demo.LNAME, [prefix]+"... -
A
Listbox in subform not working
Pat, Thanx for your time & patience. I followed all your advice & still no luck. I just deleted the Id field from Git_type & changed the bound column & column count to 1 & it worked! Again, thanx for hanging in with me. Al -
A
Listbox in subform not working
Current state of relationships. Again, I's like to store the Gift_type NOT the key(Id) to payments -
A
Listbox in subform not working
I removed the referential integrity, deleted and recreated the listbox. bound column 2 , coulmn count 2 Still get the 1st column returned.