Search results

Hi, This is really annoying me as it seems to be a very simple filter but I can't get it working correctly! I have some code that produces a text string filter for a report depending aon what users enter for filter conditions on various fields on a form. All works fine except the date...

Hi, I have discovered a problem with my database and wonder if anyone here can point me to the best solution... The problem is this... when I took our company database over about 3 years ago it was around 45MB... now it is almost 350MB and growing steadily. I have today discovered the main...

Hi, I have an access database that runs fine on our current systems (mix of office 2002, 2003 and windows xp/2002. However we have one new machine here running windows vista and office 2007 and the database runs super super slow. just about every operation takes 10 times plus to run! I have...

Hi, I have a database here that is run by users who use either Access 2002 (XP) or Access 2003. I have noticed something which to me seems odd and dunno if any of you guys could explain why or how to resolve it? If one of the 2002 users opens the database it opens fine first time (I use 2002...

Hi, I have what to me seems to be a very wierd occurance in my work database. I'm trying to fimler a report to display data over a certain date range. the user enters the start and end dates on a form and then code runs a rport and filters it based on the dates (and other fields) on a form...

Hi, I have a rather annoying and frustrating problem which I cannot find a solution for through searching the forum. The situation is that I have a parent form with 1 unbound subform, the source of which is determined by the part number selected in the parent form (diffetrent parts have...

Hi, I have a purchase order form and want to prevent the user from exiting the form before printing the purchase order. This is fine in all cases except if the user is on the "new blank record" record (for want of a better description!) where the "printed" field is by default false. What...

I am sure it must be very simple but I can't find the command! I need to convert a currency value to a text value for use in a combined string, say £123.00, to the text string "£123.00". Basically I want one of the reports to say "£123.00 each less x% discount". Currently I am using : [Door...

Hi, I have a report, within which is a subreport. I would like to be able to change the source object of that subreport to different forms depending on the status of one of the fields of the parent form record. Basically this main report prints quote details of doors. I would like to display a...

Hi, I have a report, within which is a subreport. I would like to be able to change the source object of that subreport to different forms depending on the status of one of the fields of the parent form record. Basically this main report prints quote details of doors. I would like to display a...

Hi, I have a report within which is another sub-report. The sub-report when viewed alone is sorted perfectly, however when I view this within the parent report the sorting order seems to be completely ignored! Has anyone else experienced this and found a solution? Maybe there is another field...

Hi, I have the following as the filter condition for the record source on a subreport: [Door_Part_Number] = DLookup("[Door Part Number1]", "3-ENQUIRY DATABASE", "[Enquiry Number] = 10056") This works perfectly fine, however I would like to replace 10056 with the contents of a textbox...

Hi, I have the following section of code: rst2.MoveFirst Do While Not rst2.EOF If rst2![Door_Part_Number] = Forms![Parts database for editting records - duplicate only]![Door Part Number] Then If rst2![Extra_Code] = "NEW" Then With rst2...

Hi, I have a combobox on a subform, the source of which is a table. I would like to filter those source records based on the value of a field in the parent form but can't work out the syntax for the code! The scenario is that I have various products (doors) which can have any number of extras...

Hi, I have a table for which I need the user to be able to make an exact copy (every field except primary key) of a various "template" records which they then use as a basis for a new record in the table. The existing database does this using the following: DoCmd.DoMenuItem acFormBar...

Hi, I am using the following validation code for the part number field on one of my forms: DLookUp("[Door Part Number]","2-MAIN DOOR PART DATABASE","[Door Part Number] = '" & [Door_Part_Number] & "'") Is Null And Not "" The purpose of this is to prevent users from changing/creating parts...

Hi, I have a form in a database for our products (doors). I have a button that duplicates one of these records (all new products are based on standard template records). When this record is created a new product number is produced by the system which was the number of the original (template)...

Hi, I have a few queries that users can run and view the results in table form. I would like them to be able to sort the data on a field as I am able to do in design mode by simply clicking at the top of the colum and sort ascending or descending. For example to sort by site address to see...

Hi, Does anyone know some code that will take me to the record whose field "A" has value "B"? It sounds very simple but I can't find anything the does it! Basically I have a table or enquiry records, some of which are related. I just want to be able to click on a button to take the user...

Hi, I have a query which when run I would like the user to be able to change the values to alter the values in the table however the data from the query seems to be locked despite the query being opened in acEdit mode. It is a query based on a query based on a query based on a table. Is this...