Search results for query: *

try creating a query and have the form pull from that query. in that query have item and quantity. then in the criteria field for the quantity, put >0. SHAWNDRA CREE JONES, DATABASE DEVELOPER TOYOTA MOTOR MANUFACTURING NORTH AMERICA ERLANGER, KY

I need help! I have a nested iif statement in an unbound text box. There are 7 iifs and and 1,129 character. The iif statements I have been using have been working fine. Well I went into them to change something just like a 12 to a 13. When I try to get out of it and save, it is giving me an...

TRY IN THE PAGE LOAD EVENT TYPING COMBOBOXNAME.VALUE = "" [LIPSTICK] SHAWNDRA CREE JONES, DATABASE DEVELOPER TOYOTA MOTOR MANUFACTURING NORTH AMERICA ERLANGER, KY

WHAT I HAVE DONE IS CREATED THREE COMBO BOXES MY FIRST IS SUPPLIER, THEN RTE AND RN. THIS GOES IN MY ROWSOURCE OF THE FIRST COMBO BOX - SUPPLIER: SELECT DISTINCT [TBL_NEW_LEWIS_TRACKING].[SHORT NAME] FROM TBL_NEW_LEWIS_TRACKING; IN MY BUILD EVENT I HAVE THE FOLLOWING: Private Sub Form_Load()...

MY HIT COUNTER IS INCREASING BY 2 FOR EVERY HIT, WHY? IT WAS DOING IT BY 3. ANY IDEAS? SHAWNDRA CREE JONES, DATABASE DEVELOPER TOYOTA MOTOR MANUFACTURING NORTH AMERICA ERLANGER, KY

I TRIED THIS SOLUTION AND IT DID NOT WORK CAN ANYONE HELP?? SHAWNDRA CREE JONES, DATABASE DEVELOPER TOYOTA MOTOR MANUFACTURING NORTH AMERICA ERLANGER, KY

Here is a portion of code I have written. I have order count for example = 4. I want it to loop through textboxes (mainstring(I) 1- 12) on my report which are set up as an array. And change the font color until order count = 0. If i declare Mainstring as a String it will read the value of...

THAT SOUNDS GREAT. I WILL GIVE IT A WHIRL!!! SHAWNDRA CREE JONES, DATABASE DEVELOPER TOYOTA MOTOR MANUFACTURING NORTH AMERICA ERLANGER, KY

I WANT A VERTICAL LINE FROM TOP OF DETAIL SECTION TO THE BOTTOM OF DETAIL SECTION. IN THE DETAIL SECTION I HAVE TWO SUB REPORTS THAT VARY IN SIZE FROM TOP TO BOTTOM. THEY SHRINK AND EXPAND ON EACH DETAIL SECTION. I NEED A LINE ON THE DETAIL SECTION OF THE MAIN REPORT, THAT WILL SHRINK AND...

I HAVE A REPORT WITH TWO SUBREPORTS ON THEM. I WANT A LINE TO SEPERATE THE TWO SUBREPORTS. THE SUBREPORTS AND THE DETAIL SECTION ARE SET UP TO GROW AND SHRINK. HOWEVER, HOW DO I GET THE LINE TO ADJUST TO THE HIEGHT OF THE DETAIL SECTION EACH TIME. SOMETHING IN CODE BUILDER SUCH AS...

THAT IS GOOD ADVICE, I FIGURED THAT OUT LATER IN THE DAY THAT IT WOULD BE EASIER SO I DID CHANGE IT. HERE IS WHAT MY CODE LOOKS LIKE SO FAR. VALUE = 2, IT PLACES SUPPLIER NAME IN SKID2, I ALSO NEED IT IN SKID1. THEN I NEED IT TO GO TO THE NEXT RECORD. THEN IT TO PICK UP THE SUPPLIER VALUE...

I HAVE A FORM THAT HAS 23 UNBOUND FIELDS IN THEM. THESE UNBOUND FIELDS ARE LAYED OUT AS A TRAILER. I HAVE A LIST OF SUPPLIERS AND THE NUMBER OF SKIDS GOING TO EACH PLANT IN A CROSSTAB QUERY. I NEED IT TO READ THE RECORDSET THEN FOR EXAMPLE, IF SUPPLIER A HAS TWO SKIDS GOING TO PLANT K, THEN...

also try this, i finally got mine to work. Private Sub Report_Open(Cancel As Integer) ' You didn't know how many columns, or what ' their names would be, until now. ' Fill in the label captions, ' and control ControlSources. Dim intColCount As Integer Dim...

sorry i posted this to the wrong thread, but this will dynamically write a crosstab or any other query to a report. SHAWNDRA CREE JONES, DATABASE DEVELOPER TOYOTA MOTOR MANUFACTURING NORTH AMERICA ERLANGER, KY

i got mine to work with the help of a friend; try this! Private Sub Report_Open(Cancel As Integer) ' You didn't know how many columns, or what ' their names would be, until now. ' Fill in the label captions, ' and control ControlSources. Dim intColCount As Integer Dim...

I'M NOT SURE EXACTLY WHAT YOU ARE LOOKING FOR, BUT THIS CODE SAYS THE STRING84 = 4 THEN IT IS VISIBLE WITH A CYAN BACKGROUND, ELSE NOT VISIBLE. If string84 = "4" Then [TRL8SUB4].BackStyle = "1" If string84 = "4" Then [TRL8SUB4].BackColor =...

WELL UNFORTUNATLY I CAN'T GIVE A SAMPLE OF ON UNBOUND REPORT, I AM CURRENTLY TRYING TO DO THE SAME THING. WHAT I CAN DO IS POINT YOU IN GOOD DIRECTION. TRY HTTP://MSDN.MICROSOFT.COM/LIBRARY/EN-US/BAPP2000/MDBDOWNLOAD.ASP. THERE IS MICROSOFT ACCESS 2000:BUILDING APPLICATIONS WITH THE FORMS AND...

IN YOUR CROSSTAB QUERY, SELECT PROPERTIES, THEN UNDER COLUMN HEADINGS PUT EXAMPLE: "1","2","3","4", OR HOWEVER THE FIELD NAME VALUE FOR THE COLUMN HEADING WOULD APPEAR IF ALL WERE THERE. THAT AWAY IF ONLY VALUE 1 WAS THERE DURING THE FIRST QUARTER, IT...

Try coping the file from someone elses computer and replacing yours. make a copy of yours first just in case something goes wrong, for backup.

Try saving it as a snapshot instead of an rtf. Shawndra Jones