Search results for query: *

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

Like Jane said, excel cells might truncate some of your data, so if you have long fields, you may have try somthing else. I would recommend the text export. Importing with access is very very EZ! In reference to wanting to create a db within a db. I'm sure you can open a new instance of...

Jenny, I was under the impression you wanted to send the info from access, not from an email client. Even creating a DB by itself and then importing into access, you go through the same steps. So just create the macro, tell it to output excel, then import into whatever db you need to. SIMPLE...

Jenny, You can output RTF,excel,txt,iis,asp's and html ,at least thats what's availiable in the macro builder. You could use excel and then import to whatever you are doing. I couldn't find all the output types on the MS site, so I'm not sure if you can send a table file. But if you are...

I just did this a couple days ago. To start off, i created a macro using the SendObject action then filled in the fields it asked for. Then I went to tools-macro-convert macro to visual basic, and it will convert to vb so you can fiddle around with it. Heres what i ended up with Dim strEmail...

Heres the tables again, they looked a little skewed. Building Floor Department ___________________________________ BuildID FloorID DeptID buildesc floordesc deptdesc buildID floorID Sam Greene anyone in need of a rock induced headache? if so...