Search results

Hello all, I have a problem with my database which I foresaw 2 years ago.. Here is my situation, I have 3 terminals in my office: MAIN (vista ultimate) SECONDARY1 (xp professional) SECONDARY2 (xp professional) I have a microsoft access 2003 database which has been split using the traditional...

hello everyone, it has been a while, hope you are all keeping well and sticking to your new year's resolutions (get your ass down the gym!) i want to lock all records in my job table that have a date value (in my JobDate field) before 2009 (ie 2008, 2007. 2006 etc), i want them to be view...

hi, i have a database with a single table.. DRIVER TABLE the driver table has several fields such as Insurance No. Insurance Start Date Insurance End Date MOT No. MOT Start Date MOT End Date etc.. there are about 50 drivers in the database. i want my outlook calendar to notify me when any...

i have a column of reference numbers in an excel spreadsheet and i want to use them as the records in a report. i can set up the query using the fields i want (and the report) but how can i set the query to use the spreadsheet values?

hi, is there a quick way to allow a single database file to be opened and used by two different computers (over a basic windows network) without splitting the fe and be? quick solution needed (short term) thanks

my database is set up like this: 2 TABLES table 1 - passenger table passengerID - PK passengerNAME table 2 - bookings table bookingID - PK passengerID - FK i want a list of passenger ids from the bookings table ordered by the most no. of occurences in the bookings table. i would also only...

hi there, i have been using the calendar from the following site: http://allenbrowne.com/ser-51.html i want to add more features to this calendar. at the moment im just researching the possibilities.. i have a table with dates, there are dates when certain documents expire. i just want the...

hi, just wondering if anyone can show me an example of what i am looking for cos im not what to search for. i want to create an ordered list.. eg 1 company 1 2 company 2 etc.. when my user presses the 1 key, it chooses company 1, etc. i realise i would have to make a listbox with my...

is it possible to automatically output the results of a query to notepad?

a few questions on the syntax of some arithmetic im doing in my reports.. are the two statements below correct? =Sum(IIf([fkAccountTypeID]=2,Nz([JobTdCp],0)+(IIf([fkAccountTypeID]=2,Nz([JobTdExtra],0))...

hello all. there are 3 pcs in my office, and i need to have my database open on all 3. we are constantly opening and closing the database to allow another terminal to make changes.. all the pcs use xp professional, the access version i have is the standard office 2003. we have a standard...

hi there.. i would like to have a button on my form. when you click this button, notepad opens.. and text is sent from the form to the notepad file. eg.. i would need to know the syntax for sending a value in my form (txtname).. free text.. and line breaks.. thats it.. so i might want...

Private Sub btnPreviewReport_Click() On Error GoTo Err_btnPreviewReport_Click Dim stDocName As String stDocName = "rptInvoice" DoCmd.OpenReport stDocName, acPreview Exit_btnPreviewReport_Click: Exit Sub Err_btnPreviewReport_Click: MsgBox Err.Description Resume...

http://www.londonheathrowcars.com/rels.jpg basically this is a system for a cab office. the BOOKER and the LEAD PASSENGER will both come from the PERSON table. the PICKUP and the DESTINATION will both come from the PLACE table. if a JOB is a cash job, it wont involve a PAYMENT, if it is a...

hi, im about to create a database that will be used over a network. i realise now that i will need to create a back-end database (stored on a server) consisting of my tables.. and a front end database on each terminal consisting of the forms/reports etc. i will also need a basic login system...

hi i have a listbox.. i want to change the order of the records whenever my user clicks on one of the fields (columns) MY CURRENT SITUATION my records are selected thru a query that puts them in order of date created (descending) one of the fields that displays in the listbox is jobdate...

hi.. quick question... i want to update all the records in a certain field.. to make the first letter of each word a capital to make every letter a capital i know how to make un update query, what to i put in the criteria if the field is called field1 cheers

hi. im using the following code to round off my dates but occasionally it goes wrong and displays as 3th or 11st etc can anyone see what is wrong with the following code.. Dim datelastdigit, ending datelastdigit = Right(Day([JobDate]), 1) Select Case datelastdigit Case 1 ending...

hi.. i have a database stored on my main computer. all pcs on the network have windows xp. the database is stored in a shared folder.. and at the moment.. everyone on the network can open the database.. but not at the same time.. basically if i have the database open.. my colleague on the pc...

hi.. my client had a minor problem with the database i made him.. he uploaded the database to our webspace via ftp.. i then downloaded the database and fixed his problem.. i then did a compact and repair. the database shrunk from 5mb to 2.5mb. i double checked the records and it looked ok...