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 derfloh 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: lmn
  • Order by date
  1. lmn

    Dim rec As ADODB.Recordset - twice in EVENT procedure?

    Hi there, Below is code I have in an On Current Event item. I want it to run 2 SQL statements - one to see if they have an expired license and one to see if they have expired insurance. I can run it fine with just one of the statements, but it doesn't like when I have 2 statements. Am I...
  2. lmn

    What is the best way to "share" a database across users

    I believe I've split my database correctly. I've put both the front end and back end on the network server. My concerns of course are 1) if the network is down - the database is also down for all users. 2) Security - the network drive itself is secure so maybe I will just keep it at that -...
  3. lmn

    Convert text to number

    Ha.....they've offered me the job and I've declined.... Ok...so then VB Access is what you are talking about - my mistake - I've worked with developers before who required the full blown version of VB and that's what I thought u were referring to. The DB is way too large to send via email - I...
  4. lmn

    Convert text to number

    2 problems here... 1) I'm a temp - they won't give me a license for VB on my machine (this company is ENORMOUS by the way) 2) I'm a temp - I want to make it as simple as possible - for the next person who has to work on this mess if you know what I mean 3) I'm a temp....(I just have to remind...
  5. lmn

    Convert text to number

    Hello, The val() seems to work (Csng() also works) - but what neither of those do is become useful for me other than visually in my first step. Let me explain. :) This is my SQL statement: SELECT TEST_Surveys.SurveyID, IIf([quest1]="N/A",Null,Val([quest1])) AS Q1...
  6. lmn

    Hand held devices to Access??

    Does anyone have an experience with using hand held devices (PDA or such) writing to an Access database? If yes, any recommendations on software. This is what it will be used for. Project Managers go to a site to close it out - the contractor doesn't get paid until all items are accounted for...
  7. lmn

    Splitting Access database & form ( Using Database Splitter) _ PL Help

    Quick question on this post.... When you split the database - how do you share that database with other people and how do you do updates to the database? I have split my database - and am assuming I just put both files on a shared network drive where the other users can access it? My...
  8. lmn

    What is the best way to "share" a database across users

    Thanks for the response - I looked at the thread - but is splitting the front end and back end difficult or very time consuming? I have a 15 MB database. I'm not experienced in this at all and want a quick and dirty solution. There is also something about form locks - editable - and I'm...
  9. lmn

    Convert text to number

    They enter them into the survey. The field (score) is currently formatted as text so I can accomodate N/A scores and subsequently remove them from averages in the queries/reports. So they'd enter 1,2,3,4,5 or N/A. They are entering the # as text.
  10. lmn

    What is the best way to "share" a database across users

    Hello, Is there an uncomplicated way to share a database across users? I have used synchronization in the past and it's been a disaster. Is there a way to set this up without too much effort? Eventually they'd like 10-15 people using the database (most of them as read only) - but there are 2...
  11. lmn

    Convert text to number

    What is the protocol for converting text to a number. For survey purposes I have 1,2,3,4,5,N/A - so if it's a # - I convert it from text to the number and if it's N/A I make it null (for averaging) - but I'm not sure how to make the text format a number..... Anyone know this offhand?? :) Lisa
  12. lmn

    Changing hard coded SQL to always get current year - within IIf Statem

    Thanks for the assistance - doesn't work - says it has an INVALID DATE VALUE - but it gives me a start....I was thinking I may have to concatenate something - I just have to figure out how it likes it... Thx
  13. lmn

    Changing hard coded SQL to always get current year - within IIf Statem

    Yes, I know that - thanks for responding. The issue is that you can't put that in an Iif statement - for instance - I can't put.... Feb: IIf([MinOfConst Start]<=#2/1/Year(Now())# And [MaxOfConst End]>=#2/1/Year(Now()))#,&quot;x&quot;,Null) Am I making more sense??? ~L
  14. lmn

    Changing hard coded SQL to always get current year - within IIf Statem

    I'm using the below statement to see if a record exists, and if it does - to mark it with an x. The first problem is that it's not marking it with an x - but Null or -1. I can work with this - all I want it to do is distinguish between the two. The real problem is that I hardcoded this report...
  15. lmn

    excel into access

    ReluctantDataGuy, If you were to build an Access database for all of them to enter information into - do you... 1) Build a database and put it on a shared drive? (only one user could make changes at a time) 2) Create a web form and have it feed the data into a format that could be read by a DB...
  16. lmn

    How do I calculate if a date range falls within a specific month

    Thanks, Do you know if there is a way to hard code it so that it is always picking up the current year worth of information? This client works on a different fiscal year (so their 1st month is Feb - probably doesn't matter). I'm starting to think now that they may want to see a rolling 6...
  17. lmn

    How do I calculate if a date range falls within a specific month

    Thanks for your response....but what is TBL WEEKS? Do I need to create a table for all of the weeks in a year??? L
  18. lmn

    How do I calculate if a date range falls within a specific month

    Hello, I want to mark an X under the month if a project occurs during that given month. For example - say I have 3 vendors and 8 projects Start Dt End Dt Vendor A 01/01/03 05/04/03 Vendor A 02/03/03 02/04/03 Vendor A 04/01/03 12/01/03 Vendor B 01/05/03...
  19. lmn

    How would I code a date range that spans several months by month

    I am trying to figure out a workload report. If there are 3 projects: A: from 12/31/02 - 05/01/03 B: from 02/01/03 - 02/09/03 C: from 02/01/03 - 09/10/03 I want to show a workload report that shows each month and then indicates if that project is occuring within that month. How would I...
  20. lmn

    Ranking

    I have a query (SQL below) that ranks the surveys of projects against one another. What I want to do is write the query so that it ranks Bill's Development 4 projects (1, 2, 3 or 4) then it ranks Resource Systems Projects (1 or 2), etc..... What it's doing, however, is ranking all of the...

Part and Inventory Search

Back
Top