Search results

I'll play with it and see if I can isolate what it was exactly. In any event, thanks for your quick help. You've saved me a ton of time!

Much better! Thanks! To save time looking at all the settings, can you describe what it was that I had wrong or you changed to make it work? Thanks!

Ok, here is the file. Open the form titled "Healthbenefits". I've modified it slightly from my original post. I now have three separate subforms. The problem now is that if subform3 is linked then it constantly calculates causing it to constantly refresh...although I am able to edit the...

One other thing...subform3 is linked to subform2...if I turn OFF the link then subform3 work fine, allowing me to edit/add/delete; however, it displays ALL the data. I've tried using a different query and adding filter criteria in the query based on subform2, but I get the same results when...

I've created a form that contains two subforms. Subform1 is a datasheet, subform2 is a regular form containing a subform (subform3) of it's own which is a datasheet. Subform2 is linked to display detail information based on subform1...which works fine. Subform3 is linked to subform2...

How does one combine a query of a query into one query. I have some complex queries that query a query because I don't know how to do the same task in one query. For example, let's say I have a table with EMPLOYEE, DAY, HOURS. I want to pull ALL the data for those employees that work on...

Is it possible to open a premade report out of Access 2003 from vb .net? The reports, tables, and queries are all stored in the same access db. I've created a menu system in Access to open reports for users but I'd rather do it from VB .net (so I can create an exe file and bypass license...

Thanks for the suggestion. My problem is that I have three different laptops that will need to update information each day to the same database. I didnt' see a way to do that with replicas.

IMPROVE ME! I'm just starting out with Access and created this database so that our managers can log their notes while they are on call. There's nothing special about this but I would be curious what people think and especially how I might improve it. I like efficient code, and I dont think...

I have a table named 'Main' on a laptop. I have the same database on our server, meaning that database has the same table named 'Main'. Users will use a laptop and enter data in it over night and I want the user to then upload the data to the database on the server. In this 'Main' table is a...

I think I got one of them figured. =Sum(iif(employee_score<70,1,0) but how do i count the number of employees whose score is between 70 and 90 ?

I have a table with [id], [manager_id], [employee_id], [employee_score] I created a report that is grouped by manager. In the manager footer part of the report I have: =count(*) This counts the total number of employees for that manager. Now I want to add fields that count the number of...

Thanks for the code!

I want to run 7 delete queries when a form loads. I'm using the docmd.runmacro "macro1.name" in VBA on the form load, which works fine, except that it prompts the user with confirmations for each one. Is there a way to eliminate the prompts and just have it auto confirm each one?

I found a workaround for what I'm trying to do. Pretty much what llkhoutx suggested. On the server (terminal server) I'm going to backup the master db file and then run a separate db to link to the backup which will run a deletequery to get rid of the data i dont want. Then, using a bat file...

Thanks for the reply. Unfortunately I am trying to avoid importing all of the data. The database is 80mb and I have to import it from our server which is in a different city, so that import takes a long time. I thought by importing select criteria, which would knock it down to about 10mb, I...

Is there a way to import data that matches specific critera from one mdb file to the current (open) mdb file? I am able to use the transferdatabase action (and method) to transfer a specific table from one mdb to the current, but it imports the entire table. I only want to import data that is...

I need some help. I am using access 2003. I have a table, form, and report. I am trying to customize the report so that users can enter in criteria and only print that data, rather than all of it. I assume I need a form that the user enters the criteria, which then it creates the query and...