Search results

Thanks, that is useful, now I must just figure out how to parse the output from that module to get the one I want to be logged. :) I get: 41.213.60.125 127.0.0.1 192.168.250.1 I want to save the 192.168.250.1 into a field called IP on each record in a table. I suppose I need to set each IP...

Hi, I am nearing the endgame of a FE/BE app. The FE will sit on various PC's across a LAN. IS there a way that when a user opens a record (via a form) on his FE (on his PC), the IP addy of that PC will be automatically entered into a hidden field on the form and store it in a purpose specific...

Hi Ken. The Barcode is a number format field. Just got an idea, if I try int(field name)... Nope, that doesn't help.

Hi, I have a combo box that selects Barcodes. I have set the format to fixed, 0 decimal places, yet the Combo Box still displays 2 decimal places (.00) I have checked the field on the table where the Barcode is called from, it is also set to Fixed, 0 decimals. My SQL Code for the Combo Box...

Thanks, removed the redundant line. Problem still there though. Query runs perfectly when run from the control screen. As soon as it is called from a routine on a form, it fails. Gives a "About to update 0 records". Trying to figure out if it has anything to do with the table (tblHolding)...

Justing wondering if I could solve this problem by calling the SQL in VBA rather than, and then my obvious question, never done SQL in VBA, would I just paste the query SQL in as a srting, and call the string?

I have a query that updates a field on a table with the value in another field. When I run the query from the Access control panel, the query does exactly what it should do, 100% perfect. When I call the query using DoCmd.OpenQuery in VBA in an OnClick function on a form, it does not work...

No, it is two different forms, displaying the information relating to each currency via a forex rate query calculation. I have named the Combo that selects the order in question the same on both forms, but they can never be both open at the same time, so whilst it could be a risk, I have set...

Hi Mile-O Two reports called from two different forms. The Forms both display the same Order Number, but in different currencies. I have set the Combo properties to both be Combo51, both in the VBA and the Properties dialog in the Form Design. Basically, what I am doing is printing an Order in...

I have an Access SQL statement (Using Access 2000)that contains the line: WHERE ((([tblResupplyOrder Numbers].[Our Order Number])=[Forms]![frmEditOrder]![Combo51]) This query is used to populate a report, but being conditional it only works when I drive it from form [frmEditOrder]. I want to...