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

...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 = me.distancewalked * 63360/[StrideLth] and vice/versa for the stridenum onlostfocus...

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

...For Input As #1 Set MyRS = CurrentDb.OpenRecordset("edi_imp", , adOpenDynamic) Do Line Input #1, strLine vSplit = Split(strLine, "*") If UBound(vSplit) > 1 Then strCol = Trim(vSplit(0)) Select Case UCase(strCol) Case "ISA"...

...For Input As #1 Set MyRS = CurrentDb.OpenRecordset("edi_imp", , adOpenDynamic) Do Line Input #1, strLine vSplit = Split(strLine, "*") If UBound(vSplit) > 1 Then strCol = Trim(vSplit(0)) Select Case UCase(strCol) Case "ISA"...

...EDI using a file parsing program. The problem is the inbound. How can I get the multiple lines into one record? I need everything from the ISA* to the end and I don't really need the qualifiers. What I want is to be able to say, ISA line, from 18 - 25 is field 1, 1st N9 line is field 2, 2nd...

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

...data entry, the user enters 9 for 9% fuel. I have another hidden field that is updated through the first fields afterupdate event to equal fuel_pct *.01. The user sees 9%, but all calculations use .09 to calculate fuel. Example: amt1 fuel_pct hiddenfld fuel_chg $100.00 9%...

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