Search results

My users will be accessing the same table through the same select query based form. They want the query to order the table in a specific date based order so that they can 'work' the oldest records first. They never want two users to work the same record so if the oldest record is currently in...

I have a form that will have multiple users. It opens to the first record in the query. If someone is currently using that record (not necessarily making changes, but has that record open) I want the form to move to the next record. I think my code should look something like: dim db as...

I have created code that will export an object from the current db to another db using the docmd.copyobject command (TO db name is input by the user). I want to check the other db to ensure that the object does not currently exist before I export it. If it does exist, I want to delete it from...

I have a sub report which contains two fields - a calculated field and the same calculated field that is set as a running sum over group. These fields are in a group header, not the detail section. The sub report is working fine and displaying exactly what I want. The problem is that the main...

I have a field on a report that is a running sum over group. I have discovered that when the lines on the report extend to more than one page, the running sum is SOMETIMES incorrect. Sometimes, it does not add the last record. Has anyone else had this problem and is there a work around?

By jove, I think that'll do it! Thanks so much, Chris! Roni

I have a form that has a picklist which is pre-filled based on user login upon open. I want the data on the form filtered by that field. If the user chooses another entry from the pick list, I want the form to requery and filter by the new value. I have put the following code into my On...

I have a report that is broken into a couple of sections. In the properties of the last section, I have it set to go to a new page after the section. This works fine except that I get a blank page at the end of my report. How do I keep my report looking the same as it does not, but not...

THis is so weird. I have fought with this all morning. I KNOW I tried that and it didn't work. I finally deleted the unbound control box and based my form on a query that pulled the info in rather than using an unbound box with a dlookup as the control source (which didn't work originally, so...

I have a form that is split into tabs to look like index cards. I want to reference a control on that form for a calculation. However, I don't know the syntax. If I create an unbound box and set it's data property to: =[forms]![frmName]![fieldname] I get #Name in the unbound box. I have...

Well, sometimes, I feel like I have so missed the obvious that it's ridiculous. You are correct, sir. This will work wonderfully. Thanks, Roni

I have a table that the user wants 'broken up'. They want to display different data on different forms to make it easier to input. I have created a main form using the index card style tabs. On each tab I have put a subform which contains the data they want to see grouped together. How can I...

Try setting a variable in your code to application.currentdb.name This should pull the entire path. I was also having trouble getting it to pull the full path, but this seems to work for me. Roni

You can launch your code on the 'on format' portion of the properties for the section of the report where you want to display the information. Create two unbound text boxes in that section. At the end of your code, set each text box to the begin and end date variables. To get the begin and...

We are getting this message in a database that is being used by 75 users. Basically, we partially replicated the database so that small groups of no larger than 10 users are in each replica at a time. However, the replicas and the design master open recordsets to a third database which is what...

I have never had this happen, but I do know that Access has a bug in dbs that are replicatable. If you do not compace twice prior to distributing replicated copies, weird stuff happens to your queries down the road. They still run ok, but when you open them in design view, fields are missing...

I have created a report based on a query. Occasionally, the query will have no data. Should this happen, I do not want the report to pring the usual 'ERROR#'. Instead, I want it to say, 'there is no data for this report'. I have tried doing a recordset check in VBA in the on open of the...

Here's the code: dim db as database dim rst as recordset set db = currentdb() set rst = db.openrecordset("qryGroup") It bombs out on the set rst statement with a 'too few parameters' error message. As I've played with it, if I put a query name in that has records in it, I don't get the...

I have a report that is broken down by team and then by task. I want a count of unique tasks. However, there are multiple records in the detail that have the same task number. When I try to get a count, I get the total # of records in that task. How can I get it to tell me how many UNIQUE...

I have an employee table which has an employeeID field, employee name, and reportToID. The table is self related where reportToID = EmployeeID. I am able to get out data that lists the employees and their direct supervisors sorted by reportsToID. I need to list the records in the recordset in...