Discussions in microsoft.public.access.formscoding - www.microsoft.com/communities/newsgroups... | Site profile

This was originally in "microsoft.public.dotnet.languages.vb" but I'm not getting any answers ther so I thought I'd try it here. I created a dll for com (in vb.net 2005) so that I could access it's functions from an ms access app. I created the tlb file successfully. On my dev machine I referenced it in my access app and wrote ...

please give me an idea how to show dat grid rows in MS acess form then add and update data table also.. Thanks a lot Amita

Hi, Thanks to this discussion group I discovered Allen Browne's audit table utility. I installed it as per instructions (I think) and found that editing and inserting records were being recorded (almost correctly) but that delete transactions were not being recorded. After some testing I found that the On Delete event was not ...

What is the syntax to use WITHIN an email that will pass the /cmd value? I can get the value to pass when using the Run dialog box, but I have not been able to get it to work as a hyperlink from within an email. This does not work: <file://C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE C: \Documents and ...

I have two fields on my form, consequence and probability. They are filled from drop down menus that contain the phrases very low, low, medium, high and very high. Each of those are assigned a value of 1 through 5 respectively. A third field, exposure, is calculated as the product of the two values. The customer would like the ...

Hi. I know that this is possible, but I never did it. How can I shutdown my pc with a command sent by access. How can I shutdown my pc from when I'm using my access app. Thanks, Marco

Due to the nature of the research, I have a complex database that stores information for what should be several seperate databases for seperate research studies' information. Because they have information that is linked (and also for easier non-repetitive data entry), the doctors have requested that it be just 1 database. ...

Hi, I'm back. Here's my code again. I can't seem to get paranthesis around the selected items and I can't figure out why. I know the thing works if I could get those things around each selected item, but I can't seem to figure it out. Public Function Combo_List() Dim dbs As DAO.Database Dim qdf As DAO.QueryDef...

I need get slected items information from my list box by index number. I just wonder any property can pass to get my data? Your help is great appreciated,

I've been using various filter buttons and drop-down boxes in Access 97 and 2000/2002 to filter records on forms. These forms could be closed and when reopened would no longer be filtered, which was what was desired. In Access 2007, however, the forms would reopen with the last filter which had been used. For example, if the form had been ...

Hi Using ACCESS2000. My DB is for a specific project that is monitoring the QA statndards of cellsite construction. For each site to be 'signed off' - there needs to be 26 documents submitted for assessment. So - each record has the CellSite #, Address, Territory, Status and then the 26 doc fields. The [doc ...

I have a request from the boss to track the users movement on the A2003 app. I was thinking of using Allen Browne's audit trail since I've used before and it works great. But now, rather then tracking the controls and the info going in or changing, it is the button activity that is needed. So every form and every button on each form ...

I have a form (frmActMapUpt) that allows the users to update sorting and grouping coding in a table. If they update anything, I have to run a few "house-keeping" queries, if they just look at the data in the table and don't change anything, I would like to skip the house-keeping because they take some time to run. Is there...

I have written if then else statements, but new to elseif. I have tried to follow examples from others, but my code below is not working. When the code is run, it never seems to get to the elseif portion of the statement. Can someone help point me in the correct direction. thanks Private Sub Dispo_Exit(Cancel As ...