Search results

HI Folks, Cannot purchase access 2010 any more... went to MS tech support and they hung up on me (accidently) but lady didn't know ans anyhow re: access 2016 and compatibility issues. Can I view a 2010 database in access 2016? Also, has anyone installed Access 2016 with office 2010...

No shouldn't have too much effect.. I have done before without too much trouble... Test it out.. and see if the code works.. may need a bit of tweaking but not too much. Courtesty of Google: Access 2013 uses the same file format as Access 2007 and Access 2010 for storing its databases, but...

Thanks for coming back to me... Hi, when you insert the photos.. they are okay.. it is only when you open the photo... you can view the photo but when you close photo (MS photo viewer), access form then hangs ... You then have to close the form... Error message you get is: You cant save this...

Anyone got any ideas?

Hi Folks, Can anyone help please? I have two bound objects that I insert pictures from network. Then when I double click to open and view.. they do no probs.. but when I close the second one - the form locks and the only way I can get out is to close form and then go back in again... Any...

Many thanks but I am lost.. I have never setup modules.. :confused:

For the example above, you could set the ControlSource of a text box to: =ConcatRelated("product","scheme_opdetm","order_no = " & [order_no]) Unfortunately it didn't work in report.. when I run the report.. it is asking for a parameter value ConcatRelated

Hi folks, Any ideas please? Products report shows on report as: Order no Product Order no Product Order no Product eg. 012345 table 012345 chairs 012345 lamp I want to show Order no Product, Product, Product eg. 012345 table, chairs, lamp Any idea?

thanks pr sorry .. my mistake.. didn't explain fully.. there are 22 tables in total.. Picture1, Picture2 not to say just repetitive but also OLE object. they are only linked not stored.. Date_Reported, Date_Logged IMO repetitive the date fields are different dates and...

thanks pr.... no.. there are more than 3 tables.. but I understand what you are saying.. I did create a subform for the notes.. but there are a lot of notes.. a lot of toing and froing!!!... (he said/she said etc.) -- this is prob where the majority of data is.. it is the 3 main tables...

thanks access rookie! :) see attached! mdb with 3 main tables

Hi every year around this time... I run out of space.. data only (3 tables) = 2gb -- Its a call log system that uses a lot of information... is there any way I can squeeze a little more in? or set up structure so that rather than getting 11 months from database.. I can get 12 months...

I got a workaround to work!! (from suggestion from another thread on this site) compact and repair seems to have solved the issue.. everything crossed it stays that way!! shall wait and see!!! :)

thanks bill for coming back to me.... :) If you are trying to GroupBy a memo field it will not be able to and shows those characters. Use First to show the memo in a query. when i put in criteria to show 1 record it shows memo text fine.. i have 690 records and all of a sudden has just...

Hi FOlks, can anyone help me? table shows memo text fine.. but when i run a query its shows the memo field with text like: 였A and 愊` and 謍‹ :confused::confused::confused::confused::confused::confused::confused::confused:

THanks for your help Taruz :)... have tried the code and have come up with run time error '438' ?

Hi, I am looking to add to this code.. (as below) I have a combo box in which i select a name it finds the associated record with the name entered. However, if i want to find another record with the same name - i have to press ctrl & f and click on find next.. Can I add a "find next"...

I is a donkey! it has sunken in... I had FULLTOTAL instead of ORDERTOTAL hence the reason why the square brackets were not working!! Thanks for all your help!! - all working now!!!! :o) I have both totals and the percentage of one compared to the other!!! ---- Also found this...

sum(orderqty) based on = rep = field name REPTOTAL sum (orderqty) based on = not like rep = field name ORDERTOTAL i want to get % of both these totals (one divided by the other x 100 to get percentage) - sorry didnt explain myself properly... thanks for %formatting i can do this.. its the...

HI vbaInet many thanks for your help.. (you have helped me with the code for another report where the fields are displayed in the report and also to understand my dilemma/solution much more). With this one - they are not based on fields in report (report is a summary of count) however...