Search results

yes sorry.. i meant the update to field.. i wanted 1 call to make the first letter of each word a capital letter.. and 1 call to make all letters capital so i wanted both calls for field1

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...

this seems like it is going to be tricky.. i would prefer this situation.. MAIN PC The database is stored on this pc in a shared folder. The database can be opened on this pc and edited freely. SECOND PC Network Places - MAIN PC - this pc can open the database through the networl and make...

hmmm.. thats not good is it.. so are you saying that i would need to have the main db stored on a server.. and that when a client pc requests to open the database.. they can load a front-end version of the database.. and when they make changes.. those changes can be sent to the main db on...

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...

a slightly annoying problem.. i open up a report from my form.. the report has 2 textboxes.. my user enters a start date and an end date.. im trying to display the date entered on my report using this unbound textbox.. =Format(CDate([Forms]![frmDriverAccounts]![txtstart]),"dd mmmm yyyy") on...

the thing is not all jobs will be card jobs.. some will be cash..cheque etc also sometimes the same customer will use different card details.. and we will need to store the customer contact details also.. i think i will do an entity relationship.. then list the attributes then normalise and...

here is something else to consider.. jobs people places drivers credit cards a job may have one or more pickups a job may have one or more destinations a pickup will be one place a destination will be one place a job will have one booker a job will have one or more passengers a booker will...

i think i need to do some serious normalisation here..

here is another issue.. if a "job" involves two vehicles (and therefore 2 drivers) at the moment i am entering the same record twice (job details - eg date, time, passenger, pickup, destination), the only difference being the driver..

ahh.. well there is no one way.. for long distance jobs it would be based on mileage.. for London areas we use set fares.. there are also other issues that may be charged such as additional drops, driver waiting time if the flight is delayed..baby seats cost extra.. etc basically this picture...

hello all.. trying to resolve an issue in my system.. basically i run a taxi firm.. for those that dont know. this issue deals with credit card payments, and in particular payments for multiple transfers. lets say you are booking 2 journeys.. the first journey is on 2nd June from London...

is there a way to do this simply by altering the code im using on the button above.. or will i have to look into it properly and change everything..

so are you saying that when the invoice number is generated.. the number 10001 can be placed in a separate table.. then when you generate an invoice.. it will search this table.. increment.. and place 10002 in the table?

hello all.. i have been using my new system for a month or so and have come across a problem with my invoicing. basically i create an invoice number at the moment using the account reference (3 letters) and a random 5 digit number.. so lets say my account holder is McDonalds.. a few of their...

yeah, i removed.. as integer.. and it worked.. thank you sir..

now im gettin type mismatch with the bound as 1 and 0 again.. using this.. Option Compare Database Private Sub lst0bookings_DblClick(Cancel As Integer) Dim stLinkCriteria As Integer stLinkCriteria = "[id] = " & Me![lst0bookings] DoCmd.OpenForm "0bookings", , , stLinkCriteria End Sub does it...

ok.. using this it opens the new form.. but it only opens it at the first record.. not the chosen one.. Private Sub lst0bookings_DblClick(Cancel As Integer) Dim stLinkCriteria As Integer stLinkCriteria = Me.[lst0bookings] DoCmd.OpenForm "0bookings", , , stLinkCriteria End Sub this happens...