Recent content by spnz

Good morning, I am trying to use an SQL statement to add a value into a listbox. This is my code Private Sub lstSearchResults_DblClick(Cancel As Integer) Dim strPayRollNumber As String Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strQuery As String Dim...

Good afternoon, Hope someone can help out. I have a piece of code that im using to insert values from a spreadsheet in access. My problem is inserting the HOURS in my code you can see I use 3 different HOURS (Hours 1 Hours 2 Hours 3) My problem is that when I import the spreadsheet into...

Hey Jubb, Yes your right. I managed to fix it yesterday by moving the messagebox upto where you said. Sorry forgot to reply. Thanks for all your help!

Hi Jubb, The code runs nicely until it gets right to the end. I get a messagebox saying "Word is currently printing,Quitting word will cancel all pending jobs. Do you want to quit word? How can I avoid this message? and have word print out automatically and close? Thanks again!!

Hi Jubb, Thanks for your reply. I am not at work at the moment but I will give your code a go tomorrow and let you know how I get on. Thank you

help............. :(

Good afternoon, I am having some problems with a merge that im doing from a db into word. The merge works ok but there is after the merge there is always a copy left running. This is my code. Sub PrintContract() ''ref word Dim objWord As Word.Application Dim objDoc As...

Thanks guys I know that there might be 2 people with the same name. What I am thinking is that by having a messagebox saying that "This name is already entered, Are you sure you still want to add this name?" Then use a INSERT into statement or if the user presses the NO button then it cancels...

Thanks guys. The 2 fields don't contain the same data. The first field is Forename and the 2nd is Surname. I am just wanting to check that with the names combined then there is not a duplicate. e.g Forename John Surname Smith the lookup would look for a John Smith. IIhoutz do you have an...

Hi everyone, I have a form that I use to enter information onto a table. Lately I have noticed that there are few duplicate names been entered into the db. The form has 2 txtboxes for the persons name. The table also has the 2 fields. How can I make a Dlookup check both fields before allowing...

Hi, I have a string that I am trying to get working so that I can use the value from it and place the result into another string. strLastRecord = "SELECT (Max(ExportDate)) AS TheLast FROM tblExportInformation " It basically gets the last value in the tblExportInformation. How is it...

Thanks Peter Works great now Shane

Hi there I have a form that I have set up containing 2 pages (tabs) that cover the whole form. When the form loads it opens pgeBookingDetails. PgeStart contains a listbox that is sourced by a query. What I am trying to do is double click on the selected record within in the listbox and have...

Hi there. I am in the process of building a new database that will be located at 2 different locations. (Headoffice & Onsite) Onsite the database is used all the time and throughout the day many records are added and deleted. I have a few tables that are joined e.g. (tblPersonalInformation &...

Thanks for your prompt reply RV.