Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JulieS
  • Content: Threads
  • Order by date
  1. JulieS

    View entity relationship diagram from .sql file

    Hi, I was sent a .sql file containing a database structure. My task is to create a diagram (ERD) from the sql code. Is there an easy way to do this, instead of starting from scratch? I downloaded a series of programs, but have not had any luck yet. The closest was with the DDT program, I don't...
  2. JulieS

    Weighted Random Number formula?

    Hi, I have a list of 100 employees. I want to randomly select 5% of the employees per month for a test (there's a test once per month for one year). To start, each employee has an equal chance of getting selected. Once an employee is selected, his chance of being randomly selected again...
  3. JulieS

    Work with ActiveCell from one worksheet in another

    I have two excel spreadsheets - one with the macro, and the others that I want the macro to run on. I have successfully opened the other spreadsheet, activated it, and can read values from the cells, but when I reference ActiveCell, I get the following error: Run-time error '1004'...
  4. JulieS

    Tab control with subforms

    I have a form with a tab control. The main form is on tab A, and the second tab's form (tab B) is related to A. The problem is that tab C and D are related to tab B. However, I am unable link them on the parent/child fields because it only gives me tab A data to pick from. I tried creating...
  5. JulieS

    Module Not Found

    Something very strange has happened to my database. It was working fine, but all of a sudden when I click on a button on the main menu that takes me to another form, it says 'Module Not Found'. Its saying this for all buttons, and I"m not even able to open a form directly. I didn't do anything...
  6. JulieS

    pass parameter from combo box with multiple columns

    I have a combo box that lists titles and dates of events. There could be duplicate titles but not dates, that's why I've listed them both in one combo box. I would like to pass both the title and date to my query, however the syntax in the query's criteria field...
  7. JulieS

    FindRecord is Replacing my Second Column

    I have a combo box that lists the ID in Column(0) and the Title in Column(1). When I use the docmd.FindRecord, it is replacing my Title with the previous ID (before the update). This is very curious because I've used the same code in other databases and its worked fine. The code is as follows...
  8. JulieS

    Building a report from 2 queries

    Not sure if this is possible, but I have 2 queries that are seemingly unrelated to each other that I need to put into one report. Situation: Table A is related to Table B and Table C. So, one query calculates the number of times variable x in Table A appears in TableB, another query...
  9. JulieS

    Executing a parameter query in VBA

    My combo box on my form is based off a parameter query. In order to add a record to the form, I have to check if there are records or not (so I know if i should use the DoCmd.GoToRecord , , acNewRec command or not. So, I'm trying to open this query (FunderCheck) with a recordset, but when...
  10. JulieS

    Show default value in reports when no data

    I'm producing a number of reports (all reports are copied and pasted into one report document). Some reports are blank due to the query returning no data. Is there a way of either not having the report appear or showing a value of 0 (without using the NZ function) when this happens? (I am...
  11. JulieS

    Creating pdf from Access97

    Is it possible to create a .pdf out of a report in Access97? When i save/export, pdf is not listed as one of the options, and when i save as either HTML, Excel, or Word, none of the graphs show up. (the whole reason being I need to put the reports up on a website and do not want to go...
  12. JulieS

    Start a report page number from a number other than 1

    Hello, I have many many charts that I want to compile into one report. The problem is that access only allows the report to be 22" long (thus I cannot copy all the charts into it). So, I'm thinking the only solution is to copy as many charts as I can into one report, so I may have a...
  13. JulieS

    Using the Nz Function in a query

    My query calculates the count of a Cost field for a number of categories (ie. >10, 10-99, 100-150) for a specified year. Each category comes from a different query. If one of the categories returns null, the entire query does not return any value. What I would like to do is use the Nz function...
  14. JulieS

    Check if Uppercase

    Is there a way to test if a string is in uppercase? I know I can convert to uppercase with UCase(string), but I don't want to do that (reason being, I am working off data that if uppercase, it means something different that lowercase). Stupid I know, but i'm not the data enterer.
  15. JulieS

    Evaluating to EOF when in fact it is not

    I am searching for duplicate values using findnext. THis is done in an outer Do Until rst.EOF loop, which rst.movenext at the end of the loop. The problem is that it thinks it is EOF with every new record that does not have a duplicate. I've gone crazy testing whether it is a new record within...
  16. JulieS

    Delete Error when looping through and deleting recordsets

    Hello, I am looping through my recordsets with two recordset pointers, and every time i come to a duplicate, i rst.delete it. however, when the outer pointer comes upon a deleted record, i get an error saying "record has been deleted". I've tried the refresh function to just remove...
  17. JulieS

    Determining whether the same recordsets are being compared

    Hello, I am assigning IDs by first going through the records and determining which records are duplicates (from there I flag the duplicate with a -1 in the ID field, then delete all the -1s before I assign the ID). Just for some background info. I have a Current and Next pointer looping...
  18. JulieS

    Opening Excel sheet from Access

    Hello, I'm importing data from Excel (using the DoCmd.TransferSpreadsheet in VBA). The problem is if the excel sheet to be imported is not currently open (the error message says the external table isn't in the expected format). Is there a way to check if the table is open and if not, open...
  19. JulieS

    Import data from more than one range

    I am trying to import data from an excel spread sheet into Access. The problem is that the data is in more than one range. So in my macro, I have: sheet1!A1:J3 but I do not know the syntax to say: sheet1!A1:B3, sheet1!E4:F7 (the error message when i type in the above syntax is: "the...
  20. JulieS

    DataGrid and Passing Parameters

    I have a data grid that calls a query from a data environment. This query uses a parameter (CustomerID). However, when I run the form, nothing happens, unless I hard code a value in the data environment properties (under the parameter tab, in the Value textbox). I have tried declaring a global...

Part and Inventory Search

Back
Top