Search results for query: *

I'm trying to perform the following for one-to-many relationships from multiple tables within Access. Here's the article I'm looking at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/MailMergePartII.asp Is there an easier way to go about this as this article is...

Basically, I tried the find and replace with the ^b for section breaks but can't replace any of them with anything. I want all the section breaks deleted in my document since there's about 225 pages of it. Anyone have any suggestions. Thanks for the help.

I was wondering if there was some environment variable i could call from the vba code to obtain the users desktop path since they'll be different because of the Windows version and user profile. i'm trying to copy a file to their desktop automatically but need to dynamically pull the desktop...

Are there are any major security vulnerabilities with ASP coding, ex. buffer overflows, sql injections, etc.. and some good links you can point me to. I appreciate the help.

I have a text box that does a calculation but I want to write some code in VBA to check for #Error in that field and if it is then to disregard it and not give me a type mismatch error. any thoughts?

I have a large client that just recently upgraded all workstations to Windows XP. Running MAS 200 3.70. We have several Crystal Reports and Access databases that interface to MAS 200. The problem we're having is that both interface to MAS 200 very slowly. I mean it crawls. We installed the...

I have the following in code DoCmd.TransferText acExportDelim, , "qryMAS90APExportsSorted", "F:\Export\AP" & [Forms]![frmStartup]![txtBatchNumber] & char(39) & [Forms]![frmStartup]!txtCompanyNumber It says that "Cannot Update. Database or object is read only&quot...

I want to be able to use the remote desktop feature in Windows XP to access a NT 4.0 workstation. Anyone know how I would go about doing this? I'm new to this so not sure of the procedures. Thanks in advance.

I called ISC2 about my eligibility and was told to consult other CISSPs. I sat for the exam this past saturday in Vienna, VA. Signed up as an Associate because of some eligibility questions I had. Here's my background. Graduated from Carnegie Mellon in 2002. While in school I had the luck and...

I have the following code DoCmd.TransferText "qrySelectExport", "f:\inventory\apinvExport.txt" I can export once ok but when i try to export immediately again it says the following error. "The microsoft Jet Database engine cannot open file ". It is already opened...

Ok here's the scenario. I have a form that has 2 subforms so it is pulling from 3 tables. the tables have the following record counts in them table 1: 70,000 records table 2: 16,000 records table 3: 18,000 records These are all tied into a data entry form. Here's my problem. I'm getting...

How would i go about creating a Record Navigation button that will go to the next record but when it hits the last record it won't go to a new record after the last one so that they can't move past the last record and can only add a new record by hitting a button i added to add one. Thanks...

I have a query i join it based on an id number and a date. The date is in the long format where it goes out to the seconds. problem is that the transactions are off by 1 second and i can't group them properly. Is there a way where I can compare the dates only by the month,day,year,hours, and...

I have a list of companies in a combo box and I want a user to be able to select a company in the box and the form to go directly to that record with the associated information (Address, phone,etc) I tried doing a filter by passing a condition to the openform command but no luck. thanks for...

I wanted to set up a report with a huge list of item numbers but instead of having them listed all straight down a page and wasting the rest of the page (empty space to the right of a column) I wanted to break out into 5 different columns on a page so i'm using all the space on a page. it's...

So here's the scenario: 2 Dell Inspiron laptops (3500 and 5000) running Windows 98 SE all of a sudden just went beserk. on bootup it says "suspend-to-disk" file is missing. Not only that when you get into Windows none of the programs work anymore (seems the dlls got all messed up...

I do an openTable so that the user can edit straight into the table. But how can i set it that when they go to close the table or Access to prompt them to save and then also run an append query after they click yes to saving. Thanks for the help guys. I'm new at VBA so i'm learning while i go.

I'm trying to assign a formula to a cell in Excel in my macro code. I'm having problems with the quotes. here's the formula I'm trying to paste into excel from the VBA code. FormulaString = "=if(Indirect(Address(" & row1 & ",3,4)=Indirect(Address(" & row2 &...

I'm trying to determine if the number is odd or even to do my median function that i posted about before. What i'm trying to do is find the record count and then divide by 2 and depending if it's odd or even either go directly to the median or if even then take the average of the 2 middle...

I'm trying to do a Standard Deviation and Median calculation. anyway i can do this within a query such as sele standarddeviation(col1), median(col1) from yada or is there another way i can approach this. Thanks so much.