Search results for query: *

Hi, Is it possible to import an existing .CSV/.TXT file that contains vaules straight into a conditions "in list" list? If so - how the heck do you do it? Thanks in advance for any help/pointers! Cheers, Supanoods B-) "If it aint broke - dont fix it!

Hi all, I have 2 spreadsheets on a network. One is a master data file, and the other is like a "viewer". The viewer is refreshed every night via VBA code from the master workbook. The code simply opens the viewer, copies data from master to viewer, saves both and closes both. The viewer is...

Hi guys, I am currently working on an excel program that looks at personnel details. I have one worksheet that has names, addresses, etc and another that is a nice user-frienly front end type of screen. On the user screen, I have added a drop down list and set the entries to a named range on...

Guys, I have a form/subform setup where the main form uses a child subform to check if a 'code number' has already been changed. The subform is based on a query, and if the code selected from the parent is not present on the child form, then I get the 2427 runtime error due to NULL value. I...

I have a listbox that displays 3 columns, which display 3 characters per column. I want to see the 3 columns, and I have plenty of room to display, without needing a scroll bar. However, Access brings up the bar, and the user can click on it to move along each column individually. NOTE: i...

Hi guys, I have a form (FormA) that after a couple of criteria filters, displays failure codes for a system. The user then double clicks a code and a popup form (FormB) appears that is half filled in, and the user finishes it off and submits a change in status of that code. Back on FormA, a...

This must have been covered before - but I cant see it anywhere. I have a textbox (DepotName), and is hided. In the title of the form (label), I would like to display something like: "DEPOT CHOSEN: ("DepotName.Value")" Can anyone help Cheers, Supanoods B-) "If it aint broke - dont fix it!

Hi - I have a general method question, I have to create an ACCESS db that uses a big .CSV file on the company server. The .CSV is replaced and updated daily, but the field structure remains the same every time. I need to find one column of info from the .CSV based upon filtering 3 other...

Hi, The code below transfers 2 queries to a .csv file, and opens a .xls file that then manipulates the .csv data. It is an Access97 DB, and it works perfect on my WinXP/Office2000 PC - but not at all on any PC's that have Office97 installed. I get an ActiveX error, or an 'automation' error...

Hi, I am attempting to export an Access Query into Excel. the query parameters are defined by a form that has a combo box on for a choice of "Machine". The choice of Machine defines the query. My form is called "ExcelReportsForm", and my query is called "MachineByPart", the Machine combo is...

Sorry in advance if this thread has been covered somewhere - but I have searched and searched for ages, and found nothing! What is the VBA to open an Excel SS from Access 97?? I am stumped :( Thanks in advance! "If it aint broke - dont fix it!

As the title suggests - Can I have more than 9 "OR" statements in a standard query???? I have 13 fields in my table - besides 1 being numeric - the rest are text based, and I want to be able to search upon. I am using: Like "*" & [text] & "*" within each text-based OR statement within the...

I'm not the best VB coder in the world - always no enough to get me by, but have now hit a stumbling block... I have a standard data entry form and at the bottom a SUBMIT button (basically creates a new record and clears the form). At the moment there is no confirmation of the new record being...

This is bound to have occured many a time before - so if someone knows where please direct me! I have a table called "machine" which holds two coloumns - machine name and area. The area is chosen from a table called area. The values for area are 1,2,3,stores. I have 2 combo lists on my form...

I hope that I'm not re-asking a question from before - but I could'nt find this in the forums! I have been asked to set-up a run-of-the-mill "action plan" dbase. Basically a manager can create a plan of work to do, and then his team can view/edit/create records of thier own accord. However...

Hi! I am developing an access 97 based machine downtime system for the factory that I work in. The bulk of the work is done, however as a last minute decision - I have been asked to implement a startup login and password clearance screen. I have a table ("personnel") that includes the...

I currently open a .log file (like a .csv) and import it into excel to make a .xls file. The .log file however is growing all the time and is updated from another source every ten minutes. This means that it is undesirable for the .log file to be open any length of time. Is it possible to...

I was wondering if anybody can help me! One of my collegues has left work and I need to access one of his spreadsheets - but it is passworded! Is there anyway you can get by this Cheers Phasid "If something is hard to do - then it isn't worth doing" - Homer Simpson

I need to be able to count how many diffrenent values there are when i use an auto filter. For example: The contents of my column are: 3,4,8,8,5,4,6,3,8,3,2 therefore the filter when clicked shows : 3 4...

Hi, Can anyone tell me if it is possible to use a dynamic array as a dataset in Delphi 5 and if so, how is it done ? I want to use QReport to display my data in report form but I understand that this requires a 'dataset' to provide the source data. If possible, I'd like to use the existing...