Search results

Hey peeps, Hoping you can help me out with a problem I have... Basically every now and again I get a call from my client saying they cant add a new record, to any table, they get a message saying they are not allowed. I go in and it seems the DB has somehow locked itself and I have to open it...

Help! I use Office/Word 11.0 but my client uses Office XP 10.0 I dont really want to have to go to his office and update the database manually each time I want to email him different versions! However I get an error on the references as obviously on his PC they cant find 11.0 and on mine I dont...

I want to use Set rst = db.OpenRecordset("query_name") to open a query but the query has a parameter which is a form field. I have the form open but when I get to this line it asks me for an expected parameter! Any help much appreciated!

Guys, For whatever reason I have three queries (different) that I want to use to populate one Word template. I know the code to open the document and do the word bit but I dont know the code to run a query and then access the fields in it.... any help much appreciated.

Hi I have a database and I want to basically use table fields to load into a Word template and I want this done via code, i.e a button....any help very much appreciated!

Right I have a table that has three columns to store three different addresses in, they all link to a single address table (well no relationships just lookups on the form); many to many relationships were a hassle to add! Anyway the user may or may not enter all three addresses, they may just...

I have a yes/no field (tick box) on my report but basically I want this displayed as a Y or N. I wanted to add a label, hide the original field and on report open test if the field is yes or no and then update the label accordingly.... I dont know if this is the best way but any help would be...

Hi All, Hope this thread is in the correct place! I am fairly new to Access but have lots of SQL/VB experience (I am using Access here purely for the size of the app). My question is one of best practice/easy to implement! I have a system I have created for around 5 users. I have split the DB...

Hi all, New here and found the forum brilliant to use! However I am stuck on a design issue. My client wants to be able to authorise user changes to any tables. My plan was to simply put an authorised flag on each table and when the data is edited then that flag is removed. The administrator...