Search results for query: *

I want to broadcast my wedding over the Internet live. I am over average technically, so I don't think this would be hard for me to achieve. What I need to know: 1) Best camera for the price. Preferably wireless. What do I look for? Trying to be under 150 in price. 2) Bandwidth for...

I can create a sub report on a main report both using pass though queries as a record source when a child/master link does not exist. I cannot use the link when using pass a pass through query. Is there a way to make a sub report on a main report with field linking using pass through queries...

I have a report hooked to a pass though query. When I print the report, the records spools much slower than if I print a report linked to a table. It shows the report printing and the pages 1.2.3.4....10 cycle slower than when using a linked table. I assume this is because the record set is...

I have the following code: ========= Start Code ========== Dim rpt As Report Dim ctl As Control Dim Test As String Test = ReportName_Actual 'DoCmd.OpenReport DLookup("[ReportName]", "tbl_reports", "[ID] = " & pubreport), acViewDesign DoCmd.OpenReport ReportName_Actual, acViewDesign Set rpt =...

For the two following SQL Statements: SELECT * FROM LargeTable INNER JOIN SmallerTable ON LargeTable.ID = SmallTable.ID WHERE SmallerTable.FilterField = ‘Sample’ LargeTable.FilterField = ‘Sample1’ SELECT * FROM LargeTable INNER JOIN SmallerTable ON LargeTable.ID = SmallTable.ID WHERE...

I want to change the value of a label on a report in VBA. I have the report name stored in a variable. The only way I am familiar with modifying labels using VBA is by: Reports!Rpt_TestReport!ReportHeading.Caption = "Change The Report Heading Caption" I need Rpt_TestReport stored as a...

I have sample data: ( * ) is not part of the primary key. Please see the below question. ----------------------------------------------------------- ForeignKey Primary Key Description Code 1059645 *2.009423171 anothername1 thecode1 1059646 *2.009423171 anothername2 thecode2...

I have a sub-report in my report footer section. This sub-report gives a summary group totals in my report. I want my page number reset to 1 on the first page of the report footer. If the sub report spans multiple pages on the report footer, I want the page numbers to be 1-4... I tried...

Does anyone know how to create a new view using Access code (possibly ADO)?

I have an Access VBA application using .send to send emails. When I send an email, Outlook displays a delayed warning forcing the user to wait five seconds that click yes to send. Is there a way to shut this warning off?

I would like to build a custom help file for my msaccess 2000 application. Does anyone know of an article to reference or where to start this project?

I have a combo box with a query displaying three columns of data when I hit the drop down. When I make a selection, the combo box only displays the first column of data. I want the combo box to display all columns after the selection is made.

I have a word document that I want a user to data enter into. is there a field that can be inserted were a user will enter data into a field then tab to the next field?

Is there an easy way to capture the last edit date and time of a record MS Access 2000?

Is there any easy way to capture when a record is edited in a Access 2000 table? A last edit date time?

I have Office 2K installed on a Citrix XP server. I can have multiple users in Access until user tries to modify something. When a user tries to modify something no other users can get into access. The user will get 'Admin' file in use error. The database in design view can be different...

I am running Metaframe XP with an ICA client. I cannot run two instances of access. Once I open any database from a second machine I get the error, Could not use 'admin'; file already in use. It's almost as if Access it's self is not multiuser in Citrix.

Currently I have a SQL 2000 database with a view set up. I have a Crystal 8 report hooked to that view. My View contains a large amount of data ( greater than 10000 recs) and I want to pull specific Job Ids out of the data. Right now I am using the selection expert to get these job IDs. It...

I want to check the size of my database then, it is over let's say 20 Megs, automatically compact and repair the database. I know it must happen as an auto exec. I need to make sure I do not get stuck in a loop if the actual database size gets over 20 Meg. I am looking for a place to start...

I am new to using data outside of my current database. Since reports cannot be bound to a recordset, what is the best way to report on SQL/Server, Oracle or other datasources outside of setting up a link. Let's say through the ADO.