Search results for query: *

i'm new to this asp.net stuff so talk slowly. here is what i'm trying to do. page has a gridview on it. one of the fields is a dropdown list. if the user selects a specific value than i want to a popup window to open requesting additional details. The process will get to my...

I have a report that page breaks on various stores. Each of these stores will list various products. I want to prevent a store from printing if their section of the report exceeeds 3 pages. thoughts?

i'm connecting to a document library to run some comparison reports through Access 2007. The problem that I've run in to is that there are a couple fields that are pulling in to the database without any values. When compared to the SharePoint view I'm able to verify that data does exist for...

i'm connecting to a document library to run some comparison reports through Access 2007. The problem that I've run in to is that there are a couple fields that are pulling in to the database without any values. When compared to the SharePoint view I'm able to verify that data does exist for...

I'm having issues with selecting cells when I export queries with the below code. I keep getting an error "Select method of Range class failed" with the Sheet.Cells(2,1).Select portion. I'm able to get this to work when I only have 1 worksheet, but when I have multiple sheets I get the error...

i'm in the process of implenting a new standard across my forms. Can I write a process that would insert the same call process through all of the forms in my database. I was able to find code that creates a new form then writes the events behind the form, but this would be for an existing set...

lets say I have the query: SELECT * FROM tblSample WHERE tblSample.date Between [Begin Date] And [End Date]; when a user runs the query i want them to be prompted for the dates, which works. question - Can i call this query from VBA and pass in values for these so that the vba is not...

solved: just needed - .Columns("B:B").Select .Selection.NumberFormat = "@" thanks for looking

Can you use something like this? Function IsRunning() Dim strTerminateThis As String 'The variable to hold the process to terminate Dim objWMIcimv2 As Object Dim objProcess As Object Dim objList As Object Dim intError As Integer Dim blnRunning As Boolean...

i have the following function that will export a query to a spreadsheet. The issue is that when the value of the field has any leading zero's they get dropped. I don't do much with Excel so I'm not sure where to look first to resolve this. Any help is appreciated. Option Compare Database...

I'm running a series of SQLs and would like to have title per SQL. However if no rows is returned for one of the SQLs I'm not getting the title for that specific SQL: SQL: ttitle 'sql 1' select count(*) from table1 / ttitle 'sql 2' select count(*) from table2 / ttitle 'sql 3' select count(*)...

Lets say I have DatabaseA with tblOriginal and somebody creates DatabaseB and creates a link to DatabaseA.tblOriginal. From DatabaseA can i identify that DatabaseB and any other database that is linked in to tblOriginal?

i have a list box with 100's of rows. I'd like to create an unbound field that as a user types it will begin to filter down the list. Has anybody attempted this and would you be able to point me to some examples? Here is basically what i've tried: Private Sub txtSearch_Change() Dim...

I'm attempting to import a fixed length file with the following code. The issue that I've run in to is that if there is a comma in the line Access is treating it as a line return instead of a place holder. Any ideas: Function ImportFile() Dim recTable As Recordset Dim strTheFile As String...

nope, it's a single select list box. And let me go into a little detail of what I'm up against. The list box is populated with a listing of values found in a table. One of the items can be a Null value. If I use a statement that says, if isNull(me.lstOrgRes) = False I would get a...

after an item is selected from the list box and the After Update event is fired, it is not recognizing that an item was selected and returns the mesage box, "bs".

I'm having issues with the following code that works on a command button but not on the after update of the list box. I really need it attached to the after update listbox. Any ideas what I'm missing? Private Sub lstOrgRes_AfterUpdate() Dim ctlOrgReg As Access.Control Set ctlOrgReg =...

Public Function Find() Dim db As Database Dim cnt As Container Dim doc As Document Dim intCount As Integer Dim strForm As String Dim strDate As String Dim strDest As String strDest = "database location" 'to be replaced with a recordset...

sorry about that. Apparently I just needed a couple more minutes to figure this out. Thanks

Thanks for the response. I've been able to find the pieces that I need to scan the current database. Is there a way to incorporate this to scan a list of databases? The goal would be to have a table listing the location and names of the databases to be scanned. The code will loop through...