Search results

(Scroll to the bottom post for final answer & code) I'm trying to piece together other techniques and here's what I have so far, but it's stuck on Excel reference in Shell (No Active X component). There's got to be a cleaner way to do this! HELP. Public Sub ConvertCSVtoXL(strCSVPath As...

I have a subform which already uses a combo box w/code in the After Update event. This code works. When I add another command button to the same form in the On Click event, Access seems to ignore it. I've inserted a test Msg but that is ignored. Also I believe that debug is somehow turned...

On a form I have 2 search unbound fields called keysearchword and guestsearchword. Each has an On Exit event that performs their respective searches. If IsNull([Keysearchword]) Then strLinkCriteria = "[Keywords] Like '*'" Else strLinkCriteria = "[Keywords] Like '*" & Me!Keysearchword &...

I've walked through this in debug over and over and I just don't get why I keep getting "substring out of range" error at the statement If (CCur(Fields(28))<>0) Then I've attached the bmp to show the code (hopefully I uploaded it correctly)

I've created a form with Record Navigator which allows a user to create a new record. When the form is opened how do I immediately put the user into add mode by default? Thanks

Based on a footer code, I'm trying to shrink vertical heights, but the code below just doesn't want to listen. Any ideas? If BudgetCategoryReportOrder = 4 Or BudgetCategoryReportOrder = 5 Then Me.txtBCROSubtotal.Visible = False Me.BudgetCategoryDescription.Visible = False...

Is there some field or VB command that will suppress "You are about to append 1 record?

I am using extensive Hide fields in VB code based on group conditions and these are working However, the vertical space remains upon hide and I set "Can shrink" to yes. But the text field called "Subtotal" does not allow "Can shrink". Is there any other field I can set or suggestion I can...

How do I maximize a form at startup?

Wow. I'm converting an old database which, through a query, references (what looks like) a table called "gross_charges", yet that "table" does not appear in the tables module, even with Hidden and system tables option turned on. I don't see any flat files by that name anywhere on my machine...

I copied over tables, forms, reports, etc from another older database into a conversion database. A module that uses this construct in the old database... Dim db As Database Set db = CurrentDb ...generates "User type not defined" in the new database. Why? Thanks, Paul

In my report I have an unbound key field in the Page Header whose control source is tblFacultyBudgetHeader.FBH_PK, fed by a form value. I have added a subform onto the report in a footer group which requires two linked keys, FBH_PK and BudgetCategoryCode. Thus, upon completion of the subform...

I have a subform on a report. However, it is appearing in a Group footer. How can I control the printing of it (and/or its contents) so that it prints ONLY under 1 group? TIA

Item A is in a table as currency. Item A also winds its way up from subqueries into a final query that is used on a form. However, the form does not show it as currency nor with commas. When I try changing the format property the drop down shows nothing and even if I type Fixed or Standard...

How do I loop through a small table plucking out the key until no more records? At each pass I want to perform an insert into another table (I think I've got that part down...just don't know how to loop through a table) TIA!!

I'm using the code below in a form. Each msgbox yields a correct entry, including the Insert string. However I am getting an "Enter parameter" dialog box for each of the 3 values and don't know why. Is my syntax on the Insert statement in error? Private Sub Add_FB_Detail_Click() Dim...

Why is this not a valid construct from within a form? Specifically, when I put in the msgbox the whole operation just simply fails (no msgbox, no breakpoint). It works fine when I take out the Msgbox Dim db As Database Dim QD As QueryDef Dim RS As Recordset Set db =...

I've heard that you can't get access in the vb code to any of the fields in an OpenQuery and that you either have to do a DLookup. Yet here in some production code I found that the field [annualizedcharges] is being stuffed back into an update table. When I use "msg [annualizedcharges] the...