Search results

Hi, I have an access form named “SCREEN-DATA-LOAD_SHEET” which has some code on the after update event behind a filed named orde num (second field from left of form) which I’d like to update /insert some data into fields in the local access table named: “DATA-LOAD_SHEET”. It gets the data...

Hi, We have an SQL table named OITM on a server running SQL server 2008 which has a field named: U_MAX_COM which has a datatype Nvarchar(max) and set to allow nulls. In access (either 2003 or 2010) we link to this table but often the field shows up in access as a memo field, whilst other times...

Hi, I have an access 2003 form named “frm-PALLET_DESPATCHES” in which I would like to be able to amend the “direction” (drop down section) and “pallets” (entry box) fields which in turn will save the data into a local access table named: “DATA-PALLET_DESPATCHES”. However when I try to amend...

Hi, I have the below SQL code in an append query to update a linked access table. The data is coming from a linked SQL table view (dbo_View_Prices). The problem is access pops up a message saying: "Microsoft office access cant append all records in the append query" - See attached screenshot...

Hi, We have the following SQL code in a access 2003 but we need to be able to add new records within the query but it wont allow this. The table named "dbo_view_cbprices" is a linked SQL table view and im thinking perhaps this is the the route of the problem, any help on this would be...

Hi, I have the below formular field in a Crystal report but i need to modify the code so that on the part that says: {DATA_FORECAST_UPDATE.NEW_WEEKLY_BASE_FROM}=0 is changed to instead check to see if the field is blank instead of 0 I tried isnull which usaully works ok in Access but I cant...

Hi, I have an access query that looks at a table named DATA-COMPLAINTS which has complaints data. One of the fields on the DATA-COMPLAINTS table is named: CC_ENTRY_DATE which is the date each complaint record was entered in the format mm/dd/yy What I would like to be able to do is prompt the...

Hi, We have a query within a Microsoft Access 2003 database that looks at some data within Oracle tables including a period field and a year field that reference a field in an oracle table named: YEAR_PERIOD. The query has been working fine up until this year. It doesn’t want to display any...

Hi, I would like to be able to count the number of complaints in a query by counting the number of times a product code appears for each complaint description but not sure how. So when the user starts the Query it promts to: "Enter a partcode" so if the user enters "2358NXA" the results then...

hello, im trying to find out the total number of times a particular record (one with a particular partcode called 2358NXA) appears in a query. Ive tried the following: 23PARTCODETOTAL: DSum("[STK_PART_CODE]","EXT-STK_PARTS","[STK_PART_CODE]= '2358NXA'") but this doesnt seem to work Anyone have...

Hi, i have the following criteria in a query to calculate the difference in days between two date fields, however i would like to not include any saturdays and sundays in the calculation. DATEDIFFERNCE: DateDiff("d",[CC_ACK_PRINTED_DATE],[CC_LETTER_PRINTED_DATE]) Is this possible?

Hi, I have a query in Microsoft Access 2003 named: "QRYPRODUCT_MANUFACTURING_SITES", this query looks at another query which in turns looks at 3 oracle tables. What I would like to do is do a weekly comparison of the manufacturing site for all products from the most recent purchase order(s)...

Hi, I have some fields within an access query, one of the fields is named: “COM_DATA_KEY”. This field is within a linked Oracle table named: EXT-COM_EXTRA_DATA_FIELDS The problem is the whole field contains 11 numbers and the first eight characters of the number are a PO number and the last 3...

Hi, I have the following criteria on a field named "STK_PART_CODE" in a Query : [Enter Part Code] to promt the user to enter a part code in the input box to lookup, however I would like to be able to give the user the option of entering more than one part code to lookup and display in the query...

Is it possible in Microsoft Access 2003 to setup the ability to allow users to easily insert there own pictures into a form and also if possible they need to be able to re-size the picture if need be?. Sometimes up to about 7 pictures may need to be inserted into one form. The idea is a product...

Hi, I have the following code in a query: NEWMARP: IIf([DATA-PRICE_BOOK_ITEMS]![PRICE_NEW]<>0,(([DATA-PRICE_BOOK_ITEMS]![PRICE_NEW]/[CURRENCY_RATE])-[EXT-STK_PARTS]![STK_COST_CURR]/100000)/[DATA-PRICE_BOOK_ITEMS]![PRICE_NEW]/[CURRENCY_RATE])*100,0) If the Field "STK_COST_CURR" = 0.48 if the...

Hi i have a query in access that has the following code on one field to subtract 7days from the week date (this code works ok) Re-jig Date:IIf(([week date]>=#12/01/04# And [week date]<=#31/12/04#) Or ([week date]>#03/01/05# And [week date]<=#31/12/05#) Or [week date]>#02/01/06#,[week...

Hi, Is it possible to flag a new product that is added to a database table? I have a Product table in access 2003 (thats linked to an oracel table). This table contains fields including STK_PART_CODE, STK_DESCRIPTION, ORIGIN_COUNTRY Sometimes new products are added into the table, when a new...

Hi, I'm trying to do a query in access to show any customers that have spent £200 or less in total during 2008. We have an access database that has records of all customers, customer branch and invoice details. so far ive created a query that looks at the related fields, and some example data...

Hi, i have the below code in a Access 2003 module, but when i run the code i get the following error message: runtime error: 94, invalid use of Null, and when i click debug it highlights this line: x = x + rs(fArr(i)) Any suggestions on how to fix this would be great?. Sub delZ() Dim rs As...