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

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

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

is there any code that can list out all tables, queries, forms, reports, macros and modules so I can capture all the object names and their modify date?

I'm trying to loop through a directory based on locations and file names that are in a table. Everytime I run the code I get a bad file name/count when trying to set strFileName. The files do exist and will work if I hardcode these values into the code. Any help would be apprectiated...

I have a continuous form that is open through a pervious form as follows: docmd.openform "frmContinuous",,,"[price]=1.00" What I'm attempting to do is narrow down the search even further once the continuous form is open. To do this I created a list box on the form heading with the following...

Currently I have a report that is open with the following code: Private Sub Command242_Click() Dim strCriteria As String strCriteria = "[Status]='O'" DoCmd.OpenReport "rptAllIssuesUnion", , , strCriteria End Sub Is there a way to send this same report through an email? When I use...

I'm calling code when a form is opened to return the user name and pass it to a field on the form. Everytime I go to open the form I get an error, "Object doesn't support this property or method (Error 438)". I've used this code before to write to a table without any problems. Any ideas...

I have the following code that works, but I'm wondering if there may be an easier approach code wise. Basically I have 3 radial buttons that the users can select. Once selected they are they prompted for a search criteria. They can have any combination of the 3 radials. Dim strCriteria As...

I'm writing a Crosstab and the problem that I've run into is my total column shows a repeating decimal even though there are only 2 decimal places on my field. I've tried converting the field to currency, double even tried to run a trim on the field all with the same results. Any idea?