Search results

Thanks Bob, Ive attached the 2003 format

Yep its been a while but if anyone could help me on this one I would be grateful, I have attached the database for someone to have a look at thanks..

Hi All, Its the first time in a few years that I am developing a database. Im trying to remember how to make the fields :banghead: In the sterilisers table I have Steriliser 1 2 3 4 5 6 7 8 9 (clippers) 10 11 12 13 14 15 16 17 Dip Tank (Brisket Shears) 18 19 (M inspector) 20 21 (R Offal R)...

Anyone? The error message I get is ODBC call failed [sqlserver] The datatypes text and varchar are incompatible in the equal to operator

Why would you assume that? Its just what I think I have figured out, had a look at google, but admit I am a sales man not a database programmer. What have you tried to resolve this issue? When I enter the above criteria it says invalid Have you tried Google? I had a look at...

Hi All, I have a query which checks a linked table for any records older than a year that havnt had a service. I presume in the criteria field for org name I would put Not [dbo_flowitems].[name].["serviced"] Is this correct? Also the line above does not work :banghead: What would the...

Hi, I have a query which reads in data from a sql server database, I then want to add a checkbox to say if people have been emailed. I have created another table which contains autoid and 'emailed' the emailed is a checkbox which once I run the query seems deactive. How do I linked the...

Thanks Eugen that seems to have resolved it, will have to look into the differences.

Thanks again Eugen, The code I have tried see below does not seem to work as I still receive the results for this year. SELECT dbo_flowitems.name, dbo_orgs.orgtype, dbo_orgs.orgname, dbo_people.firstname, dbo_people.lastname, dbo_people.role, dbo_people.email, [Year Reminder].[Emailed?]...

I am having problems setting the field format because it is a linked table to SQL server, I cannot change the date format on the server because another program uses the database.. any idea? Thanks

Hi Eugin, Thats right Ive setup the tables via a link to our SQLServer, thanks will have a look at the formatting.

Hi, I am trying to set the criteria of a date field in a query, the field is called "flowdate" and an example data excerpt is "2011-02-23" when I use the <Date()-365 it does not return anything, even when I use <Date() it does not return anything. If I remove the criteria all works can someone...

Hi There, Whereabouts would I change the date format from the access database from yyyymmdd ? I am trying to convert this table from access into mysql, and when I ouput to a csv file the date is in access. Many Thanks Chris

Hey, I am experiencing a couple of problems with my forms First is I have set my background as a picture, the problem this produces is tat there are a lot of flashes on the screen when i rollover buttons etc. The second is that how do I have multiple checkboxes within the detail part but be...

Hi there, I am still struggling to get a picture behind the button, when I putt my picture on it goes in front of the button, I can not seem to find a layer variable, could someone help plz, many thanks chris

Hi There, I have a main form which shows the students I have within my table, the form is set to continuos and has a button next to each record. This button opens the report and filter the report to the record clicked. Problem is I do not know how to reference the record which has been...

Hi there, Is there a way to set a grahic to transpare in access usually this is achieved by using png's but I cant find any switch within access. Also how do you set the layers of the images, Many Thanks Chris

Thanks Thanks Guys, It seemed the space in between the > and the = was causing the problems Cheers :)

Hi There, I am having a strange problem with regards to when I set my filter I want to grab the fields which are greater than the value set in a drop down box. here is my code If IsNull(Me.indEndDate.Value) = False Then If count > 0 Then filterString =...