Search results for query: *

So far everything has been working fantastic calling a requery. I think as my form progresses I'll begin do experiment with some of your suggestions Olaf, just to get a better understanding.

Hi Mike, I switch over the list box to use a SQL Query and I'm calling the Requery method after the transaction. Works perfectly! I'm not really sure why I wanted to build the cursor on form load versus in the listbox in the first place... Thank you Mike!

I have a form with a pageframe and two pages. In the form load, I load up a cursor. The cursor is used on Page1 in a listbox. I have a command button to processes a transaction based on what record is selected in the listbox. What would the best way to update the cursor be? I basically need...

Thanks guys, have it working perfectly now! I did have NULLDISPLAY set to 0, and Olaf's suggestion did work with the added NVL function.

Can anyone identify any problems with this query? The last little piece of my select you can see I'm adding T1.LABOR, T2.PURCHASESTOT, and T3.MOCOST. Everything seems to work great, except for when one of these fields are empty/zero, my total will always be zero. If all fields have a value...

I actually figured it out, sometimes it helps to key out your thoughts I guess. What I ended up doing was just setting focus to the listbox when it selected a match, and immediately back to the textbox to allow for additional search characters. So for this is working fantastic, much more...

Hello everyone! My question pertains to incremental searches using a text box. On my form I have a text box, and a list box. The list box contains my record set, and the text box allows for incremental searching of my records. So far it works great, except I need to "Tab" or "Enter" to get...

Hello Everyone, I'm looking for suggestions as to what I should use for a clock. I currently have several users that RDP to a server where our ERP is hosted, and they use it for attendance and labor capture. The problem that I have is because I have the taskbar disabled, so when clocking...

Mike, this works great, but how could I avoid "Activate" if they switch between tabs and haven't selected a different record on the main grid? JRB-Bldr - The query for my cursor will take 60-70 seconds to run without any filters, so my users wouldn't like that each time they open up this form.

So the longer I stare at this the more I confuse myself. I'm working with two grids, on two separate pages of a single pageframe. The grid on page2 is dependent on the record selected in page1. The problem I'm having is if I build my cursors on the form.load the page2 cursor take forever...

Does anyone have any experience using the GridExtras class by Craig Boyd? I've used it a number of times and it works great! On my Form I have a single pageframe with two pages and one grid each. The first grid exports just fine, but the second will only export the column names. If reverse...

Sweet! Got working, thanks guys!

The cross tab probably wouldn't have worked for what I'm trying to do anyway. I'm just trying to load a cursor with my data in this format. What I ultimately need is one record per ID, and for each location for that ID to have its own column. Doesn't matter what order they're in, so if ID#...

Here is what my data looks like: ID | LOCATION 123, A1 123, Z8 123, Q3 123, B1 123, N4 124, A6 124, A7 124, A8 124, Z0 124, Q5 I need this: ID | LOCATION1 | LOCATION2 | LOCATION3 | LOCATION4 | LOCATION5 | 123, A1, Z8, Q3, B1, N4 124, A6, A7, A8, Z0, Q5 I tried to run this query with GENXTAB...

I just verified most of my join fields do have an index, I have a couple that don't so I'll add those over the weekend and hopefully I'll see better performance. Might even see an improvement simply re-indexing these tables since a couple of them exceed 1GB. Mark, had my fingers crossed on...

Is it possible to optimize the code below? Would I be better of creating multiple cursors and joining the cursors? Currently I'm just filling a grid with the result of this query. It takes about 13-15 seconds to execute, which really isn't long but would like to reduce this as much as...

No at all! I think I'm having the week you had last.

Hi Mike, I've been holding down the fort by myself this week so just today I've finally had a chance to attempt this. I just dropped in my appropriate clauses and it works great! I do see a brief delay before the query status window opens, but that's most likely caused by my environment...

I have a fairly large SQL query that I'm trying to combine with a SCAN/REPLACE. SELECT material.orderno, material.pn, material.wc, material.duedate, labor.status, order.status, labor.startdate, labor.pn FROM (labor INNER JOIN material ON ((labor.orderno=material.orderno) AND...

Thanks Mike! As an added bonus it even runs much quicker!