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

I wanted a vba function to do this as I have several states to do. If there is not one, I will just import the spreadsheets into Access and use a query to find unmatched license numbers. Thanks anyway tho.

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

txt1 and txtValue1 are both unbound text boxes and yes we must keep the table data for five years.

The questions will change every year with evry state.

Thats the whole problem. I don't know what the column(field) names are. This is what's happening. Its a review program where the questions change for each state. I let them create their own table adding the fields needed for each state and naming the table with the state and the year...

I have decided not to use a query but this code instead and it works so far. Thanks for the help tho. Dim strUnd As String Dim strState As String Dim strFilter As String ' Build criteria string for Underwriter field If IsNull(Me.PickUnderwriter.Value) Then strUnd = "Like...

If I put the code in the reports Open event I get this error You can't assign a value to this objec pointing to Me.txt1 = r.Fields(30).Name

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

Thanks, that works great. Lisa

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

Thanks for all your suggestions. I think I do agree with Skip and when the customer is added to the worksheet I will put all that data into a table and then link to that. It is good to know how to loop through all the worksheets for future use. Lisa

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

Not getting an answer, I started with the list index number and found tha 6 did what I wnated with FormatType = 6. Thanks Lisa

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

Thanks Mike, you post helped fix the report. Lisa

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

I got it with this. DoCmd.TransferText acExportDelim, "WaivedAudits", "tbl AcctWaivedAudits", "\\fs3nt\qa\billing\io\WaivedAudits" & strDate & ".txt" Thanks Lisa