Search results

I'm writing a method that takes info from a Table and exports it to a Excel spreadsheet. Is it possible to capture the names of each field individually so I can setup the column names of the spreadsheet? Ta.

Hi Folks, My first foray into Excel Spreadsheet creation has hit a snag. I can create the spreadsheets and populate them with data as required however for some reason VBA does not recognise .SaveAs as a valid action. Funnily enough even when I try to get a list of available actions from any...

Is it possible to just print the contents of a subform ignoring everthing on the main form? I haven't got the foggiest on this one... I dont think it is... Any help appriciated. Cheers

This is probably an easy one but I can't seem to work it out. I have a combo box linked to a table containing [Customer Name] and a [Serial Number] an autonumber key. On the same form are two subforms, GBS Clients and ACBS Clients, linked to the main form via the [Serial Number]. My problem...

Hi Folks, Have a problem that has jinxed me for a while. I am using a Combo Box to select a customer and in the "On Change" event I have VBA code that takes the value of the user input in the Combo Box and uses it as part of an SQL query to populate various Fields depending on the input. My...

Is there a generic way to pass the reference of a control to a module(Like you use "Me!" for the current form)? What I am doing is calling a sub that executes everytime a user enters or exits a field passing a refence of the current control to the module. I.e private sub my_Control_GotFocus...

I've written a smallish chat room program in access 97 for my team at work to "boost productivty". What I need to know is, is there a way to create a pop up message box that appears when the access screen is minimised, ala Microsoft Messenger?

Hi, Simple one here. I have a table with loan numbers and the associated loan information stored. What I need to do is pull every record where the loan number has been duplicated. Cheers.

I need to pass a boolean value from one form to a second form (a pop up screen) and then back, this seems like such a simple operation but I can't seem to work this one out. ARGH!!! Sorry, the Topic should read Variables... Not sure what varibales are... [This message has been edited by...