Search results

Update Query saying 0 Records will be updated Hi Guys, Not sure what I am missing here. I have a simple Select Query based on one table. In SQL View, the query is: SELECT SYSADM_CUSTOMER_ORDER.ID, SYSADM_CUSTOMER_ORDER.STATUS FROM SYSADM_CUSTOMER_ORDER WHERE (((SYSADM_CUSTOMER_ORDER.ID)...

Hi, Is it possible to allow for .xlsx uploads for sample workbooks in Excel 2007 or later? Currently you allow for only .xls (and .zip... but many people don't pre-zip files and instead convert to .xls). Thanks

Hi, I am trying to create a Delete query. I am trying to delete a specific part from multiple BOMs in my database. I have a table of the BOMs that I want to look in. I called this table PartTable. I also linked my database table SYSADM.REQUIREMENT which contains all the requirement parts...

HI, I have a text box that autopopulates with a Dlookup() function: =DLookUp("NAME","SYSADM_CUSTOMER","ID = '" & [CustID] & "'") based on entry made in ComboBox CustID. I also want to be able to type in anything I want if I leave CustID combobox blank. It is not letting me. Giving me an...

How can I replace the tables referenced in my queries with another table? I am appending and updating to tables in our ERP database... I did a test run on a SANDBOX version of the database to make sure everything went smoothly. Now I want to run those queries on our Live environment... can I...

I am wondering how I can diagnose a key violations error when I try to perform an Append Query... See attached for exact error that I get. I am not sure where/what to look for. I found in another thread something about deleting AutoIndex or Import/Create field from the Tools|Options menu...

[Solved] Update Query is asking for Parameters I've got an Update Query I am trying to run. So far I've got an SQL for it something like this: UPDATE ElectricalParts INNER JOIN [SYSADM_PART - Sandbox] ON ElectricalParts.ID = [SYSADM_PART - Sandbox].ID SET [SYSADM_PART -...

Hi, I am trying to update my ERP database by appending records. The records I want to append must start at a certain number (Part Id)...let's say 20101 and end at 20200. I need them to increment by 1. I also need other fields to populate with a specific text string I think I need to use...

I am trying to develop a Crystal Report and have use the Select Expert to create formulas that ultimately produced this SQL statement: SELECT "REQUIREMENT"."WORKORDER_BASE_ID", "REQUIREMENT"."WORKORDER_LOT_ID", "REQUIREMENT"."WORKORDER_SUB_ID", "REQUIREMENT"."PIECE_NO"...