ljungers
Last Activity: Mar 11 '07, 09:17 PM
Joined: Dec 6 '06
Location: Oklahoma
-
Anyone know how to work with expression builder in Report? I need some help. -
I forgot to thank you ADezii and NeoPa for your help. That VBA routine works now and performs the way it should.
Thanks to both of you.Leave a comment:
-
Thanks for the reply. The relationship between the 2 tables exist on the [loc_id].
I don't think that would work in this case. Reason I say this is because the Query is used to load the list box prior to selection. Selected row(s) are passed from the list box to the Report. The string contains the item_id, description, and the primary key [rec_id] (it's in list box, but hidden ). The report uses that [rec_id] to fetch the row in the...Leave a comment:
-
Adding columns from another table to a report
Hi to all. I hope someone can provide me with a solution to my problem. I have a Inventory master table that is used to produce a report.
Currently a form is used so that either part of the item number or item description is entered and a search button is clicked. VBA checks to make sure that something is in either of these fields and then a query is run that loads a list box on this form.
Clicking on one or more items... -
Can't get second table data to show in report
I have a Report that uses a master table and has been working ok. Now I need to add some data from a second table called locations.
The master table has a column named loc_code, and the locations table has a primary key named loc_code. I checked and the relationship of the two tables and it looks to be fine.
Now I need to show the loc-name, loc_addr, etc from the locations table on this report. Not sure how this is done... -
Fixing Report page problems
Hope someone can help me. I have two problems with a report that is using a memo text field in the body of this report. THis body could produce a half page to 4 or 5 pages of text.
When I run the repot I get only 1 page even when selecting a table row that contains more than 1 page of text to print.
2nd problem is that the spacing control characters are placed in this memo field (Carriage Return, Line Feed). The printed... -
I corrected the script as shown in last post. I added a command button to my form so that when the ascii text file that is imported into Access each month, this routine can be run. When I click on it the disk drive light flickers and it looks as nothing is happening. I never get the msg box showing that it completed.
=============== =============== ===========
Private Sub FixMemoField_Cl ick()
On Error GoTo Err_FixMemoFiel d_Click...Leave a comment:
-
I took another look at the code and saw that "rs.Update" was used 2 times n the code. I deleted the 1st occurance of it and tried to run it.
I now get the following message "Item not found in this collection". Anyone have an idea of what is happening.Leave a comment:
-
Getting error on VBA routine
Hi to all. Trying to get a onclick VBA routine to run, but I'm getting an error message when I click on the button that is used to run the VBA code to change/update a memo field in a table. This routine is only called one time after the table is reloaded monthly. There is data in this memo field that needs to be converted, exam "<crlflf>" should be changed to "Chr(13) Chr(10) Chr(10)".
The error message I... -
extracting a date from a text file using sed
Help needed with shell script using the sed command.
Need to extract a date from a text file. Each record contains the text "Date Entered:" and following that literial is a space followed by mm/dd/yyyy and two spaces. There are occasions when the literal is present with no date, just 3 spaces following it.
I need to extract that date and place it in a variable so that it may be used when writing out that record to... -
Thanks Mary for the info. Wondering if there is a way to start Word from within the VBA code instead of having to manually start Word.
The only reason I'm chaing the working code is because they desire some graphics to print and that is not happening when I send the Access Report to Word in a rtf file.Leave a comment:
-
The file is a regular text file wherre hex 00 - 1F are control characters, hex 20 - 7E are printable characters and hex 7F is DEL chharacter.
Some how hex (unprintable) characters got into this file (I think that this file was a print file at one time0 like hex characters B0, CA, 80, 83 are one I have found so far.
I need to read this file and output a files with all hex 80 and above removed from this file so that other...Leave a comment:
-
Using sed to strip hex x80 through xFF
have a ASCII file that is messed up. THe problem is that unprintable characters got into this text file. So when printing or using scripts to work with this file I get errors.
I need to clean up this file removing all hex 80 - FF from this file. Been told that I need to use sed in a script to do this. Have looked for examples but can not find anything dealing with what I need to do.
Could someone help me with the sed... -
One last question.
Should this code be placed in a module and run the way you described or in the code of a form that uses this memo field. The code makes sense to me as I look at it, but just not sure where and how.
Thanks for the help.Leave a comment:
-
Where should this command be placed? In a VBA, query, or is this something that can be run on the fly.
Will try to run it this afternoon....Leave a comment:
-
Can printer control codes be placed in memo field
I have a memo field that is printed using Access Reports. Various fields from this table are used to fill in the heading and the body of the report uses that memo field.
I now need to place some CR's & LF's into this memo so that the report is easy to read. I know that I can place the CR's into the ASCII text file before I import, but LF's I cannot because that affects the number of records loaded. I placed the characters <crlf>... -
Need to change DoCmd.OutputTo using Word
I need to make some changes to a Query/select/print report using word application. What I need to do is change the way Word is called yet keep the process the same. Word is used so changes can be made before actual printing. Need some way of calling Word as a mail merge with the information from an Access table that the current report uses.
I have seen mail merge templates that use something like <<field name>> in them... -
How to add printer control codes to memo
Was wondering how I could add printer control codes x'0A' or x'0D' in a memo field.
Have tried to do a find/replace but can't seem to do a Alt+010 nor a ALT+013.
Need to do some line feed & carriage returns. Memo field used with Access report. -
Need a CSS example for use with PHP
I'm getting ready to start developing a intranet app, and have had most of my PHP questions answered ahead of time. Now I want to develop a standard page layout for this app (background color, text font, size & color, logo position, a few dynamic labels) but have not chosen a Forms IDE designer (still reviewing).
For testing purposes anyone know where I could find some CSS & form(s) examples that I could use and modify for... -
Thank you Ronald, and again you come through with a good solution.Leave a comment:
No activity results to display
Leave a comment: