Search results

Hi. Basically I have one of those tab menu's with different headings. Thes last tab has lots of information and I want it to have it's own scroll bar because, the way it is now, the whole tab menu thing gets bigger, even some of the heading with only a few entries. Thanks a million for any...

Yea I tried that. I can only move the borders in a certain amount an dthen it just won't go any further. Right the borders are fairly close to the text , but there is still 2 empty pages in the middle!!! Dec

Well, basically I need to do it because I've to perform calculations in excel and have to paste the contents to a Sheet1 in an existing Spreadsheet, and I don't want the user to have to highlight all the records and paste each time.

I ned Access to automatically copy th entire contents of a query onto the clip board when that query is opened. Is this possible?? Thanks

Hi all. Well, this is my problem, I generate this nice report based on a query but when I go to preview, the first page is grand but then it skips about 4 blank pages before showing the next page. Does anyone know how I could fix it so as all the information is all in a row, i.e. 1st page...

Hi. Does anyone know a way of having lets say a master templeate report based on a table and then being able to create a instances of that report based on individual records in the table. So, for example, if the user clicks on House it shows the record relating to "House". Thanks a million, Declan

Hi. Ok, this is what I have to do. My company has different locations with certain information associated with each site (like address, engines, safety record etc). All the information for all the sites are storded in the same table. Grand. But I have a map with buttons for each site on the...

Hi. I have this code that is supposed to convert my Date's in string format to date format. This is because when I copy and paste from Access to Excel, dates are screwed up :-( Right now this macro only converts the first cell. How can I modify the code to convert all the elements in the...

Hi. Basically I wan tto know is it possibe to create a calculated field in a query that is based on data from 2 other fields in the same query but is only displayed when a text field in the same query contains a certain string of text. E.g. Field1: Field2/Field3 [But onle display when Field4 =...

Hi. I was wondering if someone could answer this question for me?? I have a form that takes in a bunch of data. My company has all these machines that sometimes are turned off. There are 5 different reasons they can be off:Planned outage, Forced outage, Routine Inspection, Derated hours and...

Thanks :-)

Hi. Does anyone know how to properly create a search record button?? I put one into a form of mine and when I click it I get the prompt to enter my 'Log number' but when I click OK it says it can't find that record, but I know its there. I want the details of the chosen record to be displayed...

Hi. Ok, I've got a yough one! What I need to do is use a form to generate a report that contains information that the user selects. Basically the user sits down in front of a form and specifies what data from the Master table that they want displayed in the report!! Can this be done at all...

Hi. Basically I have a linked table to an Excel spreadsheet. What I want to do is send the contents of a query to that linked table. I know it's something to do with the append function, but could someone help me??? :-) Thanks, Dec

Hi. Hope someone can help me?? I have the following code that I want to use to return a value: Option Compare Database Option Explicit Function MW(MW_before, MW_after, Start_time, End_time) MW = ((MW_before - MW_after) / MW_before) * (Start_time - End_time) End Function But when I use the...

It worked! Thanks a lot :-)

Hi. I have an Excel file and I want one of my forms to open the Excel file when clicking a button on the form. Can this be done?? Thanks

Hi. What I need to do is to use a drop down combo-box to create five different options (that I've done). The user then selects lets say option 1. Then later on in the form there is another question to enter a number, lets say 200. I want access to put the 200 into the column relating to option...

I've created a module, but what is the command I have to include at the end of the code to make it return its value to a query instead of a Debug window?? Thanks a million :-)

Hi. Your probably going to think I'm stupid for asking this. I've got a module that performs a task on a list of times, and I need to use it in calculating a figure in a report. Can this be done?? Thanks