Recent content by outpatient

Hi, We built a help desk app here in access which works with a SQL server backend. Works pretty well. If someone has a purely access product, you may consider migrating the tables to SQL server and using the app as the interface. With a very complex database, I don't see anyone using access...

no, it cannot Sam Greene Workflow,DRM,DB MUSIC http://www.mp3.com/outpatient

Hello, If any college students are reading this the best thing to do is INTERN or find a job on campus writing reports or building DB's. Maybe even a clerk job in an office(something to get your foot in the door).I would have been out of luck after graduation last december if i hadn't done...

i guess you are getting your error on the line below 't3' AND BURSARY_INFORMATION = 't3's' Heres a vbscript example we use '***************************************************** 'Function : ParseApos 'Description : alters a string to allow SQL to resolve apostrophes 'Parameters : string...

>> Is there a way to launch a query without resorting to manual intput from the user? Keyword Search: Telepathy But seriously, to pass the value of a query to a field, use an update query. Sam Greene Workflow,DRM,DB MUSIC http://www.mp3.com/outpatient

I've heart 4-6 users recommended around here. Sam Greene Workflow,DRM,DB MUSIC http://www.mp3.com/outpatient

Try this, Make a new query in design view. hit the query tab when it asks what tables. Choose your two queries and blammo, you're in business(theoretically);) Sam Greene anyone in need of a rock induced headache? if so http://www.mp3.com/outpatient

Thanks for the tips Jim!! Sam Greene anyone in need of a rock induced headache? if so http://www.mp3.com/outpatient

Heres whacha do, go to your box in design view, bring up the properties. Go to the data tab a look for the row source field. There should be an sql statement in there. click the three dots to the right. This should bring up a query builder. find the field you want to sort and then click...

IN access, what you are talking about is the database splitter. It divides the db into 2 parts:The Tables, and then the forms querys etc. To get to the wizard, it Tools/Database utilities/Database Splitter. The splitter option may be hidden and you'll have to hit the double arrows at the...

Ninfan, first off, nin rocks, i had the pleasure of seeing them in phoenix and was blown away! Access is assuming you want a page of HTML for every page of your report. If you don't, just cut out the body of the second page and paste into the first one. I think you'll just cut the parts...

You might try doing a keyword search on Query by Form. You should find some help. Sam Greene anyone in need of a rock induced headache? if so http://www.mp3.com/outpatient

Heres what I used to reference mine, and I do feel your pain on this subject, its hard to find anything about it. [Forms]![Customers]![Problem Entry]![assigned to] main sub field I just looked up the difference between ! and . !(bang):separates an objects name form...

Hello....again, In your query that is generating the report modify the criteria to be the control on the form which contains the record number. So you would enter somthing like: Forms!MyForm.RecordNumber When the query runs, it pulls your record number and should just produce that one. Sam...

Ok, Let me make sure I got this right. Each department can be divided into divisions that have separate locations. This setup assumes a division can have only 1 support group. If they can have more than one, you'll have to add another table called an associative entitity to link the support...