Search results

Hello All, I've got a Split Database (Front End & Back End). So far it was all good until recent when a department placed in a different city (200 Miles apart) wants to use my application. The Application has gone very slow for them when they access the back end. Could some one help me in...

Hello All, I've written a small VBScript to delete a folder from %Application Data% which is created by my MS Access Application every time the user logs in, so that they don't get a Profile Storage exceeded error. All is well so far. However, I want this VBScript to run automatically, the...

Hello All, I have a query which returns a vast number of records. Now I want to delete any duplicate record (Leaving the first instance). I can manually copy this resultant data to excel and delete the duplicates easily by using the Remove Duplicates Option. I want this functionality to be...

Hello All, I am trying to migrate most of my database backends to SQL Server. I need help from experts on how to proceed. Is there a tutorial for a starter and what version shall I install to start with? Having said this, I am searching over net for this. If anybody can send me few links to...

Hello All, I am trying to select a row from a table and insert it into the same table with a different primary key. I've tried hard enough but get a syntax error :banghead:. Below is the code I've been using. Any sort of help will be appreciated. strSQL = "Insert into tbl_A (CustomerID...

Hello All, I've got a FILLABLE Application form in pdf format and I am looking for help on how to populate this application form with some fields from my Access Database. Any sort of help will be appreciated. After searching the web for a while with NO SUCCESS:banghead:. I am posting it...

Hello All I have a table called Activity with columns ActivityID, PolicyID (Lookup from tblPolicy), CustomerID (Lookup from tblCustomer) and further ... I have an activity form with details from tblactivity..further I got a Dashboard where all the records are displayed including ActivityID...

I Seriously need some help friends, From the below mentioned scenario...I basically have a table called Activity with columns ActivityID, PolicyID (Lookup from tblPolicy), CustomerID (Lookup from tblCustomer) and further ... I have an activity form with details from tblactivity..further I...

Hello All, I am looking for a way to create a popup in Internet Explorer using VBA. I was just wondering if there is a method in ie.document to create a pop-up. However Where can I find all the properties and methods of an ie object. Any help would be highly appreciated. Many Thanks

Hello All, Once again I am struck. I've got a form in access which (When submit button is clicked) submits the form's data to a website which inturn generates a pdf file (Which gets opened in a separate tab (of IE)). I want to save this pdf file somewhere on the drive. I've looked for at...

Hello All, I've got a table named tblEmployee with a field called attSignature of attachment datatype which inturn holds jpeg files of employees signatures. My query is when I create a letter in word I'd like to replace <Sign> with this signature. I've tried this but its replacing the word...

Hello All, I have a combo box and a 3 checkboxes in a data sheet view form. I'd like to enable or disable one or more checkboxes depending upon the value of the combo box for that particular record. Unfortunately Conditional formatting cannot be applied to a checkbox (atleast not that I...

Hello Again, I am struck again with this web browser...I am unable to capture the button click event on this web page...the source code looks like <divclass="submitBtn clear right"> <inputtype="submit" id="policy-details_Save and Calculate" name="method:calculate" value="Save and...

Error #91 - Help - Solved Hello All, I have a wierd problem. I am using a tempVar in my database...Basically I am calling a Navigation form (Which In-turn has 5 different forms with vertical tabs). Somehow an error #91 appears abruptly. I mean the error appears sometime and sometimes it...

Hello All, Could anyone please help with the following. I've got a datasheet view form and got a couple of Subforms in a separate Tab Control (Ofcourse on different tab pages). All these three forms (The Datasheet view form and the two subforms) have a Customer ID in common. I want to...

Hello All, Just wondering Is there a way to make my search Text box to behave like any other search box on different browsers... For Example How to create Text Box input field watermark effect in MS Access with a default text displayed and when the user enters into the textbox, the...

Hi, I've got a webbrowser on my form which displays an online form with a submit button. Is there a way to capture the details of the fields values as soon as the user clicks the submit button. Any help would be appreciated. Many Thanks

Hello All I have got a database with a form to enter addresses. All I want to do is be able to type in the postcode on the form and click the button called LookUP which should lookup for the relevant address depending upon the house number provided and populate automatically into the...

Hello All, Does On_Change event triggers only when the data is changed physically or does it triggers even when it populates from some where else (Like calculated field) ? Basically, I got a text box "A" which gets the value depending on the value of another text box "B" or "C". I want to...

Hello All, In the main form I've got the actual amount for example 1000 and I have a sub form in data sheet view which has two columns ROW Amount Recieved Outstanding Amount 1 100 900 2 200 700 3 300...