Search results

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

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

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