Search results

Hi, I have a question that has probably been asked a million times before, but I cannot find anything on it. I would like to have an access database that stores attached spreadsheets on an email to a defined folder on a server drive. I have tried to do this myself, but I cannot get the...

Hi, I have been given the task to map all links in and out of a number of SQL databases. (from what to what). I am fairly new at SQL, so I do not know if there is a quicker way than going through each script and stored procedure and manually reading through them looking for link references...

Hi, Im trying to work on a spreadsheet and want to creat a list of sheet names for a drop down box. but........ the value of the box must select the relevent sheet. ive tried to play around with it for ages, but i just cant get it to work. ive never seen it done but it must be possible...

I have been trying to use some code which apparently gives you the password string from a selected database. Unfortunately it doesn’t work as I think it is outdated because 2000 - 2003 works on jet 4.0 and I think it was designed for 3.0. Does anyone know if there is a piece of code out there...

HI, I am having a problem with all of my comment fields showing up as Japanese and I need to get some reports printed... Does anyone know how or why this would or could happen? I have checked the tables but they are normal. When you query the tables is when the comments start to mess up...

Hi, I need to create a query that will parse a word and separate it into a list of letters. I have had a go myself but am unable to do it... does anyone else know what to do? Thanks.

Hi I am having trouble trying to find some code that lists the fields in a selected table (which is in a list box its self.) I can list the tables but what I really need is for the table to update a list box with its own individual fields. does anyone know what I mean and can you help?

Hi, I have been trying to list all of the objects in my database in a single form. I have come across this piece of code which lists the reports, can anyone surgest how I can change it to wiew tables? SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764));

Hi, I have been trying to get an image to open from its location.... but it keeps trying to open "C:\C:\example.bmp" instead of "C:\example.bmp" does anyone know how to take out the first directory location tag automatically? Any help will be great! Thanks.

Hi, The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes. does anyone know whats going on with it. I know it isnt me as I have had my collegues check it over and they are all confused as well...

Hi, Here is a good one thats got me stuck for ages. I have made an email facility in my database and I have set the message box as a memo for the Unlimited Characters. There are a number of templates that the user can select but I cannot get the simple text to show formatting (as in rich text...

Hi, I have been working on some database protection, in which I am trying stop my tables from being able to be imported from other databases. Does anyone know where I should start or even if it is at all possible?

HI ALL, I have been working on some database protection techniques and have found floors in all of them. Basically I have to protect a database not using the application password... which has a different password for each form. This means using form passwords ect... but all of them can be...

I am Embedding OLE objects (PDF files) into a table and am having errors that state "A problem occoured while Microsoft Office Access was communicating with the OLE server or ActiveX Control." From what I can see there is not a problem with The OLE server, so the only thing I can think of is...