Search results for query: *

I am trying to populate a text box with multiple entries from a table that is not linked to my main form. I have a combo box that is linked to a query that just brings back the grouping of the search field (i.e. I have multiple items that are the same and have the same type Address, Id and...

On the close of a form I have a series of codes that 'should' update a table with in the database with data from the fields on the form, the issue i have is that the update sql doesn't seem to work. Code is below, the highlighted bit is what doesn't seem to want to work. Private Sub...

I have a an Access 2007 program that imports in some data, then runs a query to check for duplicates and removes the new records where duplicates exists, the issue is this runs really slowly. I have tried to change this to VBA SQL, but it runs just as slowly, so, my next idea was to try and...

I have a an Access 2007 program that imports in some data, then runs a query to check for duplicates and removes the new records where duplicates exists, the issue is this runs really slowly. I have tried to change this to VBA SQL, but it runs just as slowly, so, my next idea was to try and...

I have some agents that need to call a minimum of 24 records per hour, I have a crosstab report that will show me those records, what I need to do is work out what percentage of the minmum calls that they need to do have they actually done, e.g. I know that 13 calls is 54.16% of 24, how do I do...

I can see some solutions within this, but I can't get any of them to work, so here goes. I have to create a crosstab report that lists the days of the week at the top, I want to make Monday as the first day of the week, this is what I have at the moment on my crosstab column DayOfWeek...

I need to create an import routine for a csv file into a table. The file contains 4 rows of junk at the start of the file, which while i can manually remove prior to the load, I want to have as little user inter action with the file, Can anyone suggest a very quick piece of VBA that will start...

Having issues converting a xml document to html, I have a style sheet (css) but just can't get the file layout correct. Don't suppose anyone knows of a program(freeware!!) that I can download to do this, as it is really ticking me off. Didn't anyone ever tell you? There's one thing you never...

Trying to change a label so that it colours a '*' red to mark it as mandatory so it reads as Month * I have tried web searches and I can seem to colour the whole text or the border red but not just a small bit of it. Any help would be great. Didn't anyone ever tell you? There's one thing you...

I have a database linked to some fields on a html page, however, I could have up to 28 sets of populated data, or as few as 1, what I need is a simple piece of code along the lines that will count along the dataline all instances where a field called Firstname is not null (i.e. poulated), then...

I am trying to do some testing of data encryption on a local instance of SQL 2005. I have created a database which has 1 table, when running <code>create master key encryption by password = '*************';</code> I get the following error, An error occurred during decryption. Does anyone...

I am having that friday feeling, can anyone give me a poiter for checking if a field is a valid National Insurance number (AA123456A). I seem to be having a total mind block on how to do this, and i can't find anything that makes sense on the interweb and i just want to go home. Any help would...

I have the following code in a stored procedure, in essence it creates a temp table to hold some data, it then runs two update statements on a main table with details from the temp table and another table, all the values in the CIG_URN field are unique (I have already stripped out the duplicates...

I apologise if this is somewehere already on here but i can't find it. I have a sheet of data that has duplicates, the sheet can be of any length. The duplicates can either by Name, HouseName/Number and postcode or Phone number. What I want to be able to do is run some VBA that does one pass...

I haven't used access for a while, and I am having a brain freeze. I have a form that collects data from multiple tables(SQL linked database), the form has (at current) four tabs on it, each tab represents one of the tables, I have built a query that will extract the info that I want, and I...

I freely admit i don't get regular expressions, i can never seem to get them just right, any chance of a bit of help with this i would be great full. I have this code, which i have taken from a couple of sources, i need to check that anthing in a text box does not include such things as * $ #...

I have a java page i am trying to invoke an onblur event. <select onblur=validate(this.value) style="Z-INDEX: 101; POSITION: absolute; WIDTH: 165px; TOP: 105px; LEFT: 112px" id=SELECT1 dataSrc=#SSE_Survey dataFld=Q1 size=1 name=Happy datafldname="Q1" databindingtype="Database">...

I am trying to determine how old something is, using this formula if datepart("d",{SITUATIO.Start Date}) >= (datepart("d",CurrentDate))-0 and datepart("d",{SITUATIO.Start Date}) <= (datepart("d",CurrentDate))-89 then "<3 months" else if datepart("d",{SITUATIO.Start Date}) >=...