Search results for query: *

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...

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...

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'...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...