Search results

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

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

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

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