Search results

Hi guys, I've pulling my hair on this issue for a day now. I have a subform that can be filter using date ranges. When a date ranges is select, I get a subtotal on the subform; however, I want to keep a running Grand Total on the main form regardless if the subform is filtered by the date...

I have an adp that was created in Access 2003, but now we are in 2007 version. When I open the adp file (connecting to SQL server), I can't seem to edit the report, queries, or adding more reports to the project. Everything appears to be locked. Have anyone seen this before? Thanks. EZfriend.

I have a main form and a subform that was originally design as a one-to-many relationship. Now the users want it to be a one-to-one relationship. The logical way is probably moving all of the fields in the subform to the table where the main form is loading from. For one db, it is probably...

Have a query the return the search result as follow. (note that I have thousands of rows as the query results) ID Name DateEntered Comments ---------------------------------------- 1 Joe Johnson 2/2/2009 Comment1 1 Joe Johnson 2/2/2009 Comment2 1...

How can I return a recordset using adp.connection my recordset is "SELECT * FROM vwCustomderDat WHERE CustID = 223234 " Private Sub Process() Dim rs As ADODB.Recordset Dim sSQL As String Dim sVals As String Set rs = New ADODB.Recordset sVals = "" sSQL = ""...

When I run this in Access, I get an error. ALTER TABLE [tblName] ADD COLUMN ReviewComplete BOOLEAN What's the proper way to alter table with boolean field. Cheer. Thanks. EZ

Here is a scenario that I like to get some opinions from the forum. We have an Access application (FE) that access some databases from SQL Server Express. All of the databases (tables, views, etc...) are identical with the exception of the data in the tables for different databases. [Yes...

For some reasons, my MS Access application doesn't allow me to right click on forms, controls, tables, etc to get the properties. It appears that the right click is some how disabled. I was able to get one of my computer to work by following the instruction on one of my previous post; however...

I have two textboxes which represents a search and replace In these text boxes, I want to allow user to type in "banana " so that it can be replace with "banananospace" It appears that the space after "banana " is always autotrim by Access so the space at the end is trimmed off when the...

I have an Access application that allow user to replace text within a NTEXT field (SQL Express). Unfortunately, I can't do the normal update UPDATE tblDoc SET FieldName= REPLACE(FieldName, '; ', '|') Any advice is truely appreciated. -EZfriend.

How can I PROGRAMATICALLY import a table from one Access database to another? I see a lot of example for import text file, csv, excel, etc, but could not locate one with Access to Access. I know the "manually done" way, of course, but need to automate the process. Thanks a lot in advance...

I have a query that returns something like this. Field1 Field2 Field3 -------------------------------- 232 223 344 I want to display it as Field1 232 Field2 223 Field3 344 How can that be done? Please point me to the right direction if you can. Thanks. Note: Field1-3 are...

I have a form that is open as a dialog form. Is there a way to determine what the position of the form is on the screen (not Access windows). Is there a way to check if a user drag the dialog form to a different location on the screen? I want to get the x and y position so that if the user...

I was playing with some VBA to enable and disable all MS Acces default menu. Now my right click is no longer working (disabled). For example, I cannot right click on a form and choose properties. I am not sure how to turn the right click options back on. Please help me out. Thanks. -EZfriend

How do you unlocked the navigation pane in MS Access 2007? For some reasons, I just can't unlock or resize the navigation bar. See attached picture for more info. Please help.

How do I open the printer printing preferences with the click of a button? The question seems easy enough, but I just could not find any good code for it nor come up with my own. Please help. Thanks. EZ

Does Access has the capability to create a form, let's say in the shape of a triagle? Besically, I want to hide the default form (box) and only show the section of a picture (PNG with transparent background) that's not transparent. Thanks in advance for your suggestion. EZ

I have a report that the Report Footer section display a total of some document counts; however, when export to excel file, only some of the data were exported and some are missing. The settings for all of the controls in the Report Footer section are the same with the exception of the...

I have an application that uses the ListView Control 6.0. The click event check for the number of list items in the listview. If the item counts is greater then zero than it calls a sub routine to check for the ID in the database based on the item selected. I keep getting the error below when...

HAPPY NEW YEAR TO EVERYONE May the New Year brings you good code and prosperity.