Recent content by Access Virgin

Worked, thanks!!!

I'll give it a shot

I have a multi select list box that allows the user to run a report for more than one person. I have used a SQL statement to achieve this. It works fine until the person has an ' in their name, ie O'Neill, then an error occurs because the code thinks that this is part of the code. Part of my...

I am trying to use a multi select list box to create the WHERE criteria for a query, the criteria will be one name or more, so far I can get the WHERE part created except for the " " around the names my code listvalues = listvalues & "(((Table1.RaisedBy)=" & Me.RaisedByList.Column(0, I) & "))...

If I can remember the file required for the langauge is taken from the install cd, the file is called SetUp. Its been a while since I done it so this may not neccessarily be the case.

Thanks for your reply!

I have created a runtime version of an Access 2003 database, when I open the runtime .exe on a pc without Access it brings up the security error message. Normally I would resolved this by going to tools, macro, security on the menu bar and changing the security level to low. But as this is a...

I have seen this recently, so you might try this method. Create form1. Then add subform2 to it. Then add subform3 IN subform2. This way, it is looking at what fields to connect 3 with 2, not 3 with 1. If you put form3 as a sub to form1 it wants to connect those two, not 3 and 2. Make sense? The...

I have a form with 3 subforms, subform 2 is linked to subform 1 and subfrom 3 is linked to subform 2. I can get subform 2 linked to subform 1 but I cant get subform 3 linked to subform 2. To link subform 1 and 2 I have used child = Field1 and master = [subform1].Form![Field1]. I thought it...

I just got a brand new pc today, hp compaq with pentium 4, office 2003, windows xp. I work in a large company and my pc has the standard ghost which is given out, except for access which needs to be requested. It seems strange as my boss doesnt seem to be getting the same message when she uses...

I am using access 2003. When I am working on my current database I keep getting an error message appearing, 'Microsoft Office Access has encountered a problem and needs to close, we are sorry for the inconvenience.' You have the options buttons to send error report or dont send. This is really...

Im using Access 2003 and im having problems with print preview of reports. When I preview a report it runs off the page from the way I designed it, includes blank pages but when I print the report out from print preview its fine. Is there a funny with Access 2003? It just seems strange.

What is that doing? why is the email reference in it?

I have a multi select list box that contains field names in table, ie tblStaff.SurnameName. I want to pick certain fields from this list box to then open a query with the results. I have managed to create the select statement, eg SELECT tblStaff.SurnameName,tblStaff.Company,tblStaff.TelNo FROM...

I recently changed the main primary key (Project Ref No) field type in my database from number to 6 character text. The user requested this as some Project Ref No's will have 2 characters, ie DC1234. All forms that are opened from my main form will be using this primary key. Will the fact that...