Search results for query: *

I have developed a database which is linked to a database containing the tables. The database containing the forms, queries and reports is password protected. Is it possible to password protect the database containing the tables with a password different to that used to access the database...

Able to resolve problem - thanks dhookom for taking time to respond. Cheers,

Database captures the running of scenarios. Need to develop a report which lists all the scenarios that have been ran to date, in order of the number of times they have been ran together with confirmation whether it was a success or failure. ScenarioNum relates to the number of the scenario...

Thanks for the help - worked a treat. Much appreciated.

I am trying to move data from table tblLandD to table tblOpen. tblLandD consists of EvalNo, ScenNo, ScenArea, Score, Comments, Analysis and all the data in this table where Analysis is equal to ‘Open’ needs to be copied into tblLandD. tblOpen consists of OpenID, EvalNo, ScenNo, ScenArea, Score...

Thanks for the responses. Fortunately the database wasn't that large so ended up reconstructing it. It appears to be working fine with the VBA. Cheers, Cairo207

Thanks for the responses. I agree I would normally go for VBA everytime but in this case the VBA is not working due to some network problem which does not appear to affect the macros. Just thought that as a workaround I could convert the VBA to Macros to ensure the database is workable.

Need help to convert VBA to Macro. A combo box, named cboSelect, selects a record to view but I am forever receiving a Network problem. Can anyone assist in converting the following: Private Sub cboSelect_AfterUpdate() ' Find the record that matches the control. Dim rs As Object...

I have inherited a database for the capture of work-related incidents. A STATUS combo box identifies whether an incident is Open or Closed. What I want to do is when an incident is Closed it prevents entries into any of the other field/combo boxes on the form leaving the STATUS combo box as the...

I'm trying to reinstall VB.Net 2002 and 1.0.3705 framework. I've version 1.1.4322 framework installed but I believe my version of VB.Net requires the earlier version of the .Net framework. Gone thru the process of installing the Windows Components disk and then proceeded to install VB.Net...

How do I count the number of sundays in a given period? Also if the start date is a subday, the formula should count that sunday, and, if the end date is a sunday, the formula should not count that sunday.

Thanks for the help guys.

I require a function that takes a date dd/mm/yyyy and checks whether the dd/mm entered is >= 05/04 If Yes, the function returns the year of the date entered If No, the function returns the year of the date entered minus 1 I've tried using a boolean to add the year without success.