Search results for query: *

Hi, I have a form that I need to spawn pages. As it is now I have a document array and a combo box. When a selection is made in the combo box, the StateAmt field is populated from the array. This all works fine now, but I need to be able to make this coding work with spawned pages and need a...

Hello, I am using Excel 2010. I have a workbook with two worksheets (AIS-BGI and NIPR-BGI). I need to compare the licence number in column A on both sheets. There is also data in other columns on both sheets that do not match but I want to compare column A. Any entire row from NIPR-BGI that...

Hi, I am trying to set a control source for a field on an Access 2010 report by using the field number. I don't know what the field name will be. I can return the field name on the report but get an error trying to set a fields control source to that field. The error I get is "You can't set...

Hello, I am using Access 2010. I have searched and cannot find a way to add a table to a query based on a forms combo box selection. The reason I want to do this is that I will never know which table the user wants to use for a report. I want to use a query because they also need to have the...

Hi, I am doing a major overhaul on a database, deleting old, unused fields and they also want to change the data properties of the zipcode field. The field was formmated as text with a field size of 5. They want it to be a 10 digit field with the dash now (11111-1111). While I am deleting...

Hi, This is Excel 2000. I have a form where the user enters a next visit date. I am trying to stop the user from entering a date that has already passed. I have this as an error checker but it does not work, just lets the form unload and enters the past date. stDate1 refers to the value...

Hi, I have an excel worksheet where they can add new worksheets (2) for each customer. The worksheets will be named according to the cusotmer's name such as Joe-Branch, Joe-State, Lisa-Branch, Lisa-State and so on. I need to create a summary sheet based on what they enter on those sheets so I...

Hello I am trying to export crystal reports data to excel but there are probably at least 20 extra columns when I use my code to run the export. When I manually export to excel using the format 'MS Excel 97-2000 (Data Only)' it works perfect. I don't know the correct way to code the data only...

Hi, I need to make different criteria depending on the current month. The report I have set up for every month, no matter what month it is has this code. ( {joblog_.FREQUENCY} = "MONTHLY" and INSTR({Joblog_.DISTRIBUTION}, "AC") <> 0 and {Joblog_.DISTRIBUTION}<>"AC/TW" and {Joblog_.JOBNAME}<>""...

Hi, I am trying to export a tab delimited text file to the network using the UNC path but get "Cant update, database or object is read only". I can manually export to that location but using the UNC get an error. If I take out the UNC path and put a regular "N\HOPA\Billing" path it works also...

Hi, I am using the sample code and do not get the results I want. I am trying to combine all software records per HardwareName field. There is a seperate record for each software in the table for each hardwarename. Example Server 1 - Windows Server Standard 2003 Server 1 - Adobe 9 Server 1 -...

Hi, We are converting our Word 2002 templates to Word 2010. In the old Word our code for the userform initialize event we used this code and it worked fine but does not work in 2010. If ActiveDocument.FormFields("bmDaily")= True Then Me.ckDaily.Value = True Else...

Hi, I am creating a form in access with a combo box that is not 'Limit to List' but I don't want the user to be able to enter a period, e.g. 'NT 4.0', because what they enter is going to become a new table field name which does not allow periods. If it is possible, how do I restrict them from...

Hi, We are converting our XP templates to 2010. I have a workbook that has links to seven other workbooks. In the old version, when we opened the main workbook (Time.xls) it would ask us if we wanted to update links. If clicked Update then all the links would update (as they should). In the...

Hi, Trying to add a custom format when I add a field to the table with vba. It is a number field that I want to force to two digits. Instead of 6 show 06, etc. I know how to add the field but not the format, I get errors with with this: Set fld = tbl.CreateField("MYMYMYRevOR", dbLong, "00")...

Hi, I want to add a couple fields to an existing table and change the properties of a current field. I can add the fields but trying to update the properties of the date field I get an error using fld.Properties("Format").Value = ShortDate ALso is there an easy way to change the default...

Hi Excel Experts, I am trying to find a way to add a note at the bottom of a worksheet if the value of any cell is over $7,000,000. I don't want to add a formula for each cell if possible, the spreadsheet is large, but use a range instead. Is there a way to say if any cell in 'Range' is over...

Hi, Is there a way to create a report group depending on certain criteria. I am new to crystal reports, still learning. I have a due date field. If the due date is 1 then I want to group by Job but if the due date is anything else but 1, I want to group on Flowchart. I have no idea, thinking...

Hi, I am new with crystal reports and don't have any idea how to write the following criteria. I do know that I am not getting the correct results and maybe it is how the report is set up and not the formula I am using which is: {joblog_.FREQUENCY} = "MONTHLY" and {Joblog_.DISTRIBUTION} <>...

I am really new to Crystal but do know some VBA from using Access. I am using the field Frequency Notes. If the field is blank I want that record to show or...if the current month (now is April) and the field contains a 4 then to show that record. Data in the field could be: 1,2,4,5,7,8 or...