Search results

Hi all, I have an SQL statement that is giving me some trouble. I've had to re-write it from a working piece of code as I discovered that when the I was opening a new record I got an error. Having written the SQL and checked the it in a query I thought it would work but, transfering it to...

Hi There I've written some SQL that selects a particular "Type of Project" the SQL is valid and works. Butr I'm not sure how to assign the outcome to an unbound textbox on a form. I'm thinking its the RunSQL command but I'm confused as to how. MySQL = "SELECT ProjectDetails.ProjectType" & _...

Hi All I've set the 'cycle' property to current record - and this works well for the tab key. - BUT the wheel on my scroll mouse still moves the record to a new blank record. Is there any way to disable this effect? Thanks Lee

Hi All I've got about 50 reports to print out in one go, currently I'm using the following code: Private Sub Print_Click() On Error GoTo Err_Print_Click Dim stDocName As String stDocName = "Average Length Of Time" DoCmd.OpenReport stDocName, acNormal Exit_Print_Click: Exit...

Hi All I've created a report style that I've used in all my reports (called prince). I'm really happy with it's lay out an style etc., in the preview mode in access. I've just added a button to print our the report the file, but most of the formating is lost. The code I've used is: Private...

Hi All I have a form that has a subform. The subform is in datasheet view, is it possible to hide some of the columns (controls)?. I want to hide the Primary and foreign keys etc from the user. I have put them in to enable me to synchronise the forms. The visible properties (along with a...

Hi I'm a getting a 'User-defined Type Not Defined' Error in the following code snip: HideStartupForm_Err: Const conPropertyNotFound = 3270 If Err = conPropertyNotFound Then Dim db As DAO.Database ' DAO <---- HERE IS THE ERROR Dim prop As Property Set db =...

I have a subform (Subform) within a form (Form). The subform holds a date control that records when a report has been received (RecdReport). The sub report is in datasheet mode (as the number of reports is on going). I need to be to display a pop up box if the report has not been received by...

Does anyone know how I can update a control with the current date when the value of another control is changed? The prblem I'm having is that he control that changes is automatically updated itself (the addition of several other fields), so the on change event doesn't seem to work. I can do it...

Hi there I have a form (form) and a subform within it (subform) that is sync-ed to it via an tableID. The subform is in datasheet mode as I do not know how many rows will be need. My problem is that when I am in the subform and I'm tabbing through the cells, when I get to the last one on the...

Hi there This is my SQL select line MySQL = "SELECT ProjectDetails.*, TeamMemberInformation.* " & _ "FROM ProjectDetails INNER JOIN TeamMemberInformation ON " & _ "ProjectDetails.ProjectDetailsID = TeamMemberInformation.ProjectDetailsID WHERE " I am using it to perform a search on...

Hi There I'm using a generic search facility and having problems implemeting it. I get the error "Object doesn't support this property or method". The search code is below. Can anybody see the problem? There is a subform (searchresultssubform) in a main form (findrecord). The search in a...

Deactivating fields from response Hi All Can some one tell me how to "grey out" or certain fields of a form inactive depending on the response of a drop down box or tick box? For example: Do you have a bank account? - tick box yes; then allow entry of bank details; else leave the fields in a...

auto populate a 'totals' box - New posting from replies Hi All Can Somebody tell me how I can automatically fill in a value on a form (and table?). I have several fields that record a length of time in hours on seperate forms. The final value is just the sum of all the other values. I'd...

Hi all I hope you can help. I have to write a query that creates statistics based on a drop down box. for example a drop down box that has higest exam level in it, GCSE, A level, degree, Phd., and a tick box for male or female. My query needs to return the number of males with "each" type of...

Hi all I need to open a form with both two necessary conditions, ie, the project number needs to be a cetain value and the bank number needs to be a certain value. Is is possible to do something like: DoCmd.OpenForm FormFocus, acNormal, , (("TeamMemberID=" & frmCallingForm.TeammemberID) And...

Hi There I have two tables (also forms) project (the primary table) and bank I'm trying to synchronise the two forms by setting the ProjectID field that they both have in common. It is a one-to-one relationship. If the projectID doesn't exist in bank then it should be created. If it does the...

Hi Is it possible to create a one-to-one realtionship between e.g., table_A and table_B, table_A and table_C... Table_A and Table_F. With referential intergrity whilst not all tables will have data in them (and therefore the record will not exist). And finally allow edits to existing data...

Hi there - I'm a beginner to access and would like to know how I can open a form in 'edit' mode if a certain value exists and 'add' mode id it does not. I posted this to macros but now think it is a query problem? I have a two tables with a one-to-one relationship. Project and bank. I have a...