Search results for query: *

Hi all, I've had this brilliant idea to create a map of our offices and be able to graphically map the locations of all our office equipment, connections, peripherals as well as other information such as ip addresses and a comment if the equipment is down. So far I've created a form and...

Access 2k I haven't yet seen anything really good on this question so I thought that I'd pose it myself. I create a lot of queries as excel spreadsheets because they are far easier to sork with for clients etc and unfortunately, not everyone has access. A write a lot of little functions...

Hi, Using Access 2k I've got several scripts that I run that use the DoCmd.OutputTo function to output data from temporary tables in access into new excel spreadsheets. My problem is to do more with formatting. I want to automatically create a heading and insert a date so that my report...

Hi all, Using access 2k I have a form that is called "frm_Receipt", this form is set to data entry mode, and it's data source is a table called "tbl_RMADetails". Out of the 5 text boxes and two buttons on this form, two of the text fields ("serial" and "part") are required fields. To control...

Hi all, Using Access 2K For reference, all fields listed below are text boxes on my form that are used in the code: LabelName NoOfLabels - No of times to copy recordset to textfile (loop) ProperShippingName UN_No PrinterName TextFileName I am currently have the following code attached to a...

Hi all, Access 2K Just wondering how far one can go to customize a toolbar in access. I want to create a toolbar with bigger buttons than access appears to provide and also to insert my own graphics as the ones that are provided - even though can be edited - are not really suited for the type...

Hi all, Using access 2K This I assume is a fairly simple one (except for me that is). My report that I run, ocassionally resets the page setup values that I have assigned it through page setup. I thought that a good way to fix this would be to assign the page setup values through code as part...

Hi all, Access 2K I've written the sub below to create a temporary table when I open a form. Although I create the table okay, I haven't figure out how to also programatically create a one to many relationship from a permanent table (tbl_Manifest) to this temp table (tmp_ManifestDetail). I...

Hi all, I want to create a table that will have a structure (field names), but will contain no data. One of the fields I need to be an autonumber field formatted as "00000". Below is a list of the fields that the table needs to contain: TABLENAME tmp_ManifestDetail FIELDNAME DATATYPE...

Hi all, Does anyone know how to create a form within access 2k that will show me the last modified date on a folder? Let's say that my folder is called: c:\Testing Thanks in advance, Tadynn

Hi all, Access 2K I'm having problems with a piece of code that I wrote to create two tables and append data to those tables once created. The problem appears to be when the code runs to steps 3 and 4 (see below) step 3 makes a table and inserts data and step 4 appends more data to the newly...

Hi all, Access 2K Just looking for ideas or suggestions on how to do this one. I need to find out how to create a module that will calculate how many times a particular day shows up between two different dates. Logic: StartDate: 01/01/2004 FinishDate: 03/02/2004 DaysToCount: All mondays...

Hi all, Access 2k I've got the following code that creates, updates and appends data into a table. The problem I'm having is that in the process I'm creating 2 additional fields that I am inserting data into later on in the procedure. Unfortunately the fields are created by default as text...

Hi All, Access 2k Excel 2k Excel Spreadsheet: x:\spreadsheets\DBAreapicks.xls I've got the following module that output data from a table into an excel spreadsheet. However, what I also want to do, is to give the spreadsheet a bit of a format through code. What I want to do is format the...

Hi all, Access 2k I've created a form that contains a list of all reports in my database and all forms that are associated with the reports. This information is contained in a table called tbl_Reports and I use the MSysObjects to get the information on both reports and forms contained in the...

Hi all, I have a spreadsheet that is laid out like below like below: A B C D E F G->(AB) 8 Forecast: 1957 15200 1520 9000 6587 58874 8700 9 Actual: 1800 9000 1872 10 Variance: 157 6200 -352 0 0 0 0 The values in row...

Hi all, Excel 2k Just wondering if anyone can help me with this one.......... I have created a worksheet in excel that currently shows the daily forecast total of orders targeted to process for the rest of the month. As each day's orders are completed, I will go in and update the forecasted...

Does anyone know how to create an excel workbook and then copy the results of 3 different SQL queries into that workbook, but on separate tabs? The 3 queries that I wish to run are as follows: into TAB1: DoCmd.RunSQL (SELECT [#TempMoveTrans].Loggon, Format(TimeValue([EffectiveDate]),'hh') AS...

Hi all, Can someone tell me how to write a procedure that creates a table? I've done it before, and I can't remember how I did it. I think it was someone thing like: Dim Table As TableDefs For each fld in fld But I've just totally forgotten. Also within this table, I want to prepopulate 2...

Hi all, Pull up a chair, this will take a while to explain...... I'm currently developing a form in my database that will operate in a similar way to the expression builder available when writing a query, this form will allow me to write SQL statements on the fly. What I have is a form with 1...