Search results

Hi, Currently I have a scenario where we are requested by our corporate client to quote them of cost of Air Ticket to there required Destination. Upon getting the email, we use our GDS System to book the flight. There upon the booked flight along with the fare is emailed to them. After sending...

Hello Everyone Can anyone help me in this. 1. EK 615 L 18APR ISBDXB NO2 0340 0550 WE 2. EK 803 L 22APR DXBJED HK2 1700 1845 SU 3. EK 804 Q 29APR JEDDXB HK2 2045 #0025 SU 4. EK 612 Q 30APR DXBISB HK2 0255 0700 O* MO this is a...

what options do i have to connect to my database if back end of my db is in newyork and front end is in washington. how do i connect to my db??

I am trying to do the following If any one of you have experienced Abacus ticketing system, each reservation is comprised of a group of names as follows 1.1 Gul/Mohammad Atif Mr 2.1 Gul/Mohammad Adil Mr 3.1 Bond/James Mr I have to copy the above data from the abacus tcketing system into a...

How can i Print My code in modules and form in Color?

Hi I am using the following Code on the OnCurrent Event of my form. The Problem is , in Access XP or 2000 it works Great but in Access 2003 it starts flickering, unless we bring the cursor to any field of the subform Private Sub Form_Current() On Error GoTo Err_Form_Current If...

Hi I hae been using the Auditing Feature from the sample database for quite a long time and it worked perfectel. until now i transfered all my database from Office XP to Office 2003. The problem is that when i try to update any field the code stucks and nothing ahappen. the cursor does not move...

Hello fiends .. i am using the following code for the on move mouse property of all my command buttons. i call this code from the on load event of my form and it works fine with all comand buttons ,, but if i try to make is work with Tab control or Toggle Buttons it give me an error message of...

I am trying to use the following code to change the Currency field property in all my tables from Currency to Standard. Function ChangeCurrency() Dim db as database Dim tbldef as TableDef Dim fld as Field set db = CurrentDb For Each tbldef in db.TableDefs If left(tbldef.NAME, 4)<> "Msys"...

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

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

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

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

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

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

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.

hello friends if anyone of the access gurus here had a chance to download and use the Form demo from Microsoft website you would have notieced that the background is actually a bmp picutes of cloudes. Can anyone tell mehow they manage to put that pictures in the foms. i tried using the...

ok i have a invoice form with Subform presently i am doing somthing like this i have placed a code on the OnEnter event of the subform as such, If isnull (Me.CustomerId) or me.CustomerID = "" then msgbox "Please Enter A Valid Customer ID",vbokonly,"Customer ID Needed" me.customerID.Setfocus...