Search results

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

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

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

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

Hi. I am having problems trying to get some code working that merges data from my db into a word document then saves the document as a strings value. Heres my code Dim objword As Word.Application Set objword = CreateObject("word.application") objword.Visible = True...

Hi there....Im busy tonight trying to get a couple of things working correctly. I have an UPDATE string that I am trying to get working but I am getting a runtime error 3061 saying 'To few parameters Expected 1' I have tried the same query using the query builder and it works ok...when I try...

Hi there I am making a form that has been set up to have a number of tabs so I can have more then 1 page on the form. One of the tab pages is used as a search form.There is a couple of textboxes and a listbox where the results end up What I am trying to do is have a double click set up on the...

Hi there I am playing around with with the dlookup function with populating from a combobox. This is what I am trying but its not working =DLookUp("[PhoneNumber]","tblLineManager","[LineManagerID]=cboBookingContact(0)") Basically what I am trying to do is use a combobox to populate a...

Good afternoon, I am hopying someone can help out with a question that I have. I am trying to import a .csv file into a table in my database.I am using DoCmd.TransferText acImportDelim, "", "TICK", strLocation, True, "" It works great but always creates an a table that contains the errors...

Hi there I am embrassed asking about this but I really need some help. I have been trying to teach myself Dlookup with the help of the forum and help but still can't get it to work how I want it to. What I am trying to do is for the function to look at a table for a value based on a textbox...

Hi there I have a form that has 4 tabs on it. When I add a control onto one of the tabs, The control is appearing on all 4 tabs. What causes this? Thank you for your help!!

Hi there I have found this forum so helpful in the past I thought I would try my luck with getting a few more ideas for my next project. I am designing a database used to track a persons working history and timesheet information for each of the jobs the person works in. I work for a company...

Good morning I am hoping some one can help me out with an SQL string I am having problems during to get working. This is my code Private Sub SearchRoleSeeking() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String Dim strFilterSQL As String Dim...

Hi there Can someone give me a basic example. I have a form that contains a textbox and a listbox. The listboxs rowsource is tblSPNZ. The table has 2 fields 1 is and autonumber and the other is where I want the results to go. How do I make a command button populate the table? Avoiding...

Hi there I have made a form I am trying to bound 3 tables to. The 3 tables are tblPersonalInfo tblBookingInfo tblSkills How I am trying to set it up is that I enter someones personal details in once. But using the same personal details someone can have more then one booking. With the...

Hi there I am hoping someone can give me a few pointers on how to get started on what I am trying to achieve.... I have 2 tables that form a 1 - to - many relationship. I have designed a form that I wish to show fields from both tables. Using ADO I would like to be able to open the form and...

Good morning I had yesterday off work and have come back to a nightmare. The database we use doesnt work the way it should anymore. There is a switchboard which gives us the option to show a booking form...Worked fine until someone did something to it yesterday. When I click on the command...