Search results

I have created a 2010 database which has 7 tables. All the tables have the end column "Click to Add" except one, which ends with my last named column ??? In case i'd deleted it I copied to Excel and imported the table, but had the same result. This may not seem like a great problem, but...

I have a problem with a .laccdb file being aytomatically created when the PC starts up. If I split the database FE & BE does access still create a .laccdb ? If so is this on the Backend? Thank You :)

Hi Paulo, I had tried your suggestion. The laccdb file has remaned locked from when I first opened access on the machine 9am this morning. I am unable to delete the file even when access is closed. I think (but cant yet be sure) that there is a conflict of names on the pc. i.e. it's...

Please help. I am fairly new to Access so treat me like a noob :) I have created an access 2007 database (not front/back end yet). Set it up on my pc and everything was fine. When i transferred it to my server PC (network) and opened the database it correctly created a .laccdb file. My...

Hi Mike, I cant find "On Load", I have: On Click, Before Update, After Update? Is it one of these?

MikeLeBen, Thanks for your help. At the risk of becoming a pain, can you spell it out to me (property sheet, select Data tab etc). I have no experiance of VBA and have only been working with access for a short time. Your help is very much appreciated and we were all noobs at some point ;)

Gents, Thanks for your help thus far. MikeLeBen is correct, there are several calls for each ID on the main form. A text box will only show one call. I can use the Subform which does what I need but the list box looks so much better. boblarson, I think you get what i am trying to do but...

Hi Mike, My Customer address table uses the customer account numbers (1 to 3000) as the primary key (no duplicates). The call history shows the account number but does have duplicates (a new line each time I call them). I have set a relationship between both fields and when I expand the...

Please help. I have a table of customers, addresses etc. I also have a table to correspondence, who I called and when. My customers are displayed in a form view and i want a list box in this form to show the call history (from the other table). The trouble is that the form view shows every...

Hi, Just a quick note to introduce myself. Working with Access for work and hobby. I have taken intermediate Access 2010 but this was of little, infact no use. While searching for answers on google access-programmers came up repeatedly came up and gave me the answers I needed :) solution...