Search results for query: *

Hi I have a report that i have inherited from an old database that i have upgraded from 97. The report somehow used to print out the last audit that was completed and print the details but since upgrading the database this no longer works. I would like the report to prompt for the lab...

Hi I have a report that worked fine in a previous version but since updating no longer prints the required record. I've tried reviewing the code below but I can't seem to find how it sets which record to print? What i ideally need is to replace the current code to prompt the user for the...

Hi I have a report that i have inherited from an old database that i have upgraded from 97. The report somehow used to print out the last audit that was completed and print the details but since upgrading the database this no longer works. I would like the report to prompt for the lab...

Hi I have inherited a database and have upgraded it to 2003 and i have come across a problem with how a report is run that i can't seem to get to the bottom of! The report menu has the following code attached to the print button but i need a way to get it to ask for the lab reference so that...

Hi I have combo box on a form called SourceID and a command button that opens the Frm_Source if a user needs to add a new record. when the Frm_Source form is closed the SourceID Combobox doesn't refresh? My current code is: Private Sub Cmd_AddSource_Click() DoCmd.OpenForm...

Hi I've been through the site and tried all the suggestions but must be missing something as can't seem to get it to work. I need a tab to be disabled if a control on anther tab is false. I have the following code: Private Sub Complete_AfterUpdate() If Me.Complete = True Then...

Hi I have a database that i have inherited and i'm getting the an error on the following line of code: Sub update_system_record() DoCmd.RunSQL "UPDATE [system values] SET myt!last_num = (current_val + 1)" End Sub The code should update the system values table with the current value but...

Hi I have inherited a database that needed to be updated from 97 to 2000/2003. I have table that has a field set with the following input mask: Logging Number: >CC0/\ 000 This creates a unique number based on the month and transaction - for example JY8/003 I'm now getting duplicate errors...

Hello I'm struggling to find my global.mpt file - I'm using Project 2003 and VISTA but can't find the global.mpt to copy onto another machine that uses xp. I've tried the usual searching but nothing is coming back? Thanks in advance Ralph

Hello Everyone I have a database that been convert from access 2.0 to access 97 and now converted to Acess 2002 - 2003. The database has thrown an error for dao2535, which i've removed from Tools, Reference and added the dao 3.6 but some code is still not working for example: Sub...

Hi I'm trying to do a sum if with two conditions and have the following formula - but it's picking up values that don't exist - for example I only have one section that should pull back data but it's bringing data back for other sections? Not sure where i'm going wrong on this one. i have set...

Hello I'm having a problem getting a formula field to work correctlty. I have pivot table that sums by department but i want to show this as an average for the department. Row Data: Department HeadCount Data: Month Column: Status I have a row field called head count that gives me the...

Hello I have a spreadsheet that in column A stored the following sample data: 1 min 8 sec 2 min 20 sec 33 sec 40 sec 2 min 42 sec 3 min 12 sec 53 sec 1 min 17 sec I need to be able to sum these values as time, i have tried stripping out the text but when i change the format to time it all...