Search results

Hello Friends, i have create a wonderful accounting database keeping in consideration the accounting aspects of Region i Live. My question is How can i make my Accountig database as a stand alone software. So that it does not require Ms Access to be loaded (Even Runtime Acces). The user can...

plz any ideas or suggestions????

Hello again sorry about the code line at the end message. it was by mistake . Please Ignore

Hello friends I am using the following code Public Function fChooseForm() If fSetOpeningForm Then DoCmd.OpenForm "frmLogon", acNormal Else DoCmd.OpenForm "frmCoName", acNormal End If If err = 3024 Then MsgBox "Prince Accounting Could Not find Company " & _ "Information Table and Form." &...

Thanks guys for such apprehensive replies.. For KenHigg i just want to say that i am not at present becoming totally Pro Access and neither do i think of slamming VB. personnally i think vb is a greate programm to develop and maintain databases... but still i would favour for ms access as being...

Hello Friends, I am not sure if this belongs here but still i am going to give it a try. I have been developing an accounting system in ms access for the last six month for a multipurpose company. The system was ready by the end of february, launched using SQL server and MS access. Now somone...

thanks a lot Wayne... it worked well now a simple question basically the rs2 is updated in the loop , why it is needed to add the rs2.update at the last.. please explain.. Thankyou Muhammad Atif Gul

Any help willbe appretited.. thankyou

anything anyhelp....

H ow to concatenate the records of a single field with iteself forexample invoice no: 1 2 3 4 5 ... i want it to be written as 1,2,3,4,5,6 can it be done can i concatenate records with each other of the same field.

hello friend i got the following code from a download on this site. basically what is does it concatenates the field "Medication" with itesef if the Clinet id is Same. the only problem is that it concatenates all records except the last record. Please help me with this Option Compare Database...

how about dao method.. or somthing of recordset if was thinking of using the DAO.. and pelase tell mehow to use theexecute method in VB

i am trying to write this in a module . Basically the code workds but it also gives me an alert message for the query Dim strSQL as string strSQL = "DELETE * FROM tblInvoices" Docmd.runcommand strsql when this module is run it gives me an alert of deleting records . if i turn of the Action...

yes, i do agree with yo that this is not a normilized data. but i have to use it. Actually ia m trying tomake a sales calender. the calender contro has 42 textboxes. what i want is to check in my table the what amount of sales is available in connection with the textbox Data. if D1 is 01/03/2005...

hello friends i have a small DlooupProblem here tblLed InvoiceDate - Date Amount - Number tblCal D1 DAmount D2 D2Amount D3 D3Amount .... D42 i have a form with a control source to tblCal i am trying to use the DlookUp function as follows Tried this on After update, On Current, On Exit, ...

two days and not even a single line of answer. i am sure there must be somthing all the gurus out there can tell me. looking forward for a reply this time. Muhammad Atif Gul

Hello friends, I have been developing an Accounting System for my Multipurpose company with all the facts of accounting. It Includes everthing we need in An Accounting package. Presently we have 4 Users, one administrator. System is going very smooth with FE/BE on normal WindowsXP and MS Access...

hi, Can anyone tell me or give me any idea how to maike a sales calender. i mean a calender with Total amount of sales mentioned with the date. i know how to make a tabular form for my monthly sales using a query, but i need the same data to show ina calender.

ya i agree with you that the user has to know the username and passward. but my point is simple enough. what if i myself try to login at one syustem when i am already logged in at other , will this code allowes me to loggon

a little bit of question in addition to this. what if the user is logged in at one computer and somone knows his passward and tries to login again at ths same time from an other computer. will it give any error message? or it will login?