Search results for query: *

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...

I assume you're going to be using this in a calculation to determine an order amount - I have a similar setup regarding adding a fuel percentage to a transportation rate. In the data entry, the user enters 9 for 9% fuel. I have another hidden field that is updated through the first fields...

First, there is no quotes around the 0. It's iif(number=0,"",number) Which is "if number equals 0 then use blank else use number." How exactly are you exporting this? Are you opening the query and then using file, export? Is there a button you push to export? Are you mail merging? Another thing...

Are you mail merging or exporting a table to word? You could try using a query instead and create a custom field in the query that states iif(number=0,"",number)and try a date field that iif(isnull(mydate),"",mydate)and then send it to Word to see what you get.

Do you have the fixed control's data control source equal to a control in the continuous form? If so, each time you're on that control in a new record, the fixed control will be blank. The following example has Text6 as a fixed control - it will show the current container from the form, but if...

You may want to do a google search on the subject. 1 way is to see if you can create a new mdb and import the tables and then compact and repair. Check out: http://www.granite.ab.ca/access/corruptmdbs.htm as a start. (They don't mention the ODBC repair, however they address the unrecognized...