Search results

Hi, I don’t want this to descend into an argument over the use of natural or surrogate keys. If you put a search into Google you can find hundreds of such discussions, it’s been done to death. I’m actually interested in the way(s) in which Access allows you to implement surrogate keys – most...

Hi, I think it would be worth having a pure technical discussion area. It's clear from a recent discussion between myself and Scottgem that people have different views/opinions on the best way to implement aspects of relational database theory, system analysis, object modelling etc . I'm always...

Hi I'm just starting to design some basic pages with Visual Studio .net I've created a web application project and a form which connects to a db and displays some data. I was wondering if the forms allow persistant variables i.e. If i add a variable "above" the code is it able to persist it's...

Hi, Is it possible to create a recordset from a db on a webserver if you know the ip address and the path to the db? I'm struggling to provide some complex graphing using vbscript in an ASP page so i wondered if i could create a package in Excel that would connect to the database from the...

Hi, Please bear with me here as it's a little involved. I'm doing a staff profile website which includes a section where they can enter their annual/other leave details. I decided to store their leave in two fields Start_Date | End_Date rather than each individual date that they took - the...

Hi, Anyone know how to launch a help file with code? The files are *.hlp I know how to use the forms "Help file" and "help context ID" properties but this is in conjuction with a tree view control that doesn't have that factility. Thanks TS

Hi, Bit of an odd one here. I have a main form with a subform -Frame1-and a treeview control. The form displayed in Frame1 changes depending on the selection made on the treeview control. Some of the subforms are pivot tables and charts that are designed to be manipulated by the users. The...

Hi all, I'm a bit stuck with a db relationship design. I need to hold information in a staff table about a person's Line-manager. My initial idea was to just have the Staff Table and use the PK of a member who is a Line-manager as a FK in the Line-manager field in the same table for their...

Hi, Does anyone now how to use a parameter request within an In() funtion like In([MyParameter]) where the parameter would be something like 19,20. It's a little complicated but i'm passing the parameters via VBscript in an ASP page and i thought i'd tried and work out how access handles this...

Hi all, I'm thinking about writing my latest DB with an MSDE backend and have a few questions. I'm aware of the client server relationship and this has made me unsure about the following. If i link the tables to the access front end am i defeating the point of using a database server such as...

Hi all, I'm currently writing a DB that uses the FE/BE setup but is only intended to be standalone. I was wondering what the consequences of changing the BE to MSDE would be regarding record locking -with a view to using it in a multi-user environment - and the differences in the SQL language...

Hi all, I've been trying to find a way of creating a simpler access security. In the zip file are two databases. The passwords have been set to the word test Both db's need to be in the same folder. If you want to open lockout.mdb and bypass the form you need to enter the password and then...

Hi all, I'm trying to open Database B from Database A and then close Database A using the following code in Access 2000 Function OpenPasswordProtectedDB() Static acc As Access.Application Set acc = New Access.Application acc.Visible = True acc.OpenCurrentDatabase...

Hi all, I've got a bit of an odd problem. I'm trying to use this code to open a word document whose path is stored in the DB and displayed in a text box on my form. Private Sub CMD_OPEN_FILE_DIALOG_Click() Dim WordObj As Object Dim StrOpenFile As String StrOpenFile =...

Hi all, :) Just to be clear i don't mean a Between statement :) I've come up against a problem and i'm really not sure what the correct solution is. :confused: I want to store the leave dates for staff. The most space efficient way seems to be just to store the start and end dates of the...

Hi all, Is it possible to create a query that has a variable that i can access from a form? i.e. i can bind a checkbox to the variable. Or would i need to create a temp table first? Thanks TS

Hi all, I tried to find out as much as i can about this issue but i keep finding conflicting views. I am just about to buy a new server for work. I will be running a number of databases (4-5) on a website. The server will be using IIS windows server 2003. The databases will be accessed...

Hi all, I am at the stage of developing the reports for my latest DB and i am yet again having doubts about the way i have choosen to align and justify the labels and data [See attached]. Does anyone else have a preference/examples. Cheers TS :confused:

Hi all, I'm trying to put some error handling events in my DB mainly to deal with key violations when appending records to tables. I've put this in a module which is called when i need to run a query. Option Compare Database Option Explicit Public Function RunQry(QryName As String)' Pass in...

Hi all, I'm still having problems with the treeview control. I've found out from the microsoft knowledge base that you can't use numeric data for the nodes as the control treats them as variants and therefore tries to use them as indicies. This means you have to append something to them to make...