Search results

Hi Quick question, how would you advise I do the following. I have a form with an unbound textbox. What I would like to do is create some sort of log in a textbox with the newest listed at the top. I have a table with this information in that contains an ID, a memo field which lists the...

Hi Is the following possible? I have the code to add the text to a textbox, but what I would like to do is rather than to keep adding the text onto the end. Make it so that it will add it before what I previously added, so that the newer data is always at the top. Can I do this? The...

Hi I've created a few listboxes before, which have all worked fine, but this one however keeps throwing up an error message. Can someone help with this, here is my code, and the highlighted section it debugs. Dim db As Database Dim rst As DAO.Recordset Dim sSQL As String Dim EmpID As Integer...

Hi I hope someone can help on here with this. I am having problems using the package wizard. I can run through the first couple of steps on the package wizard, but when it asks for a language to cache, it fails to install the necessary files. I have found the resolution on the MS KB site about...

Hi I'm having problems trying to get an If statement working on my form. What I have is a form with two combo boxes linked to a Calendar when you click on the arrow. I can get the dates I select from the calendar into the combo boxes which works perfectly. What I wanted to do then was create a...

Hi I have created a report for labels using the Label Wizard, and found the code on the MS KB about skipping the labels that have already been used, and printing on the next one along. Page on MS KB When I try using this code in Access 2003 however, it seems to go into some sort of loop, and...

Hi Is it possible to set events for the buttons on a message box? For example if I create a Message Box when someone clicks on a button, and set it to vbYesNo, can I then create an open form event on the yes button, and a close acform event on the no button. Thanks

Hi I found the DSNStripper add-in on mvps, nice little tool. But I would like to try and get it to work with linked tables from Oracle and make them DSN-less. Can anyone give me any suggestions on how to do this? I don't really understand how the code works, but I have changed what I think are...

Got a problem with that audit trail that has been posted on here. Basically I can get it to work on all put one subform, and I don't know why. I have a main form with a tab control placed on it containing all of the subforms in my db. On the form it doesn't work on it seems to be inputting...

I keep getting the error Access can't find form referred to in macro or vb code when trying to run two macros. The macros are to set a value in a combo box which is placed on a subform, which in turn is linked to a tab control on the main form I'm using. Can anyone help with this, the argument...

Audit Trail doesn't pick up changes in subform Hi I posted this on the end of the audit trail thread but nobody was really looking at it. I have used the script for the audit trail, and when I start changing any of the records, it comes up with the error: When I ctrl - break, and debug, it...