Recent content by lmn

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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