Bigdaddrock
Last Activity: Nov 3 '14, 09:57 PM
Joined: May 27 '10
Location:
-
Great help!! Now, is there any way to allow multiple line entries into that same cell if the user pulls up the Table in Datasheet View and attempts to modify the entry there? -
How to set the size to print pin-fed US Priority Mail Labels?
My customer uses a Panasonic KX-P 1150 printer for printing his US PRIORITY MAIL LABELS. The size of the labels are: 4" Tall and 4.75" Wide, with no borders (they are continuously fed, pin feed labels). I have made several attempts to create a report using the Label wizard, but invariably the labels print as if they are going to Letter sized Portrait oriented sheets.
That is to say, the first two labels print perfectly, but the... -
How to stop an edit form from saving unwanted changes?
I currently have a form to allow changes to a record in a Table. Sometimes, if the user has entered some changes, but then changes their mind, is there a way that I can allow them to close the form WITHOUT making any changes to the record??? -
Printing pin feed labels
I have a client who uses US PRIORITY MAIL labels that work with a pin feed printer.
The size of the labels are 3.875"Hx5"W and are single column, continuous feed.
I am having a problem designing the report to print them. I have set the form size to the dimensions shown above, but the labels come out misaligned, skip some entirely, etc.
I have tried to change the paper dimensions, but do not see anything that... -
Thanks, I appreciate your saving me the time. I will take more advantage of using the Tabs on my forms and following the menu prompts. They create VBA code, which I can then "doctor up" and "merge" to allow me to do the multiple tasks that many "joined" macros allow me to do. Just requires a bit of "cut and paste" and a bit of creativity. Unfortunately, I do not have the time to learn VBA.Leave a comment:
-
How to view the VBA structure of Automated Macros?
I am not very conversant in the use of VBA. However, I make extensive use of the Macros in Access. Is there a way of viewing the VBA behind the various Macros? -
You may be onto something there. I too found that if I added the nine digit zip code directly into the table, it carried the dash through to the Query.
What I found is that I am populating new records in a different table based on an existing record in a separate table using the SetValue macro in a form.
More specifically, I am using the Zip Code in a Customer Table to populate the Zip Code and SHIP8 columns in an Invoice Table. ...Leave a comment:
-
I have found a solution to my issue. It is based on an MS article found at http://support.microsoft.com/kb/207829
I adapted it to my database and found that if I did the following, I ensured that each time the ShipCityStateZi p came up it included the dash, if it had a nine digit zip code.
The solution was to create a new field in the query called Postal Code:
Postal Code: IIf([Ship8] Like "#####-",...Leave a comment:
-
Thank you for all of your suggestions. And thanks for clarifying that the Input Mask is indeed just for display purposes.
However, what continues to concern me is the following:
If Ship8 shows the item with a dash, then I must assume it is being kept with the dash. Why would the dash be dropped when used in the expression:
ShipCityStateZi p: [Ship6] & ', ' & [Ship7] & ' ' & [Ship8]
As for how it is being...Leave a comment:
-
9 Digit Zip code dropping the dash with sample file
Here is the sample file. Please UNHIDE the fields City, State, and Zip in the query which contains the questionable field ShipCityStateZi p.
Note that both the Zip and Ship8 fields contain the dash in the zip code, as well as the CityStateZip field. However, the ShipCityStateZi p continues to drop the dash.
Any solutions?...Leave a comment:
-
The text boxes ZIP and SHIP8 are both bound to the Table of Addresses. They have the exact same format in the table, and I have done nothing to amend how they each appear in the Query. As such, I am befuddled as to why the Zip continues to carry the dash, but the Ship8 drops it when each is incorporated into a Built expression.Leave a comment:
-
Both fields do have the exact same format.
I must use an input mask instead of number, since the nine digit code has a dash - a number field would not recognize it as such.Leave a comment:
-
9 Digit Zip codes not printing with dash
I have a table that has two fields that are identically formatted TEXT boxes with field size of 12 (more than necessary, but memory is not an issue). On both I have the Input Mask set for Zip Codes, formatted as "00000\-9999;0;_". Heck, I even selected to save the Zip Codes with the dash.
The two identical fields are ZIP and SHIP8. The first is used for billing address, the latter is for shipping.
My problem... -
How to update a field to record last time record was revised?
I have a field called DateLastRevised in a Table. I would like that field to be updated to reflect the date and time that the record was last revised.
I have a form that edits these records and after using that form to edit a particular record, I would like the ability to open another form which would access that same record via a query, based on the table, in which the DateLastRevised field is used to order the records. I could then direct... -
There is only one "LatestRevision Date" involved in the following expression that you suggested.
1. DLookUp("INVNUM ","INVOICE" ,"[LatestRevisionD ate] = #" & DMax("LatestRev isionDate", "INVOICE") & "#"))
Remember, I am seeking the INVNUM associated with the greatest value of the "LatestRevision Date" in the INVOICE Table.
Is it possible...Leave a comment:
-
Close but do not save Macro action not working
I have a form that updates a Table.
The form has a Command Button for a Macro that contains the CLOSE Action. Within the Action I have left the Object Type and Object Name blank. For Save I have selected NO.
Unfortunately, when I enter a few items into the new record via the form, and then select the CLOSE Command Button, I find that the record has indeed been saved!!
How can I close the form without allowing the new record... -
That was a great solution!! For others reading this thread, I placed the three lines of code (shown as 2,3,and 4) into a query where I had the total ounces to be converted. It works perfectly.
Thanks again!!Leave a comment:
-
No changes to my original input. I copied and pasted your suggestion and got that response.Leave a comment:
-
Convert ounces to pounds and ounces
I have an invoice that lists the various products' weights in ounces. My client would then like to total those amounts (no big deal), but then post the total amount in the format of "X Lbs and Y Oz".
Can anyone come up with a means of deriving such text items? By the way, he would like to reflect the ounces to the first decimal point (each of the items carries their weight to a single digit).
Thanks for the assistance. -
Unfortunately, I once again got a syntax error. Any further suggestions?Leave a comment:
No activity results to display
Leave a comment: