Recent content by KevCB226

If you are sure that your connections are exactly the same, then it sounds like you will need to refresh the table links whenever the database is opened. I created some code behind a form a while ago that will do this, which I have attatched. You just need to set the username, password and...

Thanks, but how do I get the form working? I have created a continuous form based on a query, which I have added a parameter for the ID that looks for the same ID on another form that's open in the background. And the date is sorted in descending order. That's as far as I got, so how do I now...

I don't think I made it clear in the previous post. So I'll have another go :) I would like to have a log of comments with the newest being listed first. The comments are in a seperate table along with the date the comment was added, and the ID it relates to. The unbound textbox is what...

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

Or you could use the following example. Firstly take out the Record Source in the listbox properties. Open up vba, and copy the code changing the following bits of information:- Where you see List22 replace it with the name of your listbox. Replace Field Name and Table Name on the sSQL...

Thanks for that reply, it worked great :) I now have another problem though. Unfortunately some of the records that I'm placing in the listbox don't contain anything, so are null values. What I would like to do is create an If statement to say that If there are no records then display a...

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

Woops, so it has. I'm such a noob, sometimes :rolleyes: I've imported the tables from the server now, so it should work.

Has anyone been able to look at this, because I could do with trying to get it to work for a db I'm creating at work. Thanks

Still not working :( I have tried requerying both the combo boxes and the textbox that counts the number of days, but it didn't do anything. I'll post my If statement anyway. This statement is the same in both the AfterUpdate events of the two combo boxes, and the form durrent event. If Not...

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

Tried that and it's still going into some sort of loop, where I can just keep clicking forward over 100+ pages. :( I've zipped it up anyway, so if anyone could take a look at it, then that would be great. :) Anyway, thanks for the help so far ghudson.

Thanks, I've just tried your code, but I'm now getting a type mismatch error now, on the code behind the report. I've highlighted the line it refers to. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) LabelInitialize End Sub Private Sub Detail_Print(Cancel As...