Search results for query: *

Hi this is my first web application and i am finding it very difficult. i am trying to create a master detail page with data that is linked from 3 tables in an access database. i can set it up with the data from the 1 table but as soon as i start to insert from 2 it all go's to pot, does...

hi i have set up my Access database in Dreamweaver and set an insert page to the main table showing all the details but it does not input the reference number (which is an autonumber in the table) or the date which is set up as ()now, does anyone have any idea what i have'nt done that i should...

Hi i am setting up a web based system in Dreamweaver. i have created a form for users to insert a new record but when i add the details and press submit i get an error page and the details are not entered into the database. the ref number is an autonumber and the date is now() but neither of...

Hi i am having difficulties setting relationships with three tables. We will have one complaint with many customers and that customer may have many actions against it. tblComplaint RefNo Autonumber / Primary Key ShortDescription FullDescription tblCustomer RefNo CustomerID Autonumber...

i have been asked to create a database to record customer complaints and am unsure how to seperate the fields into tables and form the relationship. There are not to many fields just ID number, Date, Department, Category, Short Description, Full description, customer details, action taken &...

Is it possible to change the background colour of a tab control box? CJB

Hi i have a problem with a query i am trying to create. It is for a leave form the tables i have are Annual entitlement Previuosly taken, Present Balance,This leave & Balance. my problem is that i want the previously taken field to be 0 on the first record, then the next record would show the...

Can i have a field in a report that a user can choose whether its visible or not CJB

I have a combo box that when a member number is selected the form is autopopulated with that members details thefollowing code works fine Private Sub cboLookUp_AfterUpdate() Me.RecordsetClone.FindFirst "MembershipNo = " & cboLookUp Me.Bookmark = Me.RecordsetClone.Bookmark End Sub But...

Can anyone help me please. I have 2 tables Customer & Transactions, i need to record the amount of times customers enter a lounge. Every customer that enters is a transaction, i want to record all transactions for all members so i have tried linking Customer Transaction RefNo (A/N &...

I would like to be able to select a members ID No that would open a new record but have all the members details automatically filled in the form and then be able to input a new transaction as a new record against the member No CJB

I have a form that users can input a member number into an input box then the form will open with all the members details (based on a members table). On the form i have a subform that relates to the transactions that member may make at any time (based on a transaction table), but the members...

Help, I have been asked to make a database web based ?????? i know nothing about doing this so can anyone point me in the right direction of what i need to learn to be able to do it???????? CJB CJB

I'll post this thread again due to the bad spelling of my previous thread Help, I have been asked to make a database web based ?????? i know nothing about doing this so can anyone point me in the right direction of what i need to learn to be able to do it???????? CJB CJB

How can i get a control tip to appear wnen the user has the mouse in the field and is typing and not just when the mouse has stopped on the field? CJB

Can i add a map to a command button (or pop up form) that opens a map that is zoned into areas which allows the user to select a location that then populates a text box with what has been selected for example the user clicks on say zone W1 the text box will then input with West wales? can anyone...

I have a form with a command button that has the focus when the form opens, how can i change it so that a combo box on the same form gets the focus on opening? CJB

I have converted a database from Access 97 to 2000 and have a report to print labels, one of the fields is called Name which is now an access reserved word, does anyone know how to get around this. this is what i am using at the moment = Trim ([Title] & " " & [Initial] & " &quot...

I have a pop up form that asks the user to input a works order number that then opens the relevant record, if a number is added that doesn't exist that this just opens to an empty form, i would like a msgbox to say sorry no record exist etc i this is the code i have used If (Not...

You guys were able to help me witha count problem but Can i now put another step into this and say the records that are status open (done this bit) & Department (Field Name) is Finance or is that asking too much? Can you help me again please? CJB