Search results for query: *

Wow! that was even easier than i thought. And the responce time was amazing. Thanks very much!

Hello all. I have a report that calcualtes shipping quantities. i have a cople of fields [NUMBER OF UNITS A] [NUMBER OF UNITS B] AND [NUMBER OF UNITS C]. If there are 0 units, i would like the 0 not to be visable. i cant just delete the 0 because if i do, the calculation at the end screws up and...

Hello All. I have a report that shows on time shipping info. It is grouped first by the [primary reason late]. Then in the detail section, it shows all the orders. When I run the report, it first gives mee all the orders that do not have a [primary reason late] (which are on time) and then...

Hello All, I am setting up a report that will allow me to print a certain number of labels of our customers. i first have a table called [CUSTOMER ADDRESS]. In this table, i have the fields "Customer Name" "Address Line 2" "Address Line 3" "City&quot...

Hello all! I have a table where i enter shipping information. in one of the fields [ACTUAL SHIP DATE](format is short date) I would like to make it so only a date that happened in or after the year 2002. is this possible? any help would be appreciated. Thanks!

Hello All! I have a table where shipment tracking information is stored. Some of that information is "MONTH SHIPPED" "YEAR SHIPPED" as well as the "ACTUAL SHIP DATE". Right now i have a query that looks for the particular "MONTH SHIPPED" to give me a...

Beth, thank you. when i cahnged to option 2, the query showed data. but when i look at the report, i still get only the company name, not the complete address. same with the products. Sorry to be a pain, but this has been racking my brain all day. Thanks, Gus

I have a query that has 4 tables linked together. 2 that are data entry tables where the order info is entered. the other two are for products and for customers. but when i create a report based on this new query, no data is displayed in either the query or the table. i think i have taken a...

Hello all. This may seem simple to some, but i have been racking my brain trying to figure this out. i have a table that is called "CUSTOMERS". It includes: COMPANY NAME, COMPANY/DEPARTMENT, BILLING ADDRESS, CITY, STATE/PROVINCE and POSTAL CODE. I have several customers listed in the...

Hello all, I have 2 tables (Shipments_Late_Reasons) & (Shipment Tracking). I have 12 Query's (JANUARY)(FEBRUARY)etc. I then have 12 reports, one for each month. Data is entered into the (Shipments_Tracking) table which include data like, the month an order shipped, specific details about the...

I have a form set up to enter data. As I enter data, certain fields update into a "total" field. Is it possible to have that data transfered from this table to another table using a button witin the form, or either a code within the fields? Any help would be appreciated.

Terry, Nick, thank you very much. All the ways mentioned above work perfectly. Thanks Again!

Hello All. I have a line of data in a table that I delete after each use. I enter the data, print a report, then clear the data from the table. is there anyway to do this by either running a macro or module? i would really like to enter the data in a form, print the report from the same form...

I'm sorry, I just must not understand this. I understand that I change the [MyFormName] to the name of the form. But if I want to erase the entire line that is stored in the table, but entered in the form, what do I replace the [TheEditBox] with to acomplish this. If I enter the name of the...

Chris, thank you very much for your responce. I do understand what your saying, but when I attempt it, it seems to not work. I copied the code you gave me, placed it in the Onclose section of the report. I changed where you put [YourFormName] to the title of the form. Do i have to change the...

Hello all. I open a form to enter data on only one line. then i print a report based on this one line. Is it possible, that when i'm done printing this record, the information is deleted? Because the next time i go into the form to enter data, i only want that line to print. and if if the...

Thank you very much JOEMILLER. Sometimes you feel like your the smartest man alive when you get something to work like this. I got it to work, thanks to you.

Thank you very much for your quick responce. I can create the database, and the report and the form, but i cant get his code to run.I added a field to the table called [txtCopies] and added a text box in the form with the same name. I copied the code from the top down to the letters HTH and...

Hello all. I am trying to create a database that allows me to enter address information in either the form screen, or the report screen, then print the selected amount of labels onto the pages. currently i have a databse that has 1 field. then i have a report where the field is on the label...