Search results for query: *

I have a project where I take an excel form with three sheets and import the data into access. I have got it working using: DoCmd.TransferSpreadsheet acImport, 8, "tbTechnical", "C:\CNS Excel Import\Email_CNS.xls", True, "ExportTechnical" DoCmd.TransferSpreadsheet acImport, 8...

Probably a basic question but I importing 3 excel sheets(Cust, tech, survey) into access tables "Customer", "TempTechnical", "TempSurvey". The excel workbook comes in from multiple locations and, once imported,it is deleted. I have sorted out the import using VBA. this works fine. The Access...

I have an excel workbook which is emailed to me from different people. In this workbook there are 3 sheets Techinfo;Customerinfo;requestinfo I have created an access database with 3 tables that have the same name. The data imports ok (It would be great if you could import all 3 sheets at the...

I have been using the VB editor for years without any problem now, suddenly, it has a mind of its own. when I type me. the "[COLOR=red]me.[/color red]" turns red immediately and the object list, which should open after me., just flashs for an instance and then disappears. if I continue the line...

I have an subform on my main form. This sub form has 4 listboxes which are used to populate textboxes on the main form. This works fine but when I go to a new record and then enter the sub form, the listboxes have retained the selections from the previous record. It's probably very simple but I...

Is it possible to show/hide a field (xyz) in a report depending on the value in that field? e.g. field(xyz) has text then field(xyz) is made visible else if field (xyz) is blank then field(xyz) is hidden TIA 'Life is what happens to you while you are busy making other plans' John W. Lennon...

I hope the following makes sense. I have set up a query that is populated from a record that uses six tables, all linked to the main record number. This works fine and I can see all the data required but occasionally it does not populate. I have to move away from the record, open the query and...

I have an unbound listbox which gets its value from a query. When I run it, the listbox is blank. when I go to the properties of the listbox, the rowsource is missing. when I select the query from the dropdown box, the missing values appear in the listbox. As soon as I go to the next record I...

I have a textbox (customername) which, in the AfterUpdate event shows a listbox which is populated with any existing customer names in the database (user can either, select from this listbox, or carry on with the data entry. All this works fine but what I would like to do is to only make the...

I want to show a record based on part of a string i.e.when I enter a customer name into a field[Cust_Name] In the afterupdate I want to use part of the name e.g. "Bloggs" from the entered name "Fred Bloggs widget co." to search for all records with "Bloggs" in it and show each record in turn...

I have an excel form which, when it is opened normally will open maximized but when I put workbook protection on, the next time it is opened it opens in a reduced sized window I tried the following without success: Private Sub Workbook_Open() With Application .WindowState =...

I have a mainform(fmMain) with a linked subform(Data_Selected). I have a listbox in the subform which is multiselect. as soon as I click in the listbox, I get an afterupdate error message "object or class does not support the set of events", Even when the afterupdate event does not have any code...

I have recently migrated from VB programming behind MSAccess and am following lesson09 in the visual basic 2005 express edition regarding updating Database records using a very simple example but, no matter what I try, the source table is not updating. One would presume the instructional video...

I have just moved over from MSAccess vb Programming to Visual Studio and I am stuck before I have really started. I have followed the help video files that came with visual studio and also read and reread the help files. I created the database with a single table (as in the video)and 3 rows of...

I have a database which has a listbox where you can select a name from the list. this name is placed in a text box and what I want to be able to do is: edit the name and replace the corresponding record with the new name i.e. delete the old name and replace it with the new name. I don't want to...

I have a table "tbMain_Rec" which contains, amongst others, two fields [Call_Vol] and [txtDate] if I use a basic dsum function eg. Vol = DSum("[call_vol]", "tbmain_rec") the resulting 'Vol'= 75 which agrees with a manual count of the contents of the [call_vol]column but if I use the following...

there is probably a simple answer to this but at the moment my brain has powered down and not rebooted yet! I have two tables (1)"Cust_Details" and (2)"Daily log". "Cust_Details" lists individual customers,item, date ordered, Value of order,Payment received etc. "Daily Log" is for telesales and...

Is it possible to programmatically convert a report to pdf and then email it as an attachment TIA 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

Is it possible to show list box contents over multiple columns instead a long single column? TIA 'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

I have a main form which has a button to open a sub form. this subform has a listbox which allows multiselection of items. I have a variable that holds the resulting string. what I want is that when I close the sub form I want this variable to populate a text box on the mainform so that the...