microsoft.public.access.modulesdaovba

Listbox.listindex Thu, 2 Oct 2008 09:09:02 -0700
How can I select an item in a listbox by VBA program? In Access 2007 the listindex property is read only. ...

Look at previous record in a report and use it to format current r Thu, 2 Oct 2008 09:01:01 -0700
I have a report where multiple payments could be made agaisnt a specific line number, the invoice detail is kept in one tabel and the invoice payments are kept in another the relationship is line number and the payments in aother table, I join them together to complete the invoice line what happens is t ...

Visual Basic use of Null in if statements Thu, 2 Oct 2008 08:11:01 -0700
I am trying to run an event that checks the status of a field and if it is null should do one action and if not null should do another. I can't seem to get it to work. Any idea here is the code Private Sub Quality_Approval_AfterUpdate() If Forms![ERGR]![ME Approval] = Null Then Forms![ERGR]![Q ...

Access VBA SQL problem Thu, 2 Oct 2008 07:22:00 -0700
I need to delete records from my table when a field in another table does not contain a certain value. I have the following SQL that selects the correct accounts, but when I try to run it, it says it can't delete records from the table. I can't figure out why! DELETE PLD.* FROM AIS RIGHT JOIN PLD ON AIS.D ...

multiple values from a temp table Thu, 02 Oct 2008 12:54:04 GMT
Hi all, Been stuck on this for a while...was hoping for some more help. I have a temporary table like such TS_Date Project_Name Hours_Worked 19/10/2008 Dalkeith 0 20/10/2008 Dalkeith 4 21/10/2008 Dalkeith 4 22/10/2008 Dalkeith 4 19/10/2008 East 0 20/10/2008 East 4 21/10/2008 East 4 22/10/2008 East 4 ...

Unbound Form Audit Trail (Allen Browne) Thu, 2 Oct 2008 04:07:02 -0700
hello, i have an unbound form and from my earlier thread realised i cannot use allen brownes example for creating an audit trail on an unbound form. my question is can i create an audit trail with an unbound form? is there some way i can modify mr brwones example to work for an unbound form because i cannot ...

Allen Brownes Audit Trail Wed, 1 Oct 2008 23:54:00 -0700
hello i used allen brownes audit trail example and follwed all the instructions but there are no recorrds being added in the audit tables. i compiled my code but there were no errors.my form runs and i delete add and edit records but audit table remains empty. im using an unbound form which used DAO. and i ...

Filtering a Report for Printing Wed, 1 Oct 2008 20:05:01 -0700
I have a report that has a jpg filter file for each record. I can't print the entire report at once because it crashes when it opens up almost 100 jpg files. I tried to use docmd.openreport using the wherecondition to open the report using a filter. I then printed the report using DoCmd.PrintOut acPrintAll. ...

Listbox "List" property Wed, 1 Oct 2008 18:17:01 -0700
I programmed a system in Excel VBA (before user had Access) and populated a listbox from an array using the List() property. Trying to do it in Access 2007 VBA but the listbox seems to have lost its List property. What happened? What can I use instead? Thanks for any help. ...

Howto move a query into a temp table that would be named by user Wed, 1 Oct 2008 18:01:00 -0700
This is the scenario: 1. User run a sql query from a form where they select different fields and/or criterias. This portion is working great. 2. The query result is called "Dynamic_Query". The user might need to save this query for further updates or review. From a viewing form of this query, I have a button ...

page nr.: page nr. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 next >>