Search results

thank you so much mate.. you are a legend

hello.. i have a problem and need help urgently the way i had things set up.. was that the database was split on a laptop. i placed the front end of the database on the laptop desktop.. and held the backend in a shared folder on the laptop.. the other pcs in my office all had front ends on...

yes, that seems to work.. thank you bob.. you have shown me the light yet again.

ok let me try that

hi, thank you bob.. you have got me on the right track (i hope!) basically all i need to do now is the following. i want this: =Sum(IIf([fkAccountTypeID]=2,Nz([JobTdCp],0)+(IIf([fkAccountTypeID]=2,Nz([JobTdFare],0)+(IIf([fkAccountTypeID]=2,Nz([JobTdExtra],0))))))) minus this...

lol.. i know the score.. the only reason i am just looking for a solution is because i am sooo busy right now.. i dont even have time to post this.. seriously.. if one of you kind gentlemen could fix the syntax on those statements because i am sure they are wrong. please..?

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

hi.. i have placed the front end on each of the pcs and they all find the back end. i realise that there will be a problem if pc1 is editing a record.. and then the network fails.. but will this just mean pc1's changes will be lost?? that's not to bad. are there any other hidden dangers you...

ok.. i get you. as it says, this has to go on the database's startup.. i presume i should paste the code into a module... 2 questions 1. how can i tell the database to read that code as it starts up. 2. where abouts in the code do i place the address of the back end file. thanks...

ok, i have split the db on my main pc in the folder i have MAIN DATABASE and MAIN DATABASE_be now i tried to open the front end on all the pcs, but had the same problem. so now that i have split the db. how can i allow my 3 pcs to access the back end without any problems. my first guess...

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

does anyone know how to do this?? i can find anythin on the net, i found the Output to Notepad option you can add to the toolbar.. but that outputs too much other stuff.. i just want to send specific values and text.. anyone?

just as i suspected.. can you shed some light on how it can be done?

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

yes.. i do want their to be users.. and i want the database to automatically log who did what (their session) any advice regarding that? also when you talk about version numbers..i will split into back end and front end.. so im hoping microsoft's office/networking procedures will make this...

yeah i got it working with this... thanks. Private Sub btnPreviewReport_Click() On Error GoTo Err_btnPreviewReport_Click If txtInvoiceRef Like "Q8A*" Then DoCmd.OpenReport "rptQ8Invoice", acPreview ElseIf txtInvoiceRef Like "KYP*" Then DoCmd.OpenReport "rptKYPInvoice"...

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