Recent content by Simmo2010

I have one copy of the "database" on the network share. Then each user has a front end with linked tables to the network share.

It is already split and the problem is as Winshent said it is showing as read only!? I moved it to another share that people read/write from all the time and is working now now! Fingers crossed!

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

Answered it myself! I was forgetting my programming! Just late bind it and remove all references!

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

What a muppet! I didnt replace ParameterField with the name!!! What a duffnut! Sorry mate!

Weird thing is the error is now saying 2 parameters expected! But definitely only one in the query!? Set rst = db.OpenRecordset("SELECT * FROM query_name WHERE ParameterField = '" & [Forms]![frmRepAll]![cmp_name] & "'")

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!

Yep worked it out, sorry I should have posted! Basically I used this code (just in case useful to anyone else): Dim db As Database Dim rst As Recordset Dim objWord As Word.Application Set db = CurrentDb 'Open Word Document Set objWord = CreateObject("Word.Application") With...

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

Nice one! Stupid that I didnt think of that but has been a long day! ;) Many Thanks!

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

how do I then show it again, is there a shortcut key I can use for developing?