Recent content by dweis

I think I got it. Not all the way there yet but that's because now the customer is changing their desire about adding more order numbers. Anyway, my plan is that when a user clicks the "process" button, multiple SQL statements are opened & held as variables. That combined creating a temp table &...

That's the if/then statement - I assumed (my fault) that if a user entered data in 1 field you would want the other field overwritten only if there wasn't already a value there. Just take out the if...then & end if lines. So, distancewalked onlostfocus would simply read: me.stridenum =...

You're very welcome!

I would put a "onlostfocus" event on both fields to check the status of the other. If you enter the miles onlostfocus if isnull(me.stridenum) then me.stridenum = me.distancewalked * 63360/[StrideLth] endif And on the stridenum field put the opposite to update distancewalked.

Hi all, I seem to be having a brain fart as I can't figure my way around this without using a series of update queries. I know there has to be a better way. Here's the scenario: I have a customer that needs an order number for invoicing purposes. They issue blanket orders once per month and...

bboffin, thanks so much. I know I didn't start this thread, but I gave you a star anyway. I was looking for a way to chop up an EDI document to get only the info that I need and you were able to give me some inspiration with your code. Here's what I've done so far, still have some field mapping...

Tom, thanks for the suggestion and for the help. I stumbled upon a similar thread this morning, http://www.tek-tips.com/viewthread.cfm?qid=765439 and was able to alter the code snippet to translate my EDI document. All I needed was the ability to create a new record when ISA is encountered and...

I have a flat file, 52 lines long, that needs imported into my database as a workable file. There will be multiple text files of varying length - this is an EDI 204 and we receive a couple hundred per day. I was able to create the outbound EDI using a file parsing program. The problem is the...

I have a mixed OS environment - Win2K and XP pro & home edition. I have a runtime app with a frontend/backend setup. I have a search form where a user enters data in field1 of the main form and the subform, linked on field1, pulls the appropriate data. Of the 10 users, one get's a white screen...

Thank you for your assistance! I installed the Office '03 service pack which patched the runtime and it works perfectly. Thanks again for your help.

I have a continuous form in 03 version. Based on the value of bound check boxes, 2 fields will have formatting set using conditional format. When this is run on my development system, the continuous form works flawlessly. When I distribute to runtime machines, the continuous form constantly...

Resolved the problem - IP conflict - thanks for the assistance.

Anyone?

W2k server - dedicated VPN Test machine WinXP pro VPN setup according to wizard and Microsoft docs 2 network cards, 1 attached to local network, 1 attached to hub that is directly attached to WAN rounter. I changed the default Routing and remote access Input/Output filters temporarily to allow...

You can refer to a date range from the underlying query if you're using a parameter query. In the report, create 2 unbound text boxes. Set the data sources equal to the parameter query's prompt. For example: Query1 is filtered by pickup_dt I place pickup_dt in the query 2 times. The first...