Recent content by iain1978

the ID is a number. The number that relates to the DB record currently beiong looked at.

Thanks for the reply. I will give it a try, although I'm not to sure if it will help. If i write the code with a direct refrence (i.e "C:\test\closed\6\*.*" instead of "C:\test\open\" & ID & "*.*") it works fine.

Hi all, I'm having problems with the kill comand. Basically wanting VB to provide an archive function for a folder when some on a access DB says the records is closed. My basic code is below. I keep on getting file not found error at the kill comand. Can anyone explain what I'm doing wrong...

Sounds simple when you put it like that. And actually it was Thanks

Hi, I'm really want to discuss datbase design. I am creating a new database and I need help with the basic design. I'm trying to creat a databse that profiles the access people need to do a specfic function. Basically in my head the DB would be something like Table 1 - Function Details -->...

thanks Bob. I have removed the code as suggested and low an behold yes my table name was spelt incorrectly. I'm now getting a new error but I'll give it a bash at fixing it myself before bothering anyone again. Thanks yet again

First off all thanks for your help so far. If it wasn't for this forum my DB couldn't do half of what it does. I am still, however, running into the same error. It may just be my lack of knowledge so again pointers in the right direction would be helpful. From your previous advice the start...

The idea for this DB is to pick up data from a word form. It's really to stop cutting and pasting from word to access. Ideally what I'm waiting to have is a button on my access form that collects the data contained within the word form from a given file path and create a suitable new record on...

Bloody trees all a bit overtated if you ask me. arrrghhhh :mad: :confused: I'm now getting a new error and anyone that can help me I would be grateful. First of all here is the full code to what I'm trying to do. Sub GetWordData() Dim appWord As Word.Application Dim doc As Word.Document Dim...

thanks that got it...sometime you cant see the woods for the trees..

Hi, I've looked thought the forums to see if I can get help with this but no luck so far. Basically I have got some code that will take data from a word form although it wont run even though it appears correct. From what I can see I presume I didn't have the correct references enabled, but...

Thanks for the reply Pat, I think I'm nearly there, from the SQL you gave I created the below SQL which appears to work ok. But when I set the query to only select unique Values it does not work and I get the error message "Role profile set 9 field(s) to Null due to a type conversation...

Hi Thanks for the reply The 35 is an auto number field on the form that is loaded when I perform the append query. The trouble is the criteria (RoleprofileID) for the query is already taken form a text box on the form. What happens is I want to create a new record that takes information from...

Hi, Any assistance someone can give me with this append querry issue is appreciated. I have a table called tblRoleAssignments that has three fields RoleAssignmentID (PK), RoleprofileID & ApplicationrightID. It looks something like this. RoleAssignmentID, RoleprofileID, ApplicationrightID 58...

Hopefully an easy one for someone. I have a report that is grouped by a column called RAG status (Red, Amber, Green) to reflect the status of the respective issue. I now have a status report that I run and wish to order the report so Red issues are at the top followed by Amber and finally...