Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jeffwest2
  • Content: Threads
  • Order by date
  1. jeffwest2

    I am trying to populate a text box

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

    Access update VBA

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

    Query Running Show progress

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

    View running Query Details

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

    Percent of a fixed number

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

    Monday as First day of the week

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

    Import CSV file into table omitting first 4 rows

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

    Coverting XML file to HTML

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

    Change colour of just part of a label

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

    Get a count of Columns in a database

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

    SQL 2005 Encryption error

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

    Verify field is UK National Insurance number

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

    Update not working in a Stored Procedure

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

    VBA to remove duplicates from a sheet and save them on another

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

    Fill form with query results

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

    Regular Expressions AARRGGHH

    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 * $ #...
  17. jeffwest2

    onblur drop down issues

    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">...
  18. jeffwest2

    Datepart query

    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}) >=...

Part and Inventory Search

Back
Top