Search results for query: *

I used the find duplicates query wizard and it gives me this error: "You tried to execute a query that does not include the specified expression " as part of an aggregate function." (Yes, that's simply a quotation mark in the error msg.) in SQL view: SELECT [Blossburg Active...

This seems like it ought to be simple, but I'm having trouble with it... Table consists these fields BoxID (index/autonumber) TicketName (Lookup to a list of names & types of tickets) BoxDate (manually entered short date when the box of tickets was opened) BoxSerial (manually entered serial...

Access 2000 on Win2KPro Backend lives on nice server, contains 23 tables with 3 to 600 records each (2100 kb). Front end lives on individual users' machines. The front end has 20-odd queries, 20-odd forms and three reports. Granted, the forms are very complex with min. 3 subforms each. For...

This seems like it should be so easy... I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID. This code gives me an error on the...

This seems like it should be so easy... I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID. This code gives me an error on the...

I'm using a recordset to run thru a bunch of records and evaluate various fields within each record. Access seems to be holding the value of fieldZ of recordA if recordB's fieldZ are not populated. Is this possible? And what can i do to clear it? Thanks, Heidi

I'm using DoCmd.RunSQL (strSQL) to add rows to a table. I want it to not notify me that it's appending a row - it's really irritating and the table is specifically for these added rows. How do i suppress that warning? Thanks, Heidi

Hi, all... I'm learning the SQL statement "Insert Into" today... I've got a bunch of calculations created by a vba script and need to pop the results into a table to be able to create reports off it. Since I've been using a SQL statement to create a recordset to get the original data, i...

I went to test my big project with a user yesterday and everything was broke!! Okay, not everything, just the ability to link several tables by one ID and add data...which is pretty darn crucial. Table 1: Loans Table 2: LoansMortgages Table 3: LoansRealEstateMortgages Table 4...

I've got a VBA event procedure that evaluates a bunch of data from multiple tables (over 100 fields with lots of conditionals, dates, etc.) and I want to send the results to a report. Obviously, I need the "DoCmd.OpenReport" but how do I tell the report what to display? In my testing I'm just...

I know this type of question gets answered a lot, and I've tried several of the various answers... just when i think i'm making progress, something else breaks! I'm trying to write a SQL statement that retrives several fields from a record that is selected because its date is the highest of...

I've created an Access 2K db for an audit department to audit loan files. I've got nice tables, queries, data entry forms, and now I need to calculate how well each file does. A file has loan information (main table), multiple applications, properties, disbursements (all 1-to-many), etc. I...

Okay, I understand what a record set is and how it's created - with a SQL statement. What I don't understand is when they're public or private? in a module or a procedure? I'm getting errors with this code which is simply behind a cmd button: Public Sub Command167_Click() Dim rstApps As...

(This may be a structural problem... I'm open to ideas.) I have five different kinds of forms for five different kinds of loan activities. All five use a common application form that I've put in a separate form accessed by a cmd button. I want to pass the loanID from the specific activity form...

NT4 box Dell PowerEdge 1300 with 9.1 GB drive in two partitions: c: = 5GB, d: = 4 GB. c: is full and I need to do something... Dell service tag BV7Z30B if you're curious. To fix today: I'm going to make all the logs stop logging and try to move one of the dbs on the server to the d:, however, I...

Okay, I'm sure this has been addressed, but I can't find it in the FAQ or by keyword search, so I'm just gonna ask... I have a small office (12 people) using Access 2000 (not a server edition, just the MS office 2K version) as a contact/membership db. The db lives on a shared network drive and...

Just a quick questions -- My darling boss is a Mac addict and would really love it if I would replace his nasty old Win98 box with a spiffy new iMac running OSX. The office is running Win2K server on a Ethernet 10/100 network and all other clients are Win98 or Win2Kpro. What do I need to know...