Search results

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

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

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?

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