Search results

I have ActiveX Calendar Control 10 in Access 2003 on a form that is called from another form that feeds in a date in OpenArgs. The date will NOT be today's date. I need to have the calendar set to that date. All threads dealing with setting the date seem to set it to today's date. How can I set...

I have a report that has a sub report in it. The report runs fine except the sub report doesn't show up at all. When the sub-report is run by itself. When I try to open the report I get a message that says: "You can't use a pas-through or non-fixed-column crosstab query as a record source for a...

I have two database which are very similar. They both use the same back end table. I have a query that I developed in one db and it works correctly there. However, when I import it into the other db, I get the Ambiguous Outer Joins message. I've tried copying the SQL from one and pasting it into...

I have the following code: Do While Not rs.EOF If Not IsNull(rs!EMail) Then str = rs!EMail DoCmd.SetWarnings False DoCmd.SendObject acSendReport, rptstr, acFormatSNP, str, , , rsn!SbjLine rs.Edit...

I have two table with the same key field. However, in one table it is a text field while the other is a number. I created a query from the table with the numeric key and converted it to text using the str() function. When the query is run, the values appear, left justified as if they are text...

I ran across a database with a switchboard that had buttons with labels. Any time the cursor was over either a label or its button, the label's font would be bolded and when the cursor was moved away, it would return to normal. I never got a chance to look at the code. In vb2005 express, there...

I was playing with vb2005 express last night and doing an exercise which changed the text on a button controled by the MouseEnter and MouseExit events. This worked fine. I then decided to try it with a lable to set the font to bold when the mouse entered the label. I got an error saying that it...

I have the following query, named "Query9" (Right, I didn't assign it a name when I first created it). Its SQL is: SELECT LA.DL_ID, LA.UPB, LA.[FMLNo] FROM LindActivity AS LA UNION ALL SELECT [Q].[Deal ID],[Q].[CSUPB],[Q].[CBIID] FROM [qry_DSRCB] as Q; Both LindActivity and qry_DSCRB are...

I have the following calculated field in a query: LoanNo:IIf([Stats].[LoanCnt]>1,[Stats].[LoanCnt] & " Loans",[Loan].[LnNo]) Within its query, it correctly displays the loan number associated with a particular loan. However, when I run a second query SELECT LoanNo FROM qryLoanInfo it comes...

I was looking to buy a copy of VB 2003.Net and no one seems to have it. The closest I've found it was in CompUSA.com and they said they were out of stock. Checked Microsoft's website and searched for Visual Basic, they didn't list it as a product, only had a couple of references to it. When I...

I have the following commands DoCmd.Rename rptstr, acReport, rsn!OldName ... DoCmd.SendObject acSendReport, rptstr, acFormatSNP, str, , , rsn!SbjLine The first line works. The names of the reports change The second line also works - sort of. The correct report gets e-mailed to the correct...

In a database for a lending institution, there are Deals and there are Pools. Deals are made up of Pools. Deals go on for a long time while the Pools within them mature and are either paid off or rolled over into another Pool (with a different Pool Number. I have a union query that stacks the...

I have the following code (from Access Help) that prints out the names of my tables. Sub AllTables() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData ' Search for objects in AllTables collection. For Each obj In dbs.AllTables ' Print...

I have a table with a text field to receive dates or "na" or "n/a". From this, I am trying to run a query that selects all dates that are not "na" and not "n/a" and not null. This works fine with a criteria of "Is Not Null And Not In ("NA","N/A")" The problem is, I also must select a date...

Double clicking either of the two reports in this database causes the database to look up the name of the report in a table and get a list of the criteria that the report uses, the text for the criteria label, location on the criteria pop up form, etc. and opens the form. When the button is...

Please look at this sql statement and tell me where the error is. When I try to open the recordset, I get a "Too few parameters. Expected 1" error. That kind of error usually goes with missing # on dates or ' on text DateTime is a DateTime field that defaults to Now(). The problem appears to...

Is anyone familiar with the use of this? The help files don't provide anything that looks like an example of its use. The help files say: "Returns a DependencyInfo object that represents the database objects that are dependent upon the specified object. expression.GetDependencyInfo()...

I have a database which records the user ID and login time into a two column table: User DateTime which drives a query User DateTime DayOfWeek I would like to create a crosstab query which shows day of week across top and user down the side and DateTime in the Values section. The problem is...

I have a database that has just been split. In the back end, I don't see the tables. I have gone to Tools>Options>View and found that Show Hidden Objects is checked. When I go to the front end, the links to the tables show up and I can open them and see the data. When I check the Linked Table...

I just started using A2003 and find the Dependancies feature very useful. However, I can't figure how to print them other than by doing screen shots. Is there any way to print the dependancies?