Search results

Thanks a lot, changed as suggested and now working fine :)

ok ive included Shipto in the query and dont see the error now however the data does not get updated in the table DATA-LOAD_SHEET. the account field doesnt get updated either Any ideas why?

Ok ive re-uploaded, hopefully this one works ok.? I can see the form so not sure why it want visible.

The form named "SCREEN-DATA-LOAD_SHEET" i just opend the file I uploaded and could see it ok, can you have another look please?, i can re-upload again

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

No, characters are typically no more than 20

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

do you mean put the 2 fields id like to update onto a subform instead? and have the rest of the fields that dont need to be updated on the main form?. Would both form need to look at seperate querys?

I think maybe its due to the join type in the query: the querys SQL is below: If this is the case is there another approach i could try?, i dont think i can join the tables in the query in another way. SELECT [DATA-PALLET_DESPATCHES].sop_despatch_note_num, dbo_odln.address...

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

thanks for you suggestion. I setup and Outer Join on the source table to the destination table but without setting an Isnull as i wanst to sure where to set this and it worked providing the destination table does not have any primary keys but i need primary key set on itemcode and cardcode on...

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

ok, i tried taking DISTINCT out but the query is still non updateable

Thanks for the quick reply Bob, the weblink you provided is helpful. Like you say it sounds like its either the multiple Join types or the fields in a join are not indexed correctly.

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 got this working by using the following code, by doing a non-equi join between the two tables: DATA-COMPLAINTS and dbo_@CALENDER It seems to be working fine. Thanks for you help on this David. Kevin SELECT Data-Complaints.* FROM Data-Complaints INNER JOIN dbo_@Calendar ON...

I think a small calculation would likely not work as the way the weeks falls varies each year. I guess writting a function would be more reliable, or some how looking up the correct week on the calendar table.

Ok thanks i added those addional colums and as a quick test before i proceed with creating the functions i filtered the crieteria of the weeks and years to test, but i just thought of an issue that might cause a problem using your suggested functions/code. For example if i enter 2010 for the...

Do you mean add the calender table to the query and add the week and year fileds? would i need some way of linking these to the complaints table and the CC_ENTRY_DATE?